Author Archives: MF

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

Calculating CAGR with Goal Seek in #Excel

when the starting point is a negative number… Calculating CAGR is not difficult, all we need is the starting value, ending value and the number of periods.  Then we use the formula: CAGR = (Ending Value / Beginning Value ) … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Excel Humor #7 just happened to me…

Two years ago… I posted this: which turned out a real case to me last week… I printed 99 pages of report out of one worksheet by selecting 99 items on a slicer one by one. @_@

Rate this:

Posted in General | Tagged | Leave a comment

Adding worksheet background in #Excel

How to add worksheet background in #Excel? If there is a secret recipe for an interesting Excel training, it would probably be starting with something interesting… 🙂 So in a recent in-house training, I’ve prepared a special Sheet1 in the … Continue reading

Rate this:

Posted in Excel Tips | 4 Comments

Three days in paradise…

Note: This is not an Excel post. I am back from holiday, physically 🙂 I went to a very remote village called YuBeng in Yunnan, China.  It’s a village 3200M above sea level.  To get to there wasn’t easy.  Not … Continue reading

Rate this:

Posted in General | Leave a comment

[Share] – Excel Hash

Have you heard about the Excel Hash competition? It is a contest initiated by Oz du Soleil at Excel On Fire.  Six well-known Excel MVPs, including Oz himself, show you what they can do with four designated Excel features/functions, and … Continue reading

Rate this:

Posted in General | Leave a comment

5 years of blogging

Totally forgot I put my first post here 5 years ago.  Time really flies! Thanks for flying with me. 🙂

Rate this:

Posted in General | Leave a comment

[Share] – Threaded Comments in Excel 365

Last week, I told you that my Surface Pro 4 is out of service, and I am waiting for a new laptop for writing my Excel blog… until late September or early October.   That was the plan. Although I am … Continue reading

Rate this:

Posted in General | Tagged | Leave a comment

(: Late summer break :)

Today, I am not talking about Excel although I would like to.  Why?  Because my Surface Pro 4 is out of service… 😦 It has been out of order a few weeks ago… the moment when the warranty period was … Continue reading

Rate this:

Posted in General | Leave a comment

#Excel Humor #15 – Performance Review

  Feel free to share this formula to your friend / colleague whom you think applicable… 🙂 He/She knows the answer.  😛

Rate this:

Posted in General | Tagged | Leave a comment

Same day last year…

Avoid Overthinking Getting same day of last year using Excel formula In retail, it’s very common to compare sales of same day, not same date, of last year.  If you are not in retail sector, you may wonder what is … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment