O'Reilly logo

Excel 2010 Made Simple by Abbott Katz

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 8

PivotTables: Data Aggregation Without the Aggravation

PivotTables providea potent and flexible way to organize—and reorganize—the records in a database or table, by letting you break out the data into a variety of visual arrangements. And once you've done so, you can quickly transform the results into a PivotChart.

PivotTables also let you group data; for example, you can bundle test score results in groups of 10 points—that is, tally the number of students who score between 100 and 91, 90 and 81, and so on.

And starting with Excel 2010, Microsoft has introduced a new PivotTable feature called the Slicer, which gives you a clearer presentation of filtered data. I'll explain the Slicer soon, although it's similar to the filters discussed ...

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