Author Archives: MF

#Excel Humor #15 – Performance Review

Posted on August 15, 2018

  Feel free to share this formula to your friend / colleague whom you think applicable… 🙂 He/She knows the answer.  😛 Advertisements

Rate this:

Posted in General | Tagged | Leave a comment

Same day last year…

Posted on August 8, 2018

Avoid Overthinking Getting same day of last year using Excel formula In retail, it’s very common to compare sales of same day, not same date, of last year.  If you are not in retail sector, you may wonder what is … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Load multiple #Excel Tables as separate #Queries quickly…

Posted on July 26, 2018

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

Change the first letter to upper case, first word only please #Excel

Posted on July 19, 2018

This is a short story of mine, and an imaginary conversation in my head…  How to change the first letter (of first word only) to upper case in Excel? This was a question from a colleague sitting opposite to me.  … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , | 7 Comments

Creating % of Total, Running Total in a few clicks with #Excel Quick Analysis

Posted on July 5, 2018

This post is about showing you how to perform a common task of adding a column of % of Total Running Total with Quick Analysis in Excel 2013 or later. Latest Excel makes things easier, just that you may not be … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

No more Copy and Paste to combine tables with #PowerQuery

Posted on June 28, 2018

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

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

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

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

Posted on June 14, 2018

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 , | Leave a comment

Maintain a price book in #Excel with #PowerQuery

Posted on May 31, 2018

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

Create your own favorite keyboard shortcuts in #Excel without VBA

Posted on May 24, 2018

Make better use of the Quick Access Toolbar (QAT) We all know that shortcuts could save us lots of time when working with Excel.  Excel has many built-in shortcuts.   Ctrl+C, Ctrl+V should be the most popular and commonly used … Continue reading →

Rate this:

Posted in Shortcut | Tagged , | 3 Comments

#Excel Humor #14 – Insert Table

Posted on May 17, 2018

I am having an incentive trip in Osaka… not sure if this is due to my Excel skills. 😛 So let’s have fun this week. 🙂   What would you say if you were the interviewer?  Leave it in comments.  … Continue reading →

Rate this:

Posted in General | Tagged | 2 Comments

How to remove leading space in #Excel

Posted on May 10, 2018

When TRIM and CLEAN do not work… Is it something bothering you? To fix this problem, we need to understand where is the “leading space” coming come.  Before we jump to that, I want to show you two Excel functions … Continue reading →

Rate this:

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

Learn something amazing from Mynda’s #Excel Dashboard webinars

Posted on May 5, 2018

We don’t know what we don’t know.  The best way is to learn something new is to explore the web (or world), and/or learn from experts. Sometimes we just don’t know, or even don’t expect what Excel could do for … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

VBA to make selected sheets “Very Hidden” in #Excel

Posted on April 26, 2018

VBA to make selected sheets “Very Hidden”;  all sheets visible Weeks ago, I showed the way to unhide a very hidden sheet in #Excel via Visual Basic editor (VBE).  You may refer to that post HERE.  Technically we could follow … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , | Leave a comment

Save a Read Only copy

Posted on April 19, 2018

When we have created a wonderful #Excel template that is to be shared with others, we don’t want users to distort, if not destroy, the template someday.  Nevertheless we would like to leave as much “flexibility” as possible to users … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Hide and Seek – External Links in #Excel

Posted on April 12, 2018

The haunted External Links that won’t go away… Have you ever bothered by this never-go-away warning message? You’d searched all worksheets (visible or hidden and very hidden too) in order to locate the external links and remove them.  Somehow, you … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 1 Comment

Hide and Seek – #Excel Worksheet

Posted on April 5, 2018

How to unhide a very hidden worksheet? Situation: You see in the formula bar that the cell is referred to a worksheet called “VeryHidden”.  However you don’t see it on the sheet tab. Naturally you right-click on a sheet tab … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments

April #Excel Fool

Posted on April 1, 2018

Wanna have fun with your colleagues who get too serious in #Excel on April Fool?  How about playing Hide and Seek? You may refer to my blogposts below for some ideas: Hide and Seek – #Excel Workbook Hide and Seek … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

Hide and Seek – #Excel Workbook

Posted on March 29, 2018

Have you ever had this experience with #Excel?  Someone sent you a workbook that is empty!  What I mean empty here is not that there is no content in the workbook.  You know that there are lots of data in … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment