June 2013
Intermediate to advanced
912 pages
27h 36m
English
Customizing the default new workbook
Manipulating text with functions
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 ...