To get the free app, enter your email address or mobile phone number.
Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
There is a newer edition of this item:
Frequently Bought Together
Customers Who Bought This Item Also Bought
More About the AuthorsDiscover books, learn about writers, read author blogs, and more.
Top Customer Reviews
In one of the chapter downloads there can be approximately 20 separate worksheets, each intended for a different problem, figure or example in the complimentary book chapter. The problem is that they are not in order nor are they named the same in both places. It's a hunt-n-peck marathon trying to match up the figure or example in the book with the proper worksheet. I do not recommend this book for anyone who wants to learn Pivot Tables. Go get a different book that doesn't provide a labyrinth to navigate through in order to match the download samples with the book.
I will continue pushing through this quagmire simply out of spite and having paid good money for the book (sunk cost be damned!) until I either a) finally learn what I sought out to learn, b) give up and go get another book, c) rip the book to shreds (which I normally consider sacrilegious since books should be treated with reverence and respect, never laid open and face down and never dog eared) and then pour lighter fluid on it, light it with a wooden match and then proceed to curse the authors something evil and wicked until I'm out of breath.Read more ›
Regarding the downloadable files, they tend to match the "after" figures in the text, and not the "before" figures. So, if you'd like to follow along with the steps in the book, you often need to undo a bunch of organization and calculation steps. Chapter 3 is a good example: the tables where you are guided through modifying the table style already have a custom theme applied. For future volumes, I'd suggest the authors prepare two sets of worksheets for each chapter. One set for readers to modify and another set showing the final product.
I also would've liked twice as many case studies in the first 3 or 4 chapters. For me, practice is the best contributor to retention.
Having pointed out those two shortcomings, I feel compelled to restate how absurdly wonderful the written explanations in the book are. I've been using a "New Perspectives" textbook for the past year to learn Excel. It's brief pivot table chapter left me confused. After diving into Pivot Table Data Crunching this past weekend, I now feel confident that I have a handle on the topic and can translate that knowledge into real-world time savings at work.
Most Recent Customer Reviews
Mildly revised version of previous editions. Insignificant improvement from Bill Jelen's similar publication relating to Pivot Tables in Excel 2007. Read morePublished 17 months ago by BOOKBURNER01
Great Read and Reference, thorough discussion on the use of Pivot Tables for Analyzing all sorts of data.Published 19 months ago by JCG
This was Excellent as always for Bill. Targeted understanding of the key concepts and advanced ideas that I need for work. Good stuff!Published 20 months ago by sc
I particularly needed more information about how to use Excel pivot table to massage Cubes data ... excellent book !Published on July 15, 2013 by Jose Guillermo Banda