Monthly Archives: February 2014

Arrange multiple Windows of the same Workbook!

Posted on February 28, 2014 by

How to view different worksheets of the same workbook side by side? It’s quite normal to have two workbooks opened; and more than common to view the two workbooks side by side:

Rate this:

Posted in Excel Basic, Excel Tips | Tagged , | Leave a comment

How to navigate cell in “Z” direction?? Tab Tab Tab Enter

Posted on February 20, 2014 by

Have you ever thought of how nice would it be if you can navigate cell in a “Z” direction?

Rate this:

Posted in Excel Basic | Tagged | 4 Comments

Input special characters in Excel by pressing Alt + Numpad

Posted on February 18, 2014 by

Perhaps you know that you can input some special characters/symbols by pressing Alt + Numpad together.  If you google “ALT Numpad”, you will probably find many extensive lists of special characters input in this way. Well, what to do with … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

What I did during the CNY holiday? To build my 1st dashboard…

Posted on February 15, 2014 by

During the past CNY holiday, I read a book called <Information Dashboard Design – Display data for at-a-glance monitoring> by Stephen Few.  Special thanks to my friend who borrows the book for me! Well, this is not an Excel book.  … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

How to insert picture / photo into comment?

Posted on February 13, 2014 by

Happy Valentine’s Day!! Tomorrow is a very special Valentine’s Day as both Chinese and Western Valentine’s Day fall onto the same day.  It happens only once in every 19 years. Let’s send your special feeling to a special person subtly … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment