Excel 2010 Made Simple

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