Share via


PivotTable Wizard

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