O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

Creating and Laying Out a PivotTable

You can create a PivotTable either from a database table or from a range of data. If you have a database table already, as in the example, you can create the PivotTable from that. Otherwise, create the database table you'll use, or enter the data in a worksheet as usual without creating a database table.

Once your data is ready, you can create a PivotTable either automatically or manually. Which works best depends on your data and what you're trying to do with it, but often you can save time by creating a PivotTable automatically and then adjusting it as necessary. If an automatic PivotTable turns out not to be what you need, you can create the PivotTable manually from scratch instead.

Creating a PivotTable ...

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