Chapter 22. Summarizing Data with PivotTables and PivotCharts

Understanding PivotTables

A PivotTable provides an easy way to summarize information stored in a range, a table, or an external data source. Using a PivotTable helps you present endless rows and columns of numbers in a variety of meaningful ways.

Suppose your worksheet contains sales information by day for various types of sales made by a cable service provider. The worksheet tracks the date of the sale, the amount, the type of service, whether the sale was made by customer service or direct marketing, the location of the branch that made the sale, and the type of customer — new or existing — who made the purchase. Just viewing the worksheet in its native form would not help you analyze ...

Get Master VISUALLY® Excel® 2010 now with O’Reilly online learning.

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