Excel 2007 PivotTables and PivotCharts (Mr. Spreadsheet's Bookshelf)

By Peter G. Aitken

Book 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.

• Format: Paperback
• Language: English
• ISBN: 0470104872
• ISBN13: 9780470104873
• Release Date: April 2007
• Publisher: John Wiley & Sons
• Length: 300 Pages
• Weight: 0.99 lbs.
• Dimensions: 0.7" x 7.4" x 9.2"

Customer Reviews

Clean and useful

While I already use pivot's extensively, a few hours with this book and I'm already excited about taking them to the next level. I don't know vba extensively - just record macros and sometimes tweak the code. However, the info here about automating pivots with VBA could really make a difference in the work I do. This was easy to use - and will be a reference on my desk going forward.

A real lifesaver.

After struggling with pivot tables this book finally helped me to understand them. It's clear and has lots of examples. It deals with the problems you can run into also. It has really helped me at work where I need to use Excel for a lot of things.