Chapter 10. Using Pivot Tables to Analyze Data

In this chapter

What Is Possible with Pivot Tables 192

Preparing Your Data for Pivot Table Analysis 192

Creating Your First Pivot Table 200

Changing the Default Layout of a Pivot Table 202

Adding New Fields to a Pivot Table 208

Eliminating Blank Cells from a Pivot Table 209

Using Pivot Table Legacy Mode 210

Pivot Table Limitations 211

For 12 years, pivot tables have been the most powerful feature in Excel. However, Microsoft estimates that fewer than 10% of people use pivot tables. To make this helpful feature less intimidating in Excel 2007, Microsoft rewrote the pivot table interface to make it vastly simpler to use.

What Is Possible with Pivot Tables


Although I loved the drag-and-drop functionality ...

Get Special Edition Using Microsoft® Office Excel® 2007 now with the O’Reilly learning platform.

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