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

1. Pivot Table Fundamentals

In this Chapter

What Is a Pivot Table? 9

Why Should You Use a Pivot Table? 10

When Should You Use a Pivot Table? 11

The Anatomy of a Pivot Table 12

Pivot Tables Behind the Scenes 14

Limitations of Pivot Table Reports 15

What Is a Pivot Table?

Imagine that Excel is a large toolbox that contains different tools at your disposal. The pivot table is essentially one tool in your Excel toolbox. If a pivot table were indeed a physical tool that you could hold in your hand, a kaleidoscope would most accurately represent it.

When you look through a kaleidoscope at an object, you see that object in a different way. You can turn the kaleidoscope to move the details of the object around. The object itself doesn’t change, and it’s ...

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