Page 8 of 16PREVNEXT

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

The PivotTable and PivotChart Wizard prepares data for pivoting

Click Finish in the PivotTable and PivotChart Wizard to use default settings.

Once the wizard is opened, you would click Finish. That's it. You could spend more time with the wizard, but in this example it's not necessary. Clicking Finish tells the wizard to use its default settings. By default, the wizard will:

  • Use data in an Excel list or in a database.
  • Prepare a layout area for creating a PivotTable report.
  • Use all the data on the list.
  • Place the report layout area on a new worksheet.
Page 8 of 16PREVNEXT