Monthly Archives: August 2017

The Clipboard can be useful occasionally…

According to study (which was conducted in a totally unscientific way with zero level of confidence…, i.e. my gut feeling), 100% of Excel users use Copy and Paste every time they work with Excel. ūüôā ¬†However, 99.99999% of them never … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments

Free Template – Working Calendar

Today, I celebrate (aka BeExcellence) reaching One Million views by… ¬†not going to work (because typhoon is hitting HK).¬† ūüėČ Thank you very much for visiting my blog in the past.¬†¬†Every single visit and page view from¬†you constitutes my … Continue reading

Rate this:

Posted in General, Template | 4 Comments

Using MIN/MAX to answer whichever lower/higher questions

What is “Whichever higher”? Situation:¬†You call to your favourite restaurant to reserve a private room for family dinner on Saturday.¬† The restaurant manager tells you that there will be a minimum charge of $2000 for a private room.¬†¬† That mean, … Continue reading

Rate this:

Posted in Formula | Tagged , , | Leave a comment

wmfexcel (aka BeExcellence) is now multilingual

<Note: There is no Excel tip in this post.> ¬†ūüôā Multilingual?? Really?? ¬†Not exactly. The fact is I’ve just added a widget to the side bar on the right:

Rate this:

Posted in General | Leave a comment

Filter a list of items from a long long list

A simple but practical tip of using Advanced Filter I came across a blogpost from Jon of Excel Campus (one of my¬†favorite Excel sites)¬†last week.¬† In his post, he showed how to¬†filter for a list of items using a reverse … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 5 Comments