O'Reilly logo

Pivot Table Data Crunching by Michael Alexander, Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

2. Creating a Basic Pivot Table

In this Chapter

Preparing Your Data for Pivot Table Reporting 17

Creating a Basic Pivot Table 22

Keeping Up with Changes in Your Data Source 33

Preparing Your Data for Pivot Table Reporting

When you have a family portrait taken, the photo-grapher takes the time to make sure the lighting is right, the poses are natural, and everyone smiles their best smile. This preparation ensures that the resulting photo is effective in its purpose—to show a beautiful, happy family.

When you create a pivot table report, you’re a photographer, taking a snapshot of your data. Taking time to make sure your data looks its best will ensure that your pivot table report is effective in accomplishing the task at hand.

One of the benefits ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required