PivotTables are one of the most powerful analysis tools available in Microsoft Excel. They let a user easily take a large table of data and summarize that data using any combination of fields in the table.
Learning PivotTables will help you substantially increase what you can do with Excel.
* * *
The
Easy Excel Essentials 2019
series of titles are for intermediate-level users who want to focus on one specific topic such as PivotTables, Charts, Conditional Formatting, or the IF Functions.
The content of each title is extracted from either
Excel 2019 Intermediate
or
Excel 2019 Formulas & Functions
which cover intermediate-level Excel topics in more detail.
These books are written using Excel 2019 and assuming that a user is working in that program. If you are using an older version of Excel, the
Easy Excel Essentials
series may be a better choice since it was written using Excel 2013 and for a more general audience of Excel users.