Book Info
- Publisher: Wiley Publishing
- Pages: 290
- Price: US$29.99
- Pub. date: November 5, 2007
- Category: productivity
- Tags: analysis, beginner, Excel, intermediate, Office, Office 2007
- Example files: Download this book’s example files to your device (ZIP file; 2.1 MB).
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. Related Books