Author Archives: MF

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

Posted on October 17, 2018

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

Posted on October 10, 2018

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…

Posted on October 7, 2018

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

Posted on October 3, 2018

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…

Posted on September 29, 2018

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

Posted on September 12, 2018

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

Posted on September 7, 2018

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

Posted on September 1, 2018

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 :)

Posted on August 26, 2018

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

Posted on August 15, 2018

  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…

Posted on August 8, 2018

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

Load multiple #Excel Tables as separate #Queries quickly…

Posted on July 26, 2018

To load an Excel Table into Power Query is easy.  Just click into any cell of the Excel Table, and then click the From Table/Range button (depends on which version you are using, this button resides in different location on the … Continue reading →

Rate this:

Posted in Power Query | 2 Comments

Change the first letter to upper case, first word only please #Excel

Posted on July 19, 2018

This is a short story of mine, and an imaginary conversation in my head…  How to change the first letter (of first word only) to upper case in Excel? This was a question from a colleague sitting opposite to me.  … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , | 7 Comments

Creating % of Total, Running Total in a few clicks with #Excel Quick Analysis

Posted on July 5, 2018

This post is about showing you how to perform a common task of adding a column of % of Total Running Total with Quick Analysis in Excel 2013 or later. Latest Excel makes things easier, just that you may not be … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

No more Copy and Paste to combine tables with #PowerQuery

Posted on June 28, 2018

Basic of Append Query in #PowerQuery With no doubt, combining multiple tables (mostly on different worksheets, or even in different files) into a single “master” table for further analyses is one of the most tedious tasks we deal with Excel … Continue reading →

Rate this:

Posted in Power Query | Tagged | Leave a comment

Top 40 Excel Blogs by Feedspot

Posted on June 23, 2018

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!

Posted on June 21, 2018

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

Posted on June 14, 2018

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

Posted on May 31, 2018

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

Posted on May 24, 2018

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