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