Beginning Pivot Tables in Excel 2007

CHAPTER 3Modifying a Pivot Table

In this chapter, you'll modify the insurance data pivot table you created in Chapter 2 by adding and removing fields and by filtering the pivot table so only specific data is summarized. You'll see what happens when the data in the source table changes, and you'll learn how to view a different type of summary for the values. You'll use a built-in formatting feature to change the appearance of the pivot table, and you'll see how to delete a pivot table if you no longer need it.

By the end of this chapter, I'll have covered the basic of creating and modifying a pivot table. In the remaining chapters, you'll explore the pivot table features in depth so that you fully understand all that a pivot table can do.

To ...