CHAPTER 6PivotTables

PivotTables are a neat feature of Excel 2007 that allows users to summarize and analyze data. By adding or removing data elements from an onscreen selection tool, your users can easily reshape their data for analysis or reporting.

A PivotTable report provides an interactive method to quickly and easily summarize large amounts of data (without the need to export the data to an external database system like Microsoft Access or an external reporting tool).

Here are some examples of when you might want to use a PivotTable to display your data:

  • To query large amounts of data and create different views
  • To aggregate and subtotal data, and/or create custom calculations and formulas
  • To expand and collapse levels of data
  • To move ...

Get Pro Excel 2007 VBA now with the O’Reilly learning platform.

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