Pivot Table Data Crunching
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
 Trade In this Item for up to £5.25
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library) for an Amazon.co.uk gift card of up to £5.25, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Authors
Discover books, learn about writers, and more.
Product Description
Product Description
PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.
About the Author
Bill Jelen, known worldwide as MrExcel, presents live Excel seminars to accountants throughout the U.S. His 20 books on Microsoft Excel include Special Edition Using Excel 2007, Pivot Table Data Crunching, and VBA and Macros for Microsoft Excel. Honored as a Microsoft MVP for Excel, he has produced 500 episodes of his "Learn Excel from MrExcel" video podcast. Michael Alexander, is a Microsoft Certified Application Developer (MCAD), Senior Program Manager for a top Texas technology firm, and principal of DataPigTechnologies, a developer of Excel tutorials. He is author of several books on data analysis with Access and Excel.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
0 of 1 people found the following review helpful
Format:Paperback
As an experienced user of Pivot Tables in previous verions of Excel - thanks to the help of previous editions of this superb book - I needed to get up to speed with changes in the 2010 version of the software.
I read through the book in less than an hour - and by that time my key questions had all been answered... and more.
Good value too!
I read through the book in less than an hour - and by that time my key questions had all been answered... and more.
Good value too!
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
7 reviews
7 of 8 people found the following review helpful
Yeah, but...
21 Nov 2011
Format:Paperback|Amazon Verified Purchase
I was ecstatic when I first got this book. Truly thankful that now I had the tome to help me master pivot tables like a pro. My happiness was short lived. I'm changing my review from a 3 star review to a 1 star. To be concise...the authors may be experts at Excel but they are horrible, absolutely horrible at making a training manual. It is not the content that is the challenge, oh no! It is the attempt at making sense out of the downloaded samples! Absolutely none, NONE of the examples in the Excel download match up with the figures or examples in the book. (ok, maybe "NONE" is an exaggeration, but not by much).
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. Imagine the guys from the movie Office Space and their printer, only add lighter fluid and cursing...then that'll be me! Afterwards, I would then proceed to my nearest book store (before it shuts down) and get another, different Pivot Table book, maybe something cheap and easy... maybe one of those Dummies guide books... again just for spite... that'll show 'em. (And to think I ended up getting their PowerPivot book too! Egad I don't look forward to that one)
If you're reading this, look for the other guy who posted a similar revue. Then you'll know I'm not nuts. The rest of these back slappers already had CIS degrees, no wonder why they're good at reading Klingon... good luck!
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. Imagine the guys from the movie Office Space and their printer, only add lighter fluid and cursing...then that'll be me! Afterwards, I would then proceed to my nearest book store (before it shuts down) and get another, different Pivot Table book, maybe something cheap and easy... maybe one of those Dummies guide books... again just for spite... that'll show 'em. (And to think I ended up getting their PowerPivot book too! Egad I don't look forward to that one)
If you're reading this, look for the other guy who posted a similar revue. Then you'll know I'm not nuts. The rest of these back slappers already had CIS degrees, no wonder why they're good at reading Klingon... good luck!
4 of 4 people found the following review helpful
Great explanations, solid examples, so-so book files
26 Sep 2011
Format:Paperback|Amazon Verified Purchase
Want to learn pivot tables fast? In plain English that's engaging and easy to understand? Pivot Table Data Crunching is the book for you. Bill Jelen and Michael Alexander use real world examples and step by step walkthroughs to explain every feature and trick of Excel 2010's pivot table arsenal. The only reason I didn't give this book 5 stars is because the downloadable files didn't always jive with the text, and because I would've liked to see more hands-on activities within each chapter.
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.
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.
6 of 8 people found the following review helpful
Get another book
21 July 2011
Format:Paperback|Amazon Verified Purchase
I was very disappointed in that this books examples did not follow the book. References were changed without any idea where the author was. Incorrect Figures against the sample files. I makes learning too difficult and I would not recommend this to anyone
Were these reviews helpful?
Let us know
Listmania!
|
|
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
