Page 2 of 13PREVNEXT

PivotTable I: Get started with PivotTable reports in Excel 2007

Conceptual view of source data in Excel and a PivotTable report

Rows and rows of data summarized in a PivotTable report.

Imagine an Excel worksheet of sales figures with hundreds or thousands of rows of data. The worksheet lays out all the data about salespeople in two countries and how much they sold on individual days. But it's a lot of data to deal with — listed in row after row and divided into multiple columns. How can you get information out of the worksheet? How can you make sense out of all of this data?

Who sold the most overall? Who sold the most per quarter or per year? Which country has the most sales? You can get answers to all these questions with PivotTable reports — it's like turning a mob into a marching band. A PivotTable report turns all that data into small, concise reports that tell you exactly what you need to know.

Page 2 of 13PREVNEXT