Welcome to the home page of Excel 2007 PivotTables and PivotCharts: Your visual blueprint for interpreting and presenting Excel data! 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 |
| Want the big book picture? Check out the Table of Contents, which includes a detailed look at the topics I cover in each of the book's 11 chapters and 5 appendixes. |
| |
Sample Chapter |
| Want to know more about PivotTables? Read the full text of Chapter 1, which gives you some background on Excel's data analysis tools and shows you how PivotTables fit in. You also learn about the benefits of PivotTables, when you should use PivotTables, the basic features of a PivotTable, and some background about PivotCharts. |
| |
Index |
| Want to know whether the book covers a specific topic that's important to you or your work? Just take a look through the detailed Index, which lists all the topics that I cover in the book. |
 |
Example Files |
| Want to get your mitts on the example files that I use in the book? Who wouldn't! They're all available via the companion website maintained by Wiley Publishing. |
 |
Forum |
| Want to ask a question about the book or let the world know what you thought of it? Have your say in The Dialogue Box. | |