Microsoft Office Tutorials and References
In Depth Information
Analyzing data dynamically by using PivotTables
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 10, 2013 as a
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.
In this dialog box, you verify the data source for your PivotTable and whether you want to
create a PivotTable on a new worksheet or an existing worksheet. After you click OK, Excel
displays a new or existing worksheet and displays the PivotTable Fields pane.
TIP You should always place your PivotTable on its own worksheet to avoid cluttering the