Page 2 of 16PREVNEXT

PivotTable I: What's so great about PivotTable reports?

Frustrated figure overloaded with data in an Excel worksheet

More data than you know what to do with.

Imagine an Excel worksheet of sales figures for your company with hundreds—no, thousands—of rows of data. Everyone has questions about what the data means. How do you get the answers? PivotTable reports organize and summarize your data so that it doesn't just sit on a worksheet gathering dust. PivotTable reports offer comparisons, reveal patterns and relationships, and analyze trends. In this lesson you'll find out how PivotTable reports make it all so easy: They compare, they reveal, they analyze, by displaying different views of data, turning data into information that makes sense.

To continue reading this lesson on your own, click Next.

Page 2 of 16PREVNEXT