Microsoft Excel 2007 PivotTables and PivotCharts
As you know, Excel tables and external databases can contain hundreds, thousands, or even millions of records. Analyzing that much data can be a nightmare without the right kinds of tools. To help, Excel offers a powerful data analysis tool called a PivotTable. This tool enables you to summarize even the largest table or database in a concise tabular format. You can then manipulate the layout of — or pivot — the table to see different views of your data. This book teaches you everything you need to know (and, indeed, just about everything there is to know) about PivotTables. You learn how to create them, edit them, pivot them, format them, calculate with them, and much more.
Please use the following links to learn more about the book. (For some of the links you'll need a program that can open PDF files, such as Adobe Reader.)
- Table of Contents (130 KB PDF)
- Sample Chapter (444 KB PDF)
- Index (208 KB PDF)
- Example Files