Product Description

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.

Product Details

• Amazon Sales Rank: #466550 in Books
• Published on: 2007-04-16
• Original language: English
• Number of items: 1
• Binding: Paperback
• 300 pages

Features

• ISBN13: 9780470104873
• Condition: NEW
• Notes: Brand New from Publisher. No Remainder Mark.
• Click here to view our Condition Guide and Shipping Prices

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

About the Author
Peter G. Aitken has written some 45 books and hundreds of articles on computer topics. His consulting firm, PGA Consulting, focuses on services involving Excel, including programming, custom templates, and troubleshooting. Peter is the coauthor of Excel 2007 Formulas and Functions For Dummies (Wiley).

John Walkenbach, Series Editor, has written more than 30 Excel books, including Excel 2007 VBA Programming For Dummies and Excel 2007 Bible, also from Wiley. Visit his popular Spreadsheet Page at www.j-walk.com/ss.

Customer Reviews

Not enough information here to justify a book.
This book should be a chapter in a larger book. It's quite elementary in some of the things it addresses about pivot tables (e.g. formatting numbers) and really doesn't get into some of the more advanced and challenging uses. Definitely for the beginner, but I don't think there's enough value here to justify a full book. Look elsewhere for a more comprehensive treatment.

Excellent!
As the previous books I bought from the autor, this one has excellent tips for new users and is a usefull guideline for the experienced ones.