[Share] Introduction of #Power Query M code by ExcelIsfun

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:

Like it?

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!

Side notes:

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.

Advertisements

About MF

An Excel nerd who doesn’t work on Excel most of the time at current job...... 🤔 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Power Query and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.