Paul McFedries

“Information appears to stew out of me naturally, like the precious ottar of roses out of the otter.” —⁠Mark Twain

Microsoft Excel 2007 PivotTables and PivotCharts

Your visual blueprint for interpreting and presenting Excel data.

Front cover of the book Microsoft Excel 2007 PivotTables and PivotCharts

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
Buy It