The MrExcel Store is closed during November 2020 Due to a Death in the Family.
Purchase e-books from our e-Junkie store or your local bookstore.

M is for (Data) Monkey e-Book

SKU: 323

Despite the moniker “data monkey,” we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time. When it comes to importing, cleaning, and transforming data to get it ready for analysis, you can learn Power Query faster than you can learn Excel formulas, and it handles complex sources much more easily than VBA. There is no doubt in our minds that Power Query will change the way Excel pros work with data forever. If you are using Excel 2010, 2013, or 2016 on a Windows PC, Power Query is available to you. This book will teach you pro tips for getting the most from Power Query.

Immediately after purchase, you can download PDF, mobi, and/or ePub versions of the book.

Nick Panagiotopoulos on 07/06/2018 08:57am
Congratulations for your book. I'm still reading it, doing all the examples of the book. I am on chapter 20, trying to learn better the M language.
I have already implemented two projects for my company, taking data from reports and transforming them into useful tables.
Again a big bravo for your book.
don parker on 01/10/2016 07:01pm
Very well written and easy to follow but geared for the new user. I've been working with Power Query for a few months now and the only thing I learned from this book was the bits in the last chapter about creating groups. I was hoping for a much more advanced book dealing with things like improving performance, using traces, and such. Still, I wish I had bought the book before I started to learn on my own. It would have made the journey much easier.

Add Your Review

Your Name:
Email Address:
Note: HTML is not translated! Your email address will not be shared with anyone.
Your Rating: 5
Your Name:
Your Email:
Friends Name:
Friends Email:
Related Products
Power Pivot and Power BI - eBook
SKU: 326
This is the expanded and updated 2nd Edition of Rob Collie's DAX Formulas for Power Pivot.
Dashboarding and Reporting with Power Pivot and Excel [eBook]
SKU: 301
"Dashboarding and Reporting with Power Pivot and Excel" [eBook] by Kasper de Jonge
PowerPivot Alchemy: Patterns and Techniques for Excel by Bill Jelen and Rob Collie [eBook]
SKU: 299
"PowerPivot Alchemy: Patterns and Techniques for Excel" by Bill Jelen and Rob Collie [eBook]
Learn to Write DAX - eBook
SKU: 324
e-Book versions of Learn to Write DAX
M is for (Data) Monkey (Print Edition)
SKU: 325
You'll go bananas as you replace tedious data cleansing with Power Query. This is the print book version of the definitive book on Power Query for Excel. While you are awaiting your shipment to arrive, you can download PDF, ePub, and Mobi editions.