Pivot Table Data Crunching: Microsoft Excel 2010 and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
Trade in Yours
For a £5.50 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Pivot Table Data Crunching on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library) [Paperback]

Bill Jelen , Michael Alexander
4.0 out of 5 stars  See all reviews (8 customer reviews)
RRP: £21.99
Price: £18.63 & FREE Delivery in the UK. Details
You Save: £3.36 (15%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 8 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 14 July? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition £11.04  
Paperback £18.63  
Trade In this Item for up to £5.50
Trade in Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library) for an Amazon Gift Card of up to £5.50, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
There is a newer edition of this item:
Excel 2013 Pivot Table Data Crunching (MrExcel Library) Excel 2013 Pivot Table Data Crunching (MrExcel Library) 4.5 out of 5 stars (2)
In stock.

Book Description

20 Oct 2010 MrExcel Library

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.


  • Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels
  • Includes proven PivotTable recipes for instant on-the-job results
  • Helps Excel users avoid common pitfalls and mistakes
  • Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen

  • Special Offers and Product Promotions

    • Spend £30 and get Norton 360 21.0 - 3 Computers, 1 Year 2014 for £24.99. Here's how (terms and conditions apply)

    Frequently Bought Together

    Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library) + Excel 2010 Bible + Excel 2010 Formulas (Mr. Spreadsheet's Bookshelf)
    Price For All Three: £66.21

    Buy the selected items together

    Product details

    • Paperback: 384 pages
    • Publisher: QUE; 1 edition (20 Oct 2010)
    • Language: English
    • ISBN-10: 0789743132
    • ISBN-13: 978-0789743138
    • Product Dimensions: 23 x 18 x 1.9 cm
    • Average Customer Review: 4.0 out of 5 stars  See all reviews (8 customer reviews)
    • Amazon Bestsellers Rank: 145,431 in Books (See Top 100 in Books)
    • See Complete Table of Contents

    More About the Authors

    Discover books, learn about writers, and more.

    Product Description

    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)
    Browse Sample Pages
    Front Cover | Copyright | Table of Contents | Excerpt | Index
    Search inside this book:

    What Other Items Do Customers Buy After Viewing This Item?

    Customer Reviews

    Most Helpful Customer Reviews
    2 of 2 people found the following review helpful
    1.0 out of 5 stars Good information, but difficult to follow 2 Mar 2014
    Format:Paperback|Verified Purchase
    I've been using excel since Excel 97, not for work use, mainly at home and various jobs created (in my opinion) fairly basic projects with a little vba, never used pivot tables before and looking to learn for a potential new job, after getting my way part into another book (which is truly excellent and well written, Microsoft® Excel® 2010: Data Analysis and Business Modeling) I was assuming it would be a similar experience with this book. I am however finding the samples don't seem to relate easily to the book, I don't have any of my own data to work from, as stated this is bought to get some knowledge for a possible job, so for me, as someone who hasn't used Pivot Tables before I'm finding it hard. Although I've now got a good understanding, it takes a lot of re-reading to understand what is being said.

    There is a lot of good info in this, and the author clearly knows what's going on, but I'm only at Chapter 3, and have found several mistakes which keep making me doubt myself, as I follow what the book says and isn't the same, which is a bit frustrating.

    If you have a lot of patience you can gain a lot from this, but don't expect things like 'now load example x' it just assumes you know which example file your working with, doesn't tell you when sheets change, and doesn't explain which sheet you should be using, for example, Chapter 3 assumes you are working with a certain sheet, this sheet seems to not exist in the chapter 3 sample file, the chapter 3 sample file also contains about 20 worksheets that are in a seemingly random order with nothing explaining what they are for? you may thing the sheets titled fig 3.4 matches the diagram 3.4 in the book, but it does not...
    Read more ›
    Comment | 
    Was this review helpful to you?
    1 of 1 people found the following review helpful
    5.0 out of 5 stars It's gets me excited 4 Feb 2014
    Format:Paperback|Verified Purchase
    I love this stuff formulas, functions, pivot tables - must be a geek, although I don't look like a geek
    Comment | 
    Was this review helpful to you?
    1 of 1 people found the following review helpful
    Format:Paperback|Verified Purchase
    I surely appreciate the frustrations of the people who complain that thee examples do not follow the book...
    ... but for me, I wanted a good reference with practical examples to read from the book, quickly, and it does the trick.
    Pivot Tables can appear very easy at the beginning, but there is a lot to dig in and it can become overwhelmingly complex. The authors make sure to explain it in plain English, but of course you need to read back and forth a few times. On the other hand, everything is practical and you will quickly find ways to experience their solutions on your own data. So for me, you do not need to download examples and work from those... just start from your own data.
    After much effort, I am the uncontested master of pivot table within my company... worth the effort and small price..
    Comment | 
    Was this review helpful to you?
    3 of 4 people found the following review helpful
    5.0 out of 5 stars Excellent Problem Solver 8 Dec 2010
    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!
    Comment | 
    Was this review helpful to you?
    Would you like to see more reviews about this item?
    Were these reviews helpful?   Let us know

    Customer Discussions

    This product's forum
    Discussion Replies Latest Post
    No discussions yet

    Ask questions, Share opinions, Gain insight
    Start a new discussion
    First post:
    Prompts for sign-in

    Search Customer Discussions
    Search all Amazon discussions

    Look for similar items by category