Author Archives: MF

Lookup a specific combination of characters exclusively, e.g. 5A not 5AA

Posted on September 10, 2017

Got the following question: hi, how do i search for a specific combination of characters exclusively i.e. if one cell contains 5A;3B&4C while another cell contains 5AA;3B&4C, and my search criteria is 5A, i want the results to return only … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , | 1 Comment

The Clipboard can be useful occasionally…

Posted on August 30, 2017

According to study (which was conducted in a totally unscientific way with zero level of confidence…, i.e. my gut feeling), 100% of Excel users use Copy and Paste every time they work with Excel. 🙂  However, 99.99999% of them never … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments

Free Template – Working Calendar

Posted on August 23, 2017

Today, I celebrate wmfexcel.com (aka BeExcellence) reaching One Million views by…  not going to work (because typhoon is hitting HK).  😉 Thank you very much for visiting my blog in the past.  Every single visit and page view from you constitutes my … Continue reading →

Rate this:

Posted in General, Template | 4 Comments

Using MIN/MAX to answer whichever lower/higher questions

Posted on August 16, 2017

What is “Whichever higher”? Situation: You call to your favourite restaurant to reserve a private room for family dinner on Saturday.  The restaurant manager tells you that there will be a minimum charge of $2000 for a private room.   That mean, … Continue reading →

Rate this:

Posted in Formula | Tagged , , | Leave a comment

wmfexcel (aka BeExcellence) is now multilingual

Posted on August 12, 2017

<Note: There is no Excel tip in this post.>  🙂 Multilingual?? Really??  Not exactly. The fact is I’ve just added a widget to the side bar on the right:

Rate this:

Posted in General | Leave a comment

Filter a list of items from a long long list

Posted on August 2, 2017

A simple but practical tip of using Advanced Filter I came across a blogpost from Jon of Excel Campus (one of my favorite Excel sites) last week.  In his post, he showed how to filter for a list of items using a reverse … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 5 Comments

Interactive Chart is not difficult to make – Part 3/3

Posted on July 26, 2017

Using Option Button to display different items on chart So far, we have made an interactive chart with check box to highlight items with negative growth; with scroll bar to see more items in a confined space.  In this post, … Continue reading →

Rate this:

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

Interactive Chart is not difficult to make – Part 2/3

Posted on July 22, 2017

Using Scroll Bar to show more This is an extension of the previous post – Using Checkbox to highlight negative growth in a bar chart.  In that post, we had created a chart showing top 10 items, which allowed user … Continue reading →

Rate this:

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

Interactive Chart is not difficult to make – Part 1/3

Posted on July 15, 2017

Using Checkbox to highlight negative growth in a bar chart In previous post, we talked about the basic of Form Controls.  I hope you had time to practice it and found useful way of building interactivity to your spreadsheet. In … Continue reading →

Rate this:

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

The awesome Dashboard course by Mynda is closing

Posted on July 12, 2017

Hurry, Last Chance for Free Dashboard Webinars & Course Just a quick reminder that registration for the awesome Excel Dashboard and Power BI courses, by Mynda Treacy closes on Thursday July 13, 8pm in Los Angeles, to be exact. Learn … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

Excel Humor #11 – CEO

Posted on July 2, 2017

A lazy Sunday in summer… let’s have some Excel humor. 🙂

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

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

The basic of Form Controls

Posted on June 24, 2017

Want to work like an Excel Pro?  Learn more about Form Controls. Have you seen someone using Check box, Option Buttons, Scroll Bars on their worksheets and be impressed?  You may wonder how they made it and think that is … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Excel Humor #10 – WannaCry moments in Excel

Posted on June 17, 2017

      There must been many others.  Please share in comments. 🙂

Rate this:

Posted in General | Tagged | Leave a comment

The amazing SUMPRODUCT

Posted on June 3, 2017

Advanced use of SUMPRODUCT for multi-conditional SUM In the previous posts, we talked about the basic of SUMPRODUCT, the behaviors of logical  values (i.e. TRUE/FALSE) when they are put into basic mathematics operations.  These set the foundation to understand the … Continue reading →

Rate this:

Posted in Formula | Tagged , | 2 Comments

The logic gate

Posted on May 27, 2017

Have you heard about Logic Gate?  I learned logic gate in high school physics.  Decades ago… so don’t expect I can remember what it is.  😛 Having said that, I do remember the fundamental concept about AND gate and OR gate, … Continue reading →

Rate this:

Posted in Formula | Tagged , | 4 Comments

SUM the PRODUCTs or SUMPRODUCT? That’s the question.

Posted on May 20, 2017

The basic of SUMPRODUCT Suppose we have a column showing retail price of different items; another column showing the units sold (illustrated above).  To get the total sales, most people will deploy a helper column to get the sales of each … Continue reading →

Rate this:

Posted in Formula | Tagged | 2 Comments

CrossTab SUM with 3 variables

Posted on May 13, 2017

This post is trying to answer a question by Laura in the post of 2D SUMIF with two variables – one on column and one on row. Here’s part of the question: ……I want to look up the department in the vertical … Continue reading →

Rate this:

Posted in Formula | Tagged | 3 Comments

Sort Warning?!

Posted on May 6, 2017

Sorting is one of the basic features in Excel.  I believe most Excel users, if not all, know how to sort in Excel.  Without any scientific research, I think most users would click the “Sort A to Z” (ascending order) … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 1 Comment

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

Posted on April 29, 2017

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 Excel Tips | Tagged | 11 Comments