Microsoft Office Tutorials and References
In Depth Information
Analyzing data dynamically by using PivotTables
Pointing to a recommended PivotTable shows a preview image of what that PivotTable
would look like. To create it, just click the image of the arrangement you want to create and
TIP If Excel 2013 has no Recommended PivotTables for your data, it displays the option to
create a blank PivotTable.
If none of the Recommended PivotTables meet your needs, you can create a PivotTable by
adding individual fields. For instance, you can create a PivotTable with the same layout as
the worksheet described previously, which emphasizes totals by month, and then change
the PivotTable layout to have the rows represent the months of the year and the columns
represent the distribution centers. The new layout emphasizes the totals by regional
To create a PivotTable, your data must be 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 that represents the distribution center, date, month, week, weekday, day, and volume
for every day of the years 2012 and 2013.