[eBooksBoard]

Publisher John Wiley and Sons
Author(s) Peter G. Aitken
ISBN 0470104872
Release Date 16 April 2007

Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you.

From the Back Cover
Take full advantage of Excel’s interpretive power

Why do you need another book on Excel? Because this one is devoted to PivotTables and PivotCharts, Excel’s powerful tools that enable you to pull meaningful information from masses of seemingly meaningless data—information you can actually use.

If you’re new to PivotTables, this book is for you. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data and even how to create and manipulate PivotTables using VBA.

Most important, you’ll discover what these tools can do for you. Are you ready?

Peter Aitken’s Chart Toppers

* Topper # 1 Understanding and Creating PivotTables
* Topper # 2 Using Excel 2007’s PivotTable Tools
* Topper # 3 Working with PivotCharts
* Topper # 4 Using External and Multidimensional Data
* Topper # 5 Programming PivotTables with VBA

  This eBook: Download Excel 2007 PivotTables and PivotCharts
  Previous eBook: Microsoft Office Project 2007 All-in-One Desk Reference For Dummies
  Next eBook: Data Mining Using SAS Enterprise Miner
  Filed in: John Wiley • Microsoft Office • Microsoft Excel