O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel 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

Chapter 10. Using Pivot Tables to Analyze Data

In this chapter

What Is Possible with Pivot Tables 192

Preparing Your Data for Pivot Table Analysis 192

Creating Your First Pivot Table 200

Changing the Default Layout of a Pivot Table 202

Adding New Fields to a Pivot Table 208

Eliminating Blank Cells from a Pivot Table 209

Using Pivot Table Legacy Mode 210

Pivot Table Limitations 211

For 12 years, pivot tables have been the most powerful feature in Excel. However, Microsoft estimates that fewer than 10% of people use pivot tables. To make this helpful feature less intimidating in Excel 2007, Microsoft rewrote the pivot table interface to make it vastly simpler to use.

What Is Possible with Pivot Tables

Note

Although I loved the drag-and-drop functionality ...

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