Microsoft Office Tutorials and References
In Depth Information
6. Verify that the Existing worksheet option is selected, and then click OK .
Excel imports the data into your workbook.
7. On the Home tab, in the Styles group, click Format as Table , and then click the
first table style.
The Format As Table dialog box opens.
8. Verify that the My table has headers check box is selected and that the range
=$A$1:$H$6571 appears in the Where is the data for your table? box, and
then click OK .
A confirmation dialog box opens.
9. Click Yes to confirm you want to create the Excel table and break its link to the
external data source.
Excel creates an Excel table from your imported data.
10. On the Insert tab, in the Tables group, click PivotTable .
The Create PivotTable dialog box opens.
11. Verify that the Select a table or range option is selected, that Table1 appears in
the Table/Range field, and that the New Worksheet option is selected.
12. Click OK .
Excel creates the PivotTable on a new worksheet.
13. In the PivotTable Field List task pane, drag the Volume field header to the
14. Drag the Weekday field header to the Column Labels area.
15. Drag the Center field header to the Row Labels data area.