everydayExcel Newsletter - 19 Feb 2009

You Can Count Age with Ease in Excel!

In the course of managing data with Excel, you are likely to encounter the need of calculating the number of years and months between 2 dates, such as the age of the employees, length of service, and of an investment, etc.

The most commonly used and straight-forward approach is to take the difference between the 2 dates to return you the numbers of days. The year is then calculated by dividing this number of days by 365.25 days (taking into account leap year occurrence). If the number of months cannot make up a complete year, then computation becomes much more complex.

Life can become simpler with some great Excel tips.

Make use of the MOD formula to determine the number of days left over after counting the number of full years and then divide it by 30.5 days (average number of days per month) . This gives a fairly good estimate of the months in the partial year if you can afford to ignore the difference in the number of days in each month.

If accuracy is very important, such as in the computation of employees' pay or bonuses, then you might be led to think that using macro is the only way out... more about Excel Age Calculator

Upcoming Course Details

Date: 2 & 3 Mar 2009 (Mon & Tue)
Time: 9.00 am to 5.00 pm
Venue: 10 Anson Road #26-02A International Plaza S(079903)
>>Click here for Excel Course Details

Date: 16, 17, 23 & 23 Mar 2009 (Mon & Tue)
Time: 9.00 am to 5.00 pm
Venue: 10 Anson Road #26-02A International Plaza S(079903)
>>Click here for Excel Budgeting Course Details

What's New in Excel 2007

Excel 2007 has 16 millions colours, much more than the 56 colors in Excel 2003 and below. There is no excuse not to be draw professional and better looking charts with Excel 2007.

More about Microsoft Excel 2007

On the Lighter Side

Do you prefer brown sugar to white sugar in your coffee and tea? Most of us know that white sugar or sucrose just adds empty calories to our diet. Now, how about brown or raw sugar? They appear to be better, "more natural", and more nutritious than white sugar. But is it really true? Read full account in: "Don't Delude Yourself with Brown Sugar".