Introducing PivotTables
Michael Alexander, Dick Kusleika, John Walkenbach · 2018
The PivotTable feature is perhaps the most technologically sophisticated component in Excel. The most powerful aspect of a PivotTable is its interactivity. After users creates a PivotTable, they can rearrange the information in almost any way imaginable and even insert special formulas that perform new calculations. With a few mouse clicks, user can apply formatting to a PivotTable to convert it into a report, albeit with a few limitations. This chapter provides many examples that demonstrate how easy it is to create powerful data summaries using PivotTables. It describes the basic steps required to create a PivotTable using the bank account data. By default, PivotTables use General number formatting. To change the number format for all data, right-click any value and choose Number Format from the shortcut menu. Then use the Format Cells dialog box to change the number format for the displayed data.