Results 1 to 5 of 5

Thread: Master Power Query with our book - M is for Data Monkey

  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,294
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider

    Post Master Power Query with our book - M is for Data Monkey



    Register for a FREE account, and/
    or Log in to avoid these ads!

    It may have a funny title, but this will be one of the most important Excel books you ever buy in your career.

    Written BY Excel pros FOR Excel pros, this book has been designed to guide you through learning how to master the new "Get and Transform" data experience in Excel. Released as a free add-in from Microsoft for Excel 2010 and 2013, Power Query technology is now built in to Excel 2016 and the Power BI Desktop application. This technology is a game changer, and will revolutionize the way you work with your data forever.

    Way back when this book was nothing more than a concept, we knew that it needed to be approached in a specific way. It had to speak to Excel users, the problems that they face on a daily basis, and ways to solve those problems both effectively and efficiently. It had to be written to keep you engaged, and to take you on a guided journey, learning from someone who understands you as an Excel pro, how you work, and what you face on a daily basis.

    We're proud to say that we believe that we've delivered on that goal, starting with common tasks you perform, and back filling them with real world issues, inspired by a wide variety of real world data sets. Packed with downloadable files and step by step instructions, this book is built to help you master Power Query so that you can use it in your own work, with your own issues. This book was designed from the beginning to get you up to speed quickly, and to give you the knowledge to build awesome Excel solutions quickly.

    Learn more about the book here, and acquire the skills that will let you answer questions instead of asking them!
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2
    Do you have this book in portuguese?

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,294
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Quote Originally Posted by linelson View Post
    Do you have this book in portuguese?
    Sorry, no. It's English only at the moment. Although if anyone is interested in translating it, we would love to get it into other languages.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  4. #4
    Seeker Spangamamman's Avatar
    Join Date
    Sep 2017
    Location
    Sweden
    Posts
    19
    Articles
    0
    Excel Version
    Microsoft Office 365 Business
    Old thread - still a relevant book?

    The book sounds great, the only problem is its date of issue. Is this book a 2016-edition that will show functions that have changed, if so, to what extent? I want to develop my skills/solve present problems, and are working with Office 365 Business. Are there any other advice of how to learn, for example also references to special thereads on this site, Please post.

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,294
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hi Spangamamman,

    M is for Data Monkey was released using the version of Excel that became Excel 2016. What this means is that newer features (merging options, the revised combined files, conditional logic wizard and column from examples) aren't in the book as they didn't exist. Having said that, over 80% of the text still remains relevant today.

    We are working on a new version, but it likely won't be out until 2nd quarter of 2019.

    As far as other resources, the one that we focus on is the Power Query Academy. This includes over 13 hours of Power Query training that takes you from newbie to master, includes the current version of the book (and next when it is released), as well as the Power Query Recipes that we've been working on. It's obviously not in the same price bracket, but it's the most comprehensive Power Query resource you'll find out there.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •