Pivot Table Data Crunching for Microsoft Office Excel 2007

by Bill Jelen, Michael Alexander, Michael Alexander

Book Overview

This book consolidates all the best functionality of pivot tables into one guide that provides you with a meaningful tutorial, offering practical solutions to day-to-day problems. Within just the... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0789736012
• ISBN13: 9780789736017
• Release Date: January 2006
• Publisher: Que
• Length: 338 Pages
• Weight: 1.30 lbs.
• Dimensions: 0.8" x 6.9" x 9.1"

Customer Reviews

Great reference

I use pivot tables all of the time so I bought this book to see if there are things I can learn. I did and have learned a lot and it is a great reference. The first two chapters cover the basics but it advances very quickly after that. Writing is very bullet-ed and you can easily look up what you are looking for. A must have for all beginner, intermediate, and even advanced Pivot Table users! Note of caution is that if you do not have Excel 2007 this book is not that useful as a lot of the features for Pivot Tables have changed from the 2003 to the 2007 version.

Pivot Table Power User

I count myself as a power Excel user and experienced Pivot Table wiz, I found this book to be very helpful, also good for novice

Great stuff

This book helped tremendously during my early stages using PT, without a doubt I would recommend this book to someone who just started to incorporate Pivot Table into their work. One recommendation, It would be nice if a CD with all the work examples came with the book, unfortunately you have to download the example files from a website.

It does make Pivot Table EASY!

I have no previous experience of either Pivot Table or Office 2007. However, by following the instructions of this book and keep practicing, I don't feel pivot table is so difficult as I did before. Highly recommend this book.

Buidence from the Experts

Pivot Tables are one of the most powerful yet least used features of Excel. The author's MrExcel web site conducted a survey that showed that less than 42% of Excell users make use of pivot tables. I believe his estimate is high. Only experts are likely to visit his web site. I don't believe that 42% of the people who use Excel have even heard of pivot tables. I further think that part of the problem is the name Pivot Table. This is primarily a Microsoft term (Microsoft has trademarked the word PivotTable - with no space), but the original functionality came from Lotus Improv. It's foolish for me to try to explain pivot tables here when the book exists. Let me just say that if your task involves taking a lot of data that would make a lot more sense to you or your boss if it were summarized in various ways, Pivot Tables are for you, and the authors of this book are recognized experts in the field. Note that the book has been brought up to date to cover Excel 2007. There are a number of changes in 2007 that are distinct improvements over previous versions but that require you to do things that are a bit different while the overall functionality remains basically the same.