O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

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

Creating a PivotTable

SO WHAT IS A PIVOTTABLE, ANYWAY? The name doesn’t really reveal too much, but if you think about what the word pivot means— “A person or thing on which something depends or turns; the central or crucial factor”—you’re getting closer to the idea. A PivotTable is a tool by which you can turn your data and view it from any side or angle. Got a list of customers? A PivotTable allows you to quickly see only the people from a given state and to choose exactly the information that will be displayed about those customers. It even allows you to perform a mathematical function on that data, such as an average of their yearly sales. The State field (column) within that list therefore becomes the pivot point—the crucial factor on which ...

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