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