Author Archives: MF

Top 40 Excel Blogs by Feedspot

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!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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