Excel Spreadsheet Formulas

Excel Spreadsheet  has become widely accepted in every group. Because of its functionalities, it has become the most commonly used application for reporting purposes. It has helped users in minimizing the time needed in computing complex transactions, doing routine transactions and many others.   But, for you to maximize its usage, let us first check the excel spreadsheet formulas that are built-in in the applications.

Excel Spreadsheet Formulas were categorize according to their usage. These are:

• Logical Functions
• Financial Functions
• Text Functions
• Date and Time Functions
• Lookup and Reference Functions
• Math and Trig Functions
• Statistical
• Engineering
• Cube
• Information; and
• Compatibility

LOGICAL FUNCTIONS
AND	IFERROR	TRUE
FALSE	NOT	OR
IF

LOOKUP & REFERENCE FUNCTIONS
ADDRESS	HLOOKUP	OFFSET
AREAS	HYPERLINK	ROW
CHOOSE	INDEX	ROWS
COLUMN	INDIRECT	RTD
COLUMNS	LOOKUP	TRANSPOSE
GETPIVOTDATA	MATCH	VLOOKUP