Tag Archives: Power Query

Unstack uneven data across columns with #Excel #PowerQuery

Posted on June 5, 2019 by MF

This is a continuation of the previous post, in which I showed you how to unstack two columns of data by using Pivot Table as a helper, and together with a couple of excel tricks.  As mentioned, that approach is only … Continue reading →

Rate this:

Posted in Power Query | Tagged | Leave a comment

Split cell contents separated by line feed into rows with #Excel #PowerQuery – Part 2

Posted on May 13, 2019 by MF

Last week, I showed you how to split cell contents separated by line feed into rows with Power Query.  That was easy when we are dealing with only one column.  If you don’t know how, you may read the post … Continue reading →

Rate this:

Posted in Excel in Action, Power Query | Tagged , | 5 Comments

Identify missing files in a folder with Power Query

Posted on May 1, 2019 by MF

It is a common task to compare two lists in Excel.  This can be achieved with MATCH function.  But what if you want to compare a list of filenames stored in your spreadsheet, with the files you’ve got in a … Continue reading →

Rate this:

Posted in Excel in Action, Power Query | Tagged | Leave a comment

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

Posted on January 1, 2019 by MF

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

20% off Excel and Power BI Dashboard Courses

Posted on January 31, 2018 by MF

Mynda Treacy’s popular Excel and Power BI Dashboard courses are back Dashboard reports, are no longer a buzz word, they’re a standard reporting tool for all kinds of industries and they’re an in-demand skill for Excel users everywhere. In fact, IBM project … Continue reading →

Rate this:

Posted in General | Tagged , , , | Leave a comment

Are you ready to turn boring Excel reports to Business Intelligence?

Posted on June 27, 2017 by MF

Well, I know.  You may have read similar topics before in my blog.   You are now seeing it again because the awesome Excel Dashboard Course by Mynda Treacy is now open.  What’s more exciting?   Mynda puts her popular courses “Excel … Continue reading →

Rate this:

Posted in General | Tagged , , | Leave a comment

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

Posted on April 29, 2017 by MF

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

The powerful Power Query and the interesting TechNet Virtual Labs

Posted on November 5, 2016 by MF

As you may be aware of, I haven’t written a real blogpost recently.  I was super busy at work in the past month.  No surprise.  There are moments Excel won’t help me much at work, especially when bosses like PowerPoint (and PDF) … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment