Category Archives: Power Query

#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 | 11 Comments