Share via

PivotTable Wizard

  • Article

Creates pivot tables. Pivot tables are interactive worksheet tables that make it possible for you to summarize and analyze data from existing tables. You can choose either to save a pivot table directly in Microsoft Excel or to add one as an object on a form.

You must have Microsoft Excel with Microsoft Query installed on your computer in order to create a pivot table. For more information about pivot tables, see Microsoft Excel Help.

To run the PivotTable Wizard

  • From the Wizards submenu on the Tools menu, choose PivotTable.

Wizard Steps

PivotTable Wizard: Step 1 – Select Fields
PivotTable Wizard: Step 2 - Layout
PivotTable Wizard: Step 3 - Finish

See Also

Wizards Overview | PivotTable Wizard: Step 1 – Select Fields | PivotTable Wizard: Step 2 - Layout | PivotTable Wizard: Step 3 - Finish