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. ... -
HLOOKUP Formula About : Looks in the top row of an array and returns the value of the indicated cell Category : Lookup Locat... -
VBA ─ Overview VBA stands for V isual B asic for A pplications an event-driven programming language from Microsoft that is now ...
