Working with PivotTables

PivotTables help you arrange and consolidate data into well-defined tables. With a PivotTable, you can easily generate cross-tabulations and analyze information by rotating and moving column and row selections and by filtering. The original data remains unchanged, and the PivotTable is quickly generated even with large amounts of data. In Excel 2007 and Excel 2010, PivotTable data can also easily be displayed as a PivotChart.


A PivotTable is useful for quickly obtaining summary information from long lists or large amounts of data.

Creating a PivotTable

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.