Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Chapter 15

Using pivot tables to analyze data

Creating your first pivot table

Dealing with the compact layout

Rearranging a pivot table

Finishing touches: numeric formatting and removing blanks

Three things you must know when using pivot tables

Calculating and roll-ups with pivot tables

Formatting a pivot table

Setting defaults for future pivot tables

Finding more information on pivot tables

A pivot table enables you to summarize thousands or millions of records of data to a one-page summary in just a few clicks.

Suppose you have 400,000 records of transactional data. It is easy for some people to look at this and figure out that it represents $x million. But to learn some things about the data, you need to do some more analysis to spot trends ...