Chapter 2: Generating Pivot Tables
In This Chapter
Understanding how to use pivot tables to summarize and analyze your data
The many methods for creating pivot tables
Pivoting the elements in the data table
Formatting a pivot table and changing the pivot table options
Creating a pivot chart at the same time as your pivot table
Using PowerPivot and Power View to do data modeling
The subject of this chapter is the pivot table, the name given to a special type of data summary table that you can use to analyze and reveal the relationships inherent in the data lists that you maintain in Excel. Pivot tables are great for summarizing particular values in a data list or database because they do their magic without making you create formulas to perform the calculations. Unlike the Subtotals feature, which is another summarizing feature (see Book VI, Chapter 1 for more information), pivot tables ...
