Microsoft Office Tutorials and References
In Depth Information
Analyzing data dynamically by using PivotTables
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 workbook located in the Chapter10 practice file folder
to complete this exercise. Open the workbook, and then follow the steps.
Click any cell in the Excel table.
On the Insert tab, in the Tables group, click Recommended PivotTables to open the
Recommended PivotTables dialog box.
Click the second icon, labeled Sum of Volume by Weekday .
Click OK to create the PivotTable.
Click the Sheet1 worksheet’s sheet tab to display that worksheet.
If necessary, click any cell in the Excel table.
On the Insert tab, in the Tables group, click the PivotTable button to open the
PivotTable dialog box.