Microsoft Excel 2019 Pivot Table Data Crunching

Chapter 3Customizing a pivot table

In this chapter, you will:

• Make common cosmetic changes

• Make report layout changes

• Customize a pivot table’s appearance with styles and themes

• Change summary calculations

• Change the calculation in a value field

• Add and remove subtotals

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.

Many of the changes in this chapter can be customized for all future pivot tables using the new pivot table default settings. If you find yourself always ...