Monthly Archives: June 2018

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

Top 40 Excel Blogs by Feedspot

Posted on June 23, 2018 by

What an honour and pleasant surprise to be selected as one of the Top 40! Recently I am quite busy (and moody) at work, I mean the real work at office.  You must be thinking my works involved using Excel … Continue reading →

Rate this:

Posted in General | 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 to 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 , | 1 Comment

Display descriptive words instead of numbers with Custom Format in #Excel

Posted on June 14, 2018 by

Sometimes we want to add a descriptive like “Good Job” for figures above target; “Work Harder” for those below… like the following screenshot: To many people, the top-of-mind solution should be using IF function. =IF(A2>0, “Good Job”, IF(A2=0, “Just Met”,”Work … Continue reading →

Rate this:

Posted in Format | Tagged , | 2 Comments