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

Understanding What PivotTables Are and What You Can Do with Them

A PivotTable is a special kind of report that rearranges the fields and records in a table into a different order so that you can examine their relationships. You pivot (in other words, rotate) the columns in a PivotTable to display the data summarized in a different way.

For example, take a look at the worksheet shown in Figure 12–1. This worksheet contains a data table that tracks sales made by a company with four product lines: Hardware, Software, Services, and Supplies. The table uses the following columns:

  • Sale. A unique sequential number used to identify each sale.
  • Year, Month, and Day. The year, month, and day of the sale. Having these items in separate columns makes it ...

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