Microsoft Office Tutorials and References
In Depth Information
Analyzing data dynamically by using PivotTables
PRACTICE FILES To complete the exercises in this chapter, you need the practice files
contained in the Chapter10 practice file folder. For more information, see “Download
the practice files” in this topic’s Introduction.
Analyzing data dynamically by
With Excel worksheets, you can gather and present important data, but the standard
worksheet can’t be changed from its original configuration easily. As an example, consider a
worksheet that records monthly package volumes for each of nine distribution centers in
the United States.
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.