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 ...
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours 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.
