O'Reilly logo

Learn Office 2011 for Mac OS X 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

Chapter 17. Manipulating Data with PivotTables

In this chapter, we'll look at how you can manipulate the data in your worksheets to draw conclusions from it by creating PivotTables. PivotTables are great for asking questions of your data and looking at the data in different ways without having to enter it multiple times in separate worksheets.

We'll start by going over what PivotTables are and what you can do with them. After that, I'll show you how to create a PivotTable either by using Excel's automated tool or by placing the fields on the PivotTable framework manually, which gives you total control.

After you build a PivotTable, you'll often need to change it so that it shows different data or shows the same data differently. I'll show you several ...

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