Happy New Year! Wish you all an Excel-lent year of 2019!
As an Excel nerd, I’d like to spend my holidays on learning Excel… haha… I know I am abnormal. ;p My recent love of Excel is Power Query (M) and Power Pivot (DAX). As their names say, they add POWER to Excel.
I really like Power Query as the user-friendly User Interface offers most of the Power! We can do lots of amazing stuffs by applying steps in Power Query editor, simply via the UI. Having said that, learning the M language behind the scenes would definitely take you to the next level. However, it is not an easy journey…
If you are already familiar with the UI of Power Query Editor and are ready to go further with M, I’d highly recommend you spend an hour to watch the “extensive” introduction of M code of Power Query by Mike Girvin of ExcelIsFun:
Bear in mind that, this is only the beginning. You will still need to study and practice, again and again, to become a true master of Power Query which is my new year resolution. 🙂 Let’s work hard toward this!
Power Query is available as Adds-In for Excel 2010 / 2013. You may download it from https://www.microsoft.com/en-hk/download/details.aspx?id=39379
If you are using Excel 2016 or Office 365, Power Query is already loaded. It is under “Data” tab and renamed as Get and Transform.