Microsoft Excel Training on Cell References

Cell referencing is a usual challenge to beginners of Excel. On my training courses I often draw the analogey to learning how to drive with gears. At first you have to think carefully and concentrate, but it soon becomes instinctive. I beleive the same is true for realtive and absolute formulas.

Read the rest of this entry »

How to write a formula to calculate the last day of the month for a given date

This article will describe a simple formula to calculate the last day of the month of any date.

The complication arises due to the fact that months may have 28, 29,30 or 31 days.

I will take you through the thought process of getting to the final formula.

Read the rest of this entry »

Proud Father

This is highly unprofessional but I could not resist bragging about my son who has started his own blog at the age of 11 years old.

He is enthusiastic about photography and has started a blog on the topic.

Please go and check it out on www.kidzphotography.co.za