Page 7 of 16PREVNEXT

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

Sales figures in Excel

Sales figures that go on and on.

Imagine that Excel is open and you're looking at sales figures. In this example there are 799 rows of sales listed by country, salesperson, and order amount.

How can you make the data more understandable? To find out, you would start by asking yourself what you need to know:

  • How much has each salesperson sold?
  • What are the sales amounts by country?

When you're ready to get the answers, you would click anywhere in the data, then start the wizard by clicking PivotTable and PivotChart Report on the Data menu.

Note    The PivotTable and PivotChart Wizard is also used to create PivotChart reports, graphical versions of PivotTable reports. PivotChart reports are not discussed in this course.

Page 7 of 16PREVNEXT