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