You will find here all mostly used excel based formulas. Which are using the MIS persons to prepare and automated their excel reports.
-
OFFSET function And the Sum formula About : To calculate the total of a specific group of months the =OFFSET() function has been used. ... -
INDEX Function About : Uses an index to choose a value from a reference or array Category : Lookup Location : Built-in ... -
HLOOKUP Formula About : Looks in the top row of an array and returns the value of the indicated cell Category : Lookup Locat...
No comments:
Post a Comment