Author Archives: MF

#Excel Humor #12 – Power Voice

Did you experience the Power Voice for #Excel?   Like this post if you did.   😛 Advertisements

Rate this:

Posted in General | Tagged | Leave a comment

Data transformation with Power Query

Transform date input as “Excel-unrecognized” text string into date (number) usable by #Excel This is a continuation of the previous post – How to turn “1st January, 2017” into #Excel recognizable date?   …using Get & Transform (better known as #PowerQuery). Note: … Continue reading

Rate this:

Posted in Power Query | Tagged , | Leave a comment

How to turn “1st January, 2017” into #Excel recognizable date?

Quite a long time ago, I wrote a post to discuss a trick to format date with “st”, “nd”, “rd”, etc… In this post, I am going to discuss the reversed way: Turning an English written date with “Dst MMMM, … Continue reading

Rate this:

Posted in Formula | Tagged , , , , , , | 5 Comments

Repeat all item labels in Pivot Table (aka Fill in the blanks please)

Quite a long time ago, I wrote a post Fill in the blanks – quickly to talk about the tip to turn a human-reading-freindly table into an Excel-friendly table, as shown below: Have you ever thought about why we are doing … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 3 Comments

Extract part of text string with delimiter(s)… and more with Text to Columns

In the previous post, we talked about the basic of Text to Columns and focused on “Fixed width”.  In this post, we will continue to talk about three magical things that Text to Columns could do with ease: Extract part … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 2 Comments

Extract part of a text string using Text to Columns

There are many not-so-easily-understood terms in Excel. “Text to Columns” should be one of them.  Probably due to the name of it, Text to Columns is not a common tool for many Excel users.  But indeed, if you know what … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Free Excel Dashboard Webinars by MYNDA TREACY is back

If you have been following my blog for more than three months, you should have read this before.  If you wonder why I am reposting it again and again, the answer is simple: it is awesome.  You could learn awesome … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Data Validation to restrict user from inputting to future days

The situation We need to input certain data on a daily basis.  For example, daily sales.  That is supposed to be an easy and routine task for many people.  BUT… it happened that we still have a chance to input … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments

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

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…

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

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

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

<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

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

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

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

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

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

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?

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