Excel® 2016 Pivot Table Data Crunching

3. Customizing a Pivot Table

In This Chapter

Making Common Cosmetic Changes

Making Report Layout Changes

Customizing a Pivot Table’s 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 such cases, you can use many powerful settings to tweak pivot tables. These tweaks range from making cosmetic changes to changing the underlying calculation used in the pivot table.

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