Category Archives: Power Query

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

Posted on January 1, 2019 by

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) … Continue reading →

Rate this:

Posted in Power Query | Tagged | Leave a comment

Load multiple #Excel Tables as separate #Queries quickly…

Posted on July 26, 2018 by

To load an Excel Table into Power Query is easy.  Just click into any cell of the Excel Table, and then click the From Table/Range button (depends on which version you are using, this button resides in different location on the … Continue reading →

Rate this:

Posted in Power Query | 2 Comments

No more Copy and Paste to combine tables with #PowerQuery

Posted on June 28, 2018 by

Basic of Append Query in #PowerQuery With no doubt, combining multiple tables (mostly on different worksheets, or even in different files) into a single “master” table for further analyses is one of the most tedious tasks we deal with Excel … Continue reading →

Rate this:

Posted in Power Query | Tagged | Leave a comment

#PowerQuery makes advanced VLOOKUP so easy!

Posted on June 21, 2018 by

Do you use VLOOKUP?  If you do, you should know there are limitations of VLOOKUP.  Also there are some cases VLOOKUP is not straightforward and efficient. Consider the following cases: What we want to achieve is to map the corresponding … Continue reading →

Rate this:

Posted in Power Query | Tagged , | Leave a comment

Maintain a price book in #Excel with #PowerQuery

Posted on May 31, 2018 by

Feel the Power (Query) This is my first post devoting to my recent love for Excel – Power Query.  🙂 First, let me make myself clear.  I am still learning Power Query (indeed I am still learning Excel too).  The … Continue reading →

Rate this:

Posted in Power Query | Tagged , , | 2 Comments

Data transformation with Power Query

Posted on November 11, 2017 by

Transform date input as “Excel-unrecognized” text string into date (number) usable by #Excel This is a continuation of the previous post – How to turn “1st January, 2017” into #Excel recognizable date?   …using Get & Transform (better known as #PowerQuery). Note: … Continue reading →

Rate this:

Posted in Power Query | Tagged , | Leave a comment

[Guest Post] 5 things you should start doing with Power Query

Posted on April 29, 2017 by

This is a guest post by Puneet Gogia. Power Query is a revolution. It’s a (part of a) complete self-service BI tool which can help you in importing, connecting, shaping, cleaning and sharing your data with little efforts. It has … Continue reading →

Rate this:

Posted in Power Query | Tagged | 12 Comments