Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your 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:
Excel 2016 For Dummies Video Training
Discover what Excel can do for you with self-paced video lessons from For Dummies. Learn more.
Frequently Bought Together
Customers Who Bought This Item Also Bought
Top Customer Reviews
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.
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 ›
Author's handling of the subject is clear, highly, informative, well organized. With some professional quality editing this could become an EXCELLENT book. Even in it present form, it is very useful and recommended for anyone wanting to become proficient at using pivot tables and making mince meat of inordinately large data sets.
Bill Jelen's book will serve an excellent map into the world of Pivot Tables.
Those unfamiliar with Pivot Tables will find this book an efficient and effective teaching tool to gain significant proficiency very quickly.
Become proficient with Pivot Tables and soon you will wonder how did you ever got along without them.
Most Recent Customer Reviews
Great Read and Reference, thorough discussion on the use of Pivot Tables for Analyzing all sorts of data.Published on July 9, 2014 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 on June 5, 2014 by Kallipolis Rex
This THE best book about Excel 2010 PivotTables! I have all of Mr Excel's PivotTable Data Crunching Books back to Excel 2003. If you want to learn PT, this is THE book!Published on January 22, 2014 by Mike Excelisfun
Very useful for beginners in Pivot Table as for experts. A good basic knowledge of Excel is tough required to take advantage of this bookPublished on September 9, 2013 by Anne Lecloux
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