excel formulas

1) eomonth = end of month is a very useful formula and returns the date at the end of the month. This function is particularly useful for project financing where payments are made after every 6 months and at the end of the month or for quarterly projections.
The function requires just two parameters 1) The date 2)Months

2) It is always advisable to name parameters that would be used through out the excel sheet so that it is easy for the user to relate to the parameters.

3) Never hard code a number more than once.

4)Always have distinct areas in an excel sheet for different things. Like for rough work have a rough section, For assumptions have a separate sheet.

5)Index function is among the most widely used functions, if you can use this function correctly then there is no use to have functions like vlookup or hlookup.