Monthly Archives: December 2014

2014 in review

Posted on December 30, 2014 by MF

Originally I have no plan to post until 2015.  To my pleasant surprise, the WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.  So why not? Here’s an excerpt: The concert hall at the Sydney Opera House … Continue reading →

Rate this:

Posted in General | Leave a comment

Merry Christmas 2014

Posted on December 23, 2014 by MF

Christmas is all around.  Here’s a Christmas Card (made with Excel of course) for you! 🙂   ==>  ==>  ==>

Rate this:

Posted in General | Leave a comment

Average Trap 2 – Average the average

Posted on December 20, 2014 by MF

Why we cannot take the average of averages? Once upon a time, I was questioned with the above.  First thing on my mind: “Is it a test?”… So I answered the question carefully, as shown in the screen shot below:

Rate this:

Posted in Formula | Tagged | 1 Comment

News sharing – ActiveX Controls Not Working?

Posted on December 17, 2014 by MF

IF you have no idea of what ActiveX Controls is or IF you don’t even have the Developer Tab on your ribbon, this post may not be relevant to your daily work with Excel; ELSE it is worth taking a … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

Average Trap

Posted on December 12, 2014 by MF

What do you mean by “Average”? When the question “What is the average of…” is asked, the top of mind function could possibly be AVERAGE.  But did you know that AVERAGE function ignores text (including number stored as text), logical … Continue reading →

Rate this:

Posted in Formula | Tagged , | Leave a comment

Feel justified with Fill Justify

Posted on December 6, 2014 by MF

Like majority of smartphone users, Excel users (know how to) use only a little portion of functionalities provided by the tool, even though we pay the full price for the tool… Fill Justify (on the editing group of the Home Tab) is … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment