Microsoft Office Tutorials and References
In Depth Information
The data in the worksheet is organized so that each row represents a distribution center
and each column represents a month of the year. When presented in this arrangement,
the monthly totals for all centers and the yearly total for each distribution center are
given equal billing: neither set of totals stands out.
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.
The Excel tool to reorganize and redisplay your data dynamically is the PivotTable. You
can create a PivotTable, or dynamic worksheet, that enables you to reorganize and filter
your data on the fly. 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
distribution center.
Search JabSto ::

Custom Search