Excel 2013 Pivot Table Data Crunching

3. Customizing a Pivot Table

In This Chapter

Making Common Cosmetic Changes

Making Report Layout Changes

Customizing the Pivot Table Appearance with Styles and Themes

Changing Summary Calculations

Adding and Removing Subtotals

Changing the Calculation in a Value Field

Although pivot tables provide an extremely fast way to summarize data, sometimes the pivot table defaults are not exactly what you need. In this case, you can use many powerful settings to tweak the information in your pivot table. These tweaks range from making cosmetic changes to changing the underlying calculation used in the pivot table.

In Excel 2013, you find controls to customize the pivot table in myriad places: the Analyze tab, Design tab, Field Settings dialog, Data ...