Microsoft excel comes with pre-defined list, like days of week, months of year etc. This enables us to reduce our data entry work and valuable working time. We use this list by typing the first item in the list, then click and drag fill handle
What is fill handle?
Click on a cell in a excel worksheet; you will see a black square at its right bottom corner is called fill handle, cursor turn in to a cross hairs when you hover.

How to use a built in list?
Select the cell of a …

Recently one of my readers asked me the question how to convert numeric value in to word, This is an important function everybody looking for in excel but unfortunatly there is no ready to use formula, function in excel. however  microsoft provides a visual basic function script in their support section. This script is useful for spelling number in to US dollar.
Accountinghead is converted this function script for the use of indians  with the help of some VB experts.  Letus do it with easy 5 steps , by using this script you can convert …

Most of the accounting software has the option of automatic age calculation of pending bills. i.e., the number of days the bills have been pending. However there may be situations of calculating age wise pending details manually. Microsoft excel will calculate it for you by applying simple function.
Once you added the formula in the excel sheet ,you don’t need to change it every day  the age calculation will be done excel automatically based on current date.Let us see how this can be done.
Consider the following example for age calculation.

Now insert the todays …