Monthly Archives: November 2015

Excel Humor #2 – Compact view

Posted on November 28, 2015 by

Rate this:

Image | Posted on November 28, 2015 by | Tagged | Leave a comment

Excel Humor #1 – Home

Posted on November 28, 2015 by

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

Posted on November 21, 2015 by

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

Rate this:

Posted in General | Tagged | 44 Comments

Nested IF vs. VLOOKUP – Which one to use?

Posted on November 14, 2015 by

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…

Posted on November 7, 2015 by

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