23. Using Pivot Tables to Analyze Data

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

Pivot tables were introduced in Excel 95 and have been evolving ever since. Excel 2007 simplified the pivot table interface and added new filters. Excel 2010 offers new calculations, visual filters called slicers, and the capability to mash up million-row data sets using PowerPivot.

Suppose you have 400,000 records of transactional data. It is easy for some people to figure out that this represents $x million. But to learn some things about the data, you need to do some more analysis to spot trends in the data. A pivot table lets you analyze trends in data without having to worry ...

Get Microsoft Excel 2010 In Depth now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.