Author Archives: MF

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

Load multiple #Excel Tables as separate #Queries quickly…

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

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

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

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

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!

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

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

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

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