Learn How To Create A Pivot Table With Fewer Clicks With This Microsoft Excel Tutorial
Page content
Strategy:
This method is only available in Excel 2000 and newer versions.
Follow these steps.
-
Select a single cell in the original data, as shown in Fig. 911.
-
From the menu, select Data – PivotTable. Click Finish, as shown in Fig. 912.
You are given a blank pivot table on a new sheet, as shown in Fig. 913.
- Drag fields from the field list to the table, as shown in Fig. 914.
**
Summary:
This visual method for creating a pivot table is faster and more intuitive.
Commands Discussed:
PivotTable
**