Microsoft Office Tutorials and References
In Depth Information
To create a PivotTable, you must have your data collected in a list. Excel tables mesh
perfectly with PivotTable dynamic views; not only do Excel tables have a well-defined
column and row structure, but the ability to refer to an Excel table by its name also
greatly simplifies PivotTable creation and management.
In the Excel table used to create the distribution PivotTable, each row of the table
contains a value representing the distribution center, date, month, week, weekday, day, and
volume for every day of the years 2009 and 2010.
Excel needs that data when it creates the PivotTable so that it can maintain
relationships among the data. If you want to filter your PivotTable so that it shows all package
volumes on Thursdays in January, for example, Excel must be able to identify January 11
as a Thursday.
After you create an Excel table, you can click any cell in the table, display the Insert tab
and then, in the Tables group, click PivotTable to open the Create PivotTable dialog box.