O'Reilly logo

Master VISUALLY® Excel® 2010 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required