Beginning Pivot Tables in Excel 2007

CHAPTER 2Creating a Pivot Table

In this chapter, you'll get up and running with pivot tables so you can see how quickly and easily you can build and modify them. You'll create a simple pivot table from the insurance policy Excel table you created in Chapter 1. After creating the pivot table, you'll examine its key features and see how you can quickly change the pivot table layout to get a different view of the data. You'll create a pivot chart from the pivot table data to create a visual summary that will make the data easy to understand at a glance.

Exploring an Insurance Policy Example

In this example, you'll use the insurance policy Excel table from Chapter 1, which you saved in the file named InsurancePolicies02.xlsx. If you did not create ...