Monthly Archives: October 2018

Trick or Treat 2018

Posted on October 31, 2018 by

♪♫♬ 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

Posted on October 27, 2018 by

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…

Posted on October 17, 2018 by

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 by

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 by

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 by

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