O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

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

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.

Tip

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

Creating a PivotTable

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