MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Resolve to Learn Power BI in 2020

December 26, 2019 - by Bill Jelen

It's a new decade. You've been saying that you really need to transition your Excel skills to Power BI. If you are looking for a New Years Resolution for 2020, now is the time to get comfortable with Power BI and create a few dashboards. Once you are comfortable with the process, you will be able to create powerful, interactive dashboards that your manager's manager will carry around on his iPad.

To help get you started, we have a limited time New Decade special on four of the best-selling Power BI e-books on the planet. With our “Resolve to Learn Power BI e-Book Bundle”, you receive all four of these e-books for less than the price of two e-books. Each e-book usually sells for $14.95, but with this bundle, you will receive all four e-books for $28. Plus: you can download immediately after purchase, in any or all of three formats: PDF, Mobi (for Kindle), or ePub (for iPad and other devices).

The bundle includes:

  • M is for (Data) Monkey by Ken Puls and Miguel Escobar: Learn the Power Query concepts that will help you to load and transform data to Excel or Power BI
  • Supercharge Power BI by Matt Allington: Once your data is in Power BI, create powerful new calculations using DAX. This book contains a number of exercises where you can learn by doing.
  • Power Pivot and Power BI by Rob Collie: the best-selling guide to Power BI
  • Absolute Guide to Dashboarding with Power BI by Kasper DeJonge: Once you've learned the basics in the books above, Kasper will walk you through a complete case study, end-to-end. Start with raw data and end up with a finished dashboard.

This special pricing begins December 26, 2019 and lasts until January 6, 2020. Buy the books at

Title Photo: Danil Aksenov

Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point 2nd Edition

Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how Dynamic Arrays make XLOOKUP better. The chapter on the logic behind arrays has been expanded.