FREE Delivery in the UK.
Only 5 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
+ £2.80 UK delivery
Used: Good | Details
Sold by Nearfine
Condition: Used: Good
Comment: A good reading copy. May contain markings or be a withdrawn library copy. Expect delivery in 2-3 weeks.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library) Paperback – 3 Jun 2010

4.0 out of 5 stars 9 customer reviews

See all 3 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£21.99
£21.99 £17.79
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
£21.99 FREE Delivery in the UK. Only 5 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

Frequently Bought Together

  • PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library)
  • +
  • VBA and Macros: Microsoft Excel 2010 (MrExcel Library)
  • +
  • Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library)
Total price: £55.17
Buy the selected items together

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.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.



Product details

  • Paperback: 336 pages
  • Publisher: QUE; 1 edition (3 Jun. 2010)
  • Language: English
  • ISBN-10: 0789743159
  • ISBN-13: 978-0789743152
  • Product Dimensions: 17.5 x 2.3 x 22.6 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Bestsellers Rank: 566,388 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From the Back Cover

ANALYZE HUGE AMOUNTS OF BUSINESS DATA FASTER, MORE EASILY, AND MORE ACCURATELY! Use Microsoft's free PowerPivot add-in for Excel 2010 to analyze immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and make better decisions in less time! Simple, step-by-step instructions walk you through installing PowerPivot, importing data, using PivotTables with PowerPivot, using super-powerful DAX functions and measures, reporting to print or SharePoint, and a whole lot more. Whatever your Excel data analysis experience, this book will help you use PowerPivot to get the right answers, right now-without IT's help! - Import and integrate data from spreadsheets, SQL Server, Access, Oracle, text files, Atom data feeds, and other sources - Analyze multiple tables together, without complicated VLOOKUPs - Format, sort, and filter data in the PowerPivot window - Add calculated columns using new DAX functions - Create powerful reports from PowerPivot data-and format them so executives instantly get your point - Discover PivotTable tricks that work even better in PowerPivot - Control multiple PivotTable elements on one worksheet, with one set of Excel 2010 Slicers - Use DAX Measures to quickly perform tasks that were difficult or impossible with Calculated Fields - Compare today's sales to yesterday's-or to sales from the parallel period last fiscal year. - Use Named Sets to prepare asymmetric reports, show actuals for past months and plan for future months. About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will - Dramatically increase your productivity-saving you 50 hours a year, or more - Present proven, creative strategies for solving real-world problems - Show you how to get great results, no matter how much data you have - Help you avoid critical mistakes that even experienced users make

About the Author

Bill Jelen , Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 30 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. You will most frequently find Bill taking his show on the road, doing half-day Power Excel seminars wherever he can find a room full of accountants or Excellers. Before founding MrExcel.com, Jelen spent 12 years in the trenches working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary, Ellen and his sons, Josh and Zeke.


Customer Reviews

4.0 out of 5 stars
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback Verified Purchase
I would normally recommend Bill Jelen's books without hesitation (I do have many of them) but I was very disappointed with this book (PowerPivot for the Data Analyst).
Sample files are available but the book does not seem to mention the name of file(s) needed for a particular topic, although you can more-or-less match them to the chapter. However, some of the tables shown in the book have data that does not appear to be in any of the sample files so it would be necessary for you to create them yourself. I like to follow-along with the examples to get a good understanding of the subject but I have not been able to get past Page 2 of Chapter 5 - yes, I could create the three small tables but I then have to wonder how many more later in the book would also need to be created.
I therefore bought another book on the subject of PowerPivot/DAX formulas and that uses the Microsoft Northwind data - I have almost finished working through all the examples.
It seems that the MrExcel book was rushed to Press before being up to the usual MrExcel standard. If you intend only to read the book, it will probably be considered very good - if you want to try the examples yourself, you may be a bit frustrated by having to create some of the data yourself.
1 Comment 10 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
PowerPivot is an add-in for Excel. This program within a program is not really aimed at the average person, it is meant for high end analysis. Basically, if your data analysis involves millions of entries and requires that you compare several complex data sets, then PowerPivot might be for you. Otherwise, you might do better sticking with Excel.

With that said, the dashboard layouts by PowerPivot look fabulous. They look more like website layouts and less like Excel spreadsheets. Plus, they are fully interactive.

PowerPivot For the Data Analyst: Microsoft Excel 2010 recognizes the potential of PowerPivot while keeping a tight grip on the limitations and inherent problems. In this way, the author provides a more realistic view of using PowerPivot while giving plenty of tips about how to get what you need from your data.
Comment 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This book examines in detail PowerPivot which is a free add-in for Excel 2010. It makes possible the analysis of very large amounts of data normally beyond the capability of Excel. PowerPivot is not for the faint hearted and is aimed at experienced users of Excel who are familiar and comfortable with lookup functions, pivot tables and databases.

To take full advantage of the book, you will need to download PowerPivot itself and also the author's example files. There are 32-bit and 64-bit versions of PowerPivot and it is essential that you choose the one which matches your 32-bit or 64-bit version of Excel 2010.
The introductory chapter is a personal and interesting account which puts PowerPivot into context and shows the enthusiasm that Mr Excel has for his subject. After discussing how to obtain and install PowerPivot the book then begins to go into detail about how and when to use this application. Whilst it is clear that the author is a passionate advocate of PowerPivot, he is also critical of what he sees as shortcomings - for example, not easily being able to sort in month order - and he devotes a whole chapter to explaining the circumstances in which you might decide that a conventional pivot table might be a better approach.

The book gives detailed descriptions of the steps involved in many different tasks clearly illustrated with accompanying diagrams and supported by the exercise files that you can work through yourself.
Read more ›
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Kindle Edition
The author spends so much time complaining about various things that by the end of the book you'll be forgiven if you didn't bother installing Power Pivot - as I nearly didn't.

Which would be a shame as Power Pivot is an amazing bit of software; incredibly powerful, intuitive and as it turns out, you really don't need to read a book to use it.
Comment 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Found this version to be the terrific for introduction to PP. Although it has various misprints and errors throughout the book, there are no problems following the logic. Especially the parts on DAX and hints/tips are great. Highly recommended.

If big data is your game, buy this book. If not, stick to regular pivots.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse


Feedback