O'Reilly logo

Microsoft Office Excel® 2007 Data Analysis: Your Visual Blueprint™ for Creating and Analyzing Data, Charts, and PivotTables by Denise Etheridge

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 7. WORKING WITH PIVOTTABLES

Create a PivotTable

Excel offers you much more than a way of keeping track of your data and doing calculations. It also provides tools to analyze your data and thus understand it better so you can make more effective decisions.

One of the most useful tools, the PivotTable, is also one of the least understood. Similar to cross-tabulation in statistics, a PivotTable shows how data is distributed across categories. For example, you can analyze data and display how different products sell by region and by quarter. Alternatively, you can analyze income distribution or consumer preferences by gender and age bracket. PivotTables help you answer questions about your data.

You base PivotTables on lists. Lists are made up ...

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