Skip to Main Content
Microsoft Office Inside Out: 2013 Edition
book

Microsoft Office Inside Out: 2013 Edition

by Ed Bott and Carl Siechert
June 2013
Intermediate to advanced content levelIntermediate to advanced
912 pages
27h 36m
English
Microsoft Press
Content preview from Microsoft Office Inside Out: 2013 Edition

Chapter 14. Excel 2013 Inside Out

Customizing the default new workbook

Using PivotTables

Manipulating text with functions

Advanced worksheet formatting

Printing a worksheet

Our favorite Excel tweaks and tips

IN THIS CHAPTER, we look at Excel’s more advanced features, including the one that separates a real Excel power user from a mere poser: PivotTable reports. We explain how to start with a simple list and summarize it from multiple angles using these versatile reports.

For formatting fanatics, we offer a collection of expert techniques to help you save and reuse custom number formats and cell styles. If you’re trying to extract the useful parts of big blobs of imported text, you’ll appreciate our instructions on how to transform and manipulate text ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Outlook 2013 Inside Out

Microsoft Outlook 2013 Inside Out

Jim Boyce
Office 2013 Bible: The Comprehensive Tutorial Resource

Office 2013 Bible: The Comprehensive Tutorial Resource

Lisa A. Bucki, John Walkenbach, Michael Alexander, Dick Kusleika, Faithe Wempen

Publisher Resources

ISBN: 9780735677517Purchase book