Microsoft Office Tutorials and References
In Depth Information
Analyzing data dynamically by using PivotTables
Such a neutral presentation of your data is versatile, but it has limitations. First, although
you can use sorting and filtering to restrict the rows or columns shown, it’s difficult to
change the worksheet’s organization. For example, in this worksheet, you can’t easily
reorganize the contents of your worksheet so that the months are assigned to the rows and the
distribution centers are assigned to the columns.
To reorganize and redisplay your data dynamically, you can use the PivotTable tool. In Excel
2013, you can create Recommended PivotTables. To open the Recommended PivotTables
dialog box for a data set, click any cell in the data range that you want to summarize and
then, on the Insert tab of the ribbon, click Recommended PivotTables. When you do, Excel
displays a set of PivotTables that you can create quickly.