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 ...

Get Beginning Pivot Tables in Excel 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.