Microsoft Office Tutorials and References
In Depth Information
In this chapter, you’ll learn how to create and edit PivotTables from an existing
worksheet, focus your PivotTable data using filters and Slicers, format PivotTables, and
create a PivotTable with data imported from a text file.
Practice Files Before you can complete the exercises in this chapter, you need to copy
the book’s practice files to your computer. The practice files you’ll use to complete the
exercises in this chapter are in the Chapter09 practice file folder. A complete list of
practice files is provided in “Using the Practice Files” at the beginning of this topic.
Analyzing Data Dynamically by Using PivotTables
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.
Troubleshooting The appearance of buttons and groups on the ribbon changes depending
on the width of the program window. For information about changing the appearance of
the ribbon to match our screen images, see “Modifying the Display of the Ribbon” at the
beginning of this topic.