Page 9 of 16PREVNEXT

PivotTable I: What's so great about PivotTable reports?

PivotTable report layout area and PivotTable Field List

Callout 1 PivotTable Field List to drag items from.
Callout 2 PivotTable layout area to drag items onto.

The wizard takes less than a second to prepare a new worksheet with everything you would need to create a PivotTable view of your data: the PivotTable Field List to drag items from, the layout area to drag items onto, and the PivotTable toolbar.

In the practice session at the end of the lesson, you'll see for yourself: It takes just a few seconds more for you to lay out the PivotTable view than it does for the wizard to prepare the worksheet area.

Page 9 of 16PREVNEXT