O'Reilly logo

Excel 2013 All-in-One For Dummies by Greg Harvey

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

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