Chapter 8. PivotTables and Pivot Charts
There's that word againâTables. They're back, but this time we're going to look at tables from a different angleâalmost literallyâby subjecting all those columns and rows to a new and more informative way of presenting their dataâthe PivotTable.
PivotTables are a most powerful and nimble way to aggregate dataâbut that introduction calls for a bit of...well, introduction. After all, adding a column of numbers is a form of data aggregation, too, but you wouldn't bother to apply a PivotTable to that task (though you could). PivotTables do something else, something more. A lot more.
It's one thing to be able to total a range of numbersâeven a very large rangeâand that can be a most important capability. ...
Get Beginning Microsoft Excel 2010 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.