O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

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

What Is a Pivot Table?

A pivot table lets you analyze, summarize, and manipulate data in large lists, databases, worksheets, workbooks, tables, or other collections of data. Pivot tables offer flexible and intuitive analysis of data. It's called a pivot table because you can move fields with the mouse to provide different types of summary lists; that is, the table can change, or “pivot.”

Although the data that appears in pivot tables looks like any other worksheet data, you cannot directly enter or change the data in the data area of a pivot table. The pivot table is linked to the source data, and what you see in the cells of the table are read-only amounts. However, you can change the formatting (Number, Alignment, Font, Border, Patterns) and ...

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