Beat Excel! Get to next level in Excel!

Select Case (Excel VBA)

Select Case Statement lets you execute several group of statements based on value of an expression. It works like CHOOSE Function in Excel.

Changing Comment Shape

Are you bored with rectengular shaped comments? Or may be you need a more interesting shape for your comments? Here is the tutorial for changing...

Comparative Trend Chart

When you need to show trend for different periods in a continuous time line, comparative trend chart is the way to go. Lets see how...

For Next Loop (Excel VBA )

For Next loop repeats a statement for a specified number of times. This is your basic loop for alot of situations.  You will use it...

Trend Chart

Sometimes you need to show trend information on a chart. For such cases, I’ll show you how to make a trend chart in this tutorial.