Author Archives: MF

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

Hide and Seek – Cell Content

Posted on March 22, 2018

Don’t be shy!  Let silly things continue!  Let’s Hide and Seek with #Excel again! 🙂 Case 1 Case 2 Case 3 You may download a Sample File – Hide and Seek Cell Content for the above cases. If you know the … Continue reading →

Rate this:

Posted in Format | Tagged , , , , | 1 Comment

Hide and Seek – Column A

Posted on March 15, 2018

Cannot unhide column A? I know… it sounds another silly thing in #Excel.  But I do believe many novice users have had this experience before.  If you were one of them, you would know how frustrating that would be.  I … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 4 Comments

Hide and Seek – Cell border

Posted on March 8, 2018

Making cell border in #Excel should be something real basic.  However some people may have found it frustrating / confusing to play Hide and Seek with borders just hoping that they will be displayed in the way they want it. … Continue reading →

Rate this:

Posted in Format | Tagged | Leave a comment

Has Space or NoSpace in worksheet name?

Posted on March 1, 2018

Have you received workbook from others that carries underscore _ as if a space in their worksheet names?  Did you wonder why people use underscore when we can actually use space in worksheet name? Well… did you know… long long time ago, #Excel … Continue reading →

Rate this:

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

The missing link of HYPERLINK function in #Excel help

Posted on February 17, 2018

I seldom use the HYPERLINK function in #Excel.   Normally I insert hyperlink by CTRL+K, then setting the reference I want the link to go to.   That is super easy (or quick and dirty)! Note: You may go to Insert tab on ribbon … Continue reading →

Rate this:

Posted in Formula | Tagged | 2 Comments

#Excel Dashboard Course and Free Webinars by Mynda Treacy is closing soon

Posted on February 13, 2018

Just a quick reminder that registration for the awesome Excel Dashboard and Power BI courses, by Mynda Treacy closes on Thursday February 15, 8pm in Los Angeles, to be exact. With demand for Data Visualization skills and Excel data analysis jobs … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment