Chapter 2: Generating Pivot Tables

In This Chapter

arrow.png Understanding how to use pivot tables to summarize and analyze your data

arrow.png The many methods for creating pivot tables

arrow.png Pivoting the elements in the data table

arrow.png Formatting a pivot table and changing the pivot table options

arrow.png Creating a pivot chart at the same time as your pivot table

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

Get Excel 2013 All-in-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.