Author Archives: MF

A compelling chart in three minutes…

In business world, we often compare actual sales to various benchmarks such as budget, target, and last year. In this post, I am going to show you step-by-step how to make a compelling chart for this purpose. This is basically a simplified version of bullet chart, and is super-easy to create. I hope you find it useful and relevant. Continue reading

Rate this:

Advertisements
Posted in Chart | Tagged | Leave a comment

My first #Excel video on YouTube

Kung Hey Fat Choi!  This week is Chinese New Year.  I wish you a fruitful, healthy, and rewarding Year of Pig! I have almost one week off for CNY holiday.  I have cleaned my PC and spared 50G+ space in … Continue reading

Rate this:

Posted in General | 2 Comments

Did you know… there are many nice Excel Templates readily available?

Did you know that there are many nice Excel Templates readily for usage? Next time when you start a New workbook, browse or even search for a template that suits your need. Or you may start from a template. Why re-invent a wheel? Continue reading

Rate this:

Posted in Excel Tips, Template | Leave a comment

Learn something amazing from Mynda’s #Excel Dashboard webinars

Free 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 … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Hard-coded range expands automatically with #Excel Table

The INDIRECT trick of using Structured Reference in Conditional Formatting   Is it a feature or a bug? This is an extension of the previous post, in which we discussed the use of INDIRECT trick to deal with Excel Table in Conditional … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 1 Comment

The INDIRECT trick of using Structured Reference in Conditional Formatting

When setting up conditions for Conditional Formatting in Excel, have you ever tried to set a formula that refers to a Excel Table, but failed?

First of all, why we want to refer to Excel Table in Conditional Formatting? There is one simple answer: To accept new data automatically. 
To use Structure Reference in Conditional Formatting, we need an INDIRECT approach which is discussed here. Continue reading

Rate this:

Posted in Excel Tips | Tagged , , , | 2 Comments

Highlight weekends and holidays using Conditional Formatting in #Excel Part 2

Conditional Formatting with formula could be tricky (or difficult), especially when the data layout is bad because you have to very clear and careful on the “applied to” range and the absolute/relative references set in the formula. Otherwise, it won’t work and can be quite confusing, if not frustrating. 😛

In this post, I will talk about a case that you will see how empty rows in a data set would complicate the process in setting up conditional formatting. And then I will show three different approaches to tackle the issues. Hope you find it helpful. Continue reading

Rate this:

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

Highlight weekends and holidays using Conditional Formatting in #Excel

In this post, I will show you step by step how to set up conditional formatting to highlight weekends and public holidays with Excel. The key is to set the formula right. Having a proper layout will make the whole thing more easier, which will be discussed in the next post. Continue reading

Rate this:

Posted in Format | Tagged , , , | 3 Comments

[Share] Introduction of #Power Query M code by ExcelIsfun

Happy New Year!  Wish you all an Excel-lent year of 2019! As an Excel nerd, I’d like to spend my holidays on learning Excel… haha… I know I am abnormal.  ;p  My recent love of Excel is Power Query (M) … Continue reading

Rate this:

Posted in Power Query | Tagged | Leave a comment

Highlighting Top X values with Icon Set in #Excel

This post is a continuation of the previous one – Highlighting Top X values with Conditional Formatting in #Excel So I will go straight to the point.  For background information, please read the previous post. 🙂 To insert Icon Set Select … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Highlighting Top X values with Conditional Formatting in #Excel

Well… think this topic is too simple?  How about doing this with a dropdown menu to make the Top X a dynamic one? with Icon Set? You may download a Sample File to follow along. Let’s start with the basics … Continue reading

Rate this:

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

Customize Alt 1 to 4 to become the favorite #Excel shortcuts of your own

When talking about keyboard shortcuts, there is always discussion on what’s the most time-saving shortcuts, what are the top X shortcuts you should learn, what is the most frequently used shortcuts, etc… Just to name a few, Ctrl+S to save, … Continue reading

Rate this:

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

Using Skip blanks in Paste Special

What the Skip blanks does? Have you ever had this question?  From my experience, 99.9% users (I work with) have no idea what it is or even are not aware of that option in Paste Special. Are you one of … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

The making of the bee…

Did you know… the bee you see on top of this page is drawn with Excel using shapes? Yes… these are the shapes I used to draw the bee.  What I did was to put them together… Watch this:

Rate this:

Posted in General | Tagged | Leave a comment

Dynamic Shrinking Dropdown with Dynamic Arrays in #Excel 365

The recent HOT topics about Excel should be the new Dynamic Arrays!   After watching all the amazing demonstrations about the new Dynamic Arrays, I’ve decided to sign up to the Office Insider (Fast) programme (for Office 365 subscriber only).  … Continue reading

Rate this:

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

Pinned Folder for #Excel 2016 – A workaround

Dear Excel 2016, you have made so many enhancements that help me a lot in work… but why you took away my favorite Pinned Folder by giving me a half page of white space? My workplace just got upgrade to … Continue reading

Rate this:

Posted in Excel Tips | 7 Comments

Prepare yourself to be an #Excel Dashboard Pro…

Have you ever had an Excel moment like this? If you’ve ever felt like: “My Excel reports take way too long to update each month/week” “I spend hours collating and cleaning data, updating formulas and charts and then no one … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Trick or Treat 2018

♪♫♬ This is Halloween, this is Halloween ♪♫♬ ♪♫♬ Halloween! Halloween! Halloween! Halloween! ♪♫♬ Please join me to welcome our special guest – Jack Skellington, appears on wmfexcel’s Excel sheet. ♪♫♬Halloween! Halloween! Halloween! Halloween! In this town we call home Everyone … Continue reading

Rate this:

Posted in General | Tagged | Leave a comment

Exciting Dynamic Array functions in #Excel 365

Have you heard of the new Dynamic Array functions recently available in Excel 365 (currently for Insider Fast users only)? If you are an advanced Excel user, you will be impressed by these new functions.  They are simply awesome, super … Continue reading

Rate this:

Posted in General | Tagged | Leave a comment

Learn something new from something that I think I knew well…

Today is a public holiday in Hong Kong.  A perfect break in the middle of a busy week.  What did I do on a public holiday?  Excel, Excel and Excel. 🙂 I watched a few videos from my favourite YouTube … Continue reading

Rate this:

Posted in Formula | Tagged , | Leave a comment