O'Reilly logo

Excel 2010: The Missing Manual by Matthew MacDonald

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

Building Pivot Tables

Now that you've learned the role that pivot tables play in summarizing data, it's time to create your own. Before you begin, you need to have a long list of raw data that you want to summarize. You could use the customer list from the previous example, but it's too small to really show the benefits of pivot tables. A better example is something like the list of order information shown in Figure 22-4.

This worksheet shows some entries from an order list of 2,155 grocery store items. Lists like this make great pivot table candidates.

Figure 22-4. This worksheet shows some entries from an order list of 2,155 grocery store items. Lists like this make great pivot table candidates.

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