Monthly Archives: November 2015

Excel Humor #2 – Compact view

Advertisements

Rate this:

Image | Posted on by | Tagged | Leave a comment

Excel Humor #1 – Home

I am now having fun somewhere in Tasmania; enjoying my vacation  🙂 So let’s have fun this week and the next.

Rate this:

Posted in General | Tagged | 2 Comments

Bug with copy and paste in Excel Table

Do check what you do! On top of human errors, there may be bug hidden. Continue reading

Rate this:

Posted in General | Tagged | 25 Comments

Nested IF vs. VLOOKUP – Which one to use?

A well-drawn flowchart or a well-organized table helps you write a successful formula effectively Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments

IF, it is too complicated…

Writing an IF function is quite straight forward, if there is only one logical test involved. For example, we want to comment on a shop’s performance by looking at its actual sales. If Actual hits Budget, then Good job, else … Continue reading

Rate this:

Posted in Formula | Tagged | 12 Comments