Excel 2007 PivotTables and PivotCharts

Excel 2007 PivotTables and PivotCharts

5.0 1
by Peter G. Aitken
     
 

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;

Overview

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.

Editorial Reviews

The Barnes & Noble Review
Excel PivotTables and PivotCharts can instantly reveal insights that would otherwise need to be pried loose with a crowbar -- or stay buried in your data forever. With Excel 2007, Microsoft has revamped these features. But expert guidance is as welcome as ever -- especially, the help and hands-on walkthroughs Peter Aitken offers here.

Aitken's no-experience-necessary tutorial starts with the absolute basics: choosing internal and external data sources. You'll master Excel 2007's updated PivotTable/PivotChart toolset, including its powerful PivotTable components. And, since owning a hammer doesn't make everything a nail, Aitken also explains when PivotTables aren't the best solution, and points you to better alternatives.

By now, you're ready for the "majors": using PivotTables with multidimensional data in real OLAP applications. Aitken demystifies this; then introduces the fine art of automating PivotTables with VBA. You'll never look at your data the same way again. Bill Camarda, from the May 2007 Read Only

Product Details

ISBN-13:
9780470104873
Publisher:
Wiley
Publication date:
04/09/2007
Series:
Mr. Spreadsheet's Bookshelf Series, #4
Pages:
312
Product dimensions:
7.40(w) x 9.20(h) x 0.70(d)

Meet 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

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Excel 2007 PivotTables and PivotCharts 5 out of 5 based on 0 ratings. 1 reviews.
Nkee More than 1 year ago
Easy to read, comprehensive, entertaining. This sounds funny, but the 2003 version of the book really did change my life. I'm not kidding. PivotTables are such a powerful analytical tool and this book is an excellent way to learn how to use them.