Microsoft Office Tutorials and References
In Depth Information
In this exercise, you’ll create a PivotTable by using data from a table, add fields to
the PivotTable, and then pivot the PivotTable.
SET UP You need the Creating_start workbook located in your Chapter09 practice
file folder to complete this exercise. Start Excel, open the Creating_start workbook,
and save it as Creating . Then follow the steps.
1. Click any cell in the Excel table.
2. On the Insert tab, in the Tables group, click the PivotTable button (not the arrow).
The Create PivotTable dialog box opens.
3. Verify that the DailyVolumes table name appears in the Table/Range field and
that the New Worksheet option is selected.
4. Click OK .
Excel creates a PivotTable on a new worksheet.
5. In the PivotTable Field List task pane, drag the Center field header to the Row
Excel adds the Center field values to the PivotTable row area.