Monthly Archives: April 2016

Excel Humor #4 – Excel is the perfect tool for…

Like and/or share this post if you agree it.  🙂 Advertisements

Rate this:

Posted in General | Tagged | 1 Comment

Page Right and Page Left… why no such keys?

As an Excel user, have you ever wondered why there are Page Up and Page Down keys on keyboard, but not Page Right and Page Left keys?  I do. You may probably know that you may navigate to the right … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments

Boost Excel Skill with Pivot Table

I think I must have missed the email from Mynda Treacy regarding the Xtreme PivotTables Course on her site: myOnlineTrainingHub, otherwise you should have read this post earlier. I use Pivot Table a lot and consider it a must-have skill … Continue reading

Rate this:

Posted in General | Tagged | 1 Comment

Reference to a cell without source number format

You probably knew it… when we make a direct reference to a cell, i.e. input =A1 in A2, the cell A2 will then follow the number format of A1.  Put it in other words, if the number format of A1 is … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Three different ways to do case-sensitive lookup

If you do VLOOKUP, you probably know that one of the limitations of VLOOKUP is case-insensitive.  It means case is not a consideration in the lookup process, where PETER is essentially the same as peter. Hence VLOOKUP will consider that … Continue reading

Rate this:

Posted in Formula | Tagged , , , , , , | Leave a comment

[April fool] – Invisible Gridlines?

Well… if you get bored in work on April fool, if you want to have a little fun with your colleague who is busying with his/her Excel files, here’s a minor trick for you to play with… Cautions: Take your … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment