Excel Functions are predefined and preset formulas that are used to perform various types of calculations and process data in a particular order and accordingly, return results.
The presence of these Functions makes MS Excel and spreadsheets one of the most powerful applications in the field of data processing. Further, sound knowledge and effective use of these functions save users from a lot of laborious work and profusions time. No doubt, mastery over Excel function in the present era can help you climb the corporate ladder very quickly.
Position EXCEL Functions
Function Description
COLUMN Returns the column number of a cell reference.
COLUMNS Returns the number of columns in an array.
ROW Returns the row number of a cell reference.
ROWS Returns the number of rows in an array.
MATCH Searches for a value in a list and returns its position.
Lookup Functions
Function Description
VLOOKUP Lookup a value in the first column and return a value.
HLOOKUP Lookup a value in the first row and return a value.
INDEX Returns a value based on its column and row numbers.
CHOOSE Chooses a value from a list based on its position number.
Text Position Functions
Function Description
FIND Locates the position of the text within a cell. Case-sensitive.
SEARCH Locates the position of the text within a cell. Not Case-sensitive.
Time Functions
Function Description
TIME Converts a time stored as text into a valid time.
TIMEVALUE Converts a time stored as text into a valid time.
These functions return numbers from a valid excel time value.
Function Description
SECOND Returns the second as a number (0-59)
MINUTE Returns the minute as a number (0-59)
HOUR Returns the hour as a number (0-23).
Period Functions
Function Description
DATEVALUE Converts a date stored as text into a valid date
DATE Returns a date from the year, month, and day.
WORKDAY.INTL The date n working days from a date, custom weekends.
WORKDAY The date n working days from a date.
EDATE Returns a date, n months away from a start date.
EOMONTH Returns the last day of the month, n months away date.
Function Description
DATEDIF A number of days, months, or years between two dates.
DAYS Returns the number of days between two dates.
DAYS360 Returns days between 2 dates in a 360 day year.
YEARFRAC Returns the fraction of a year between 2 dates.
NETWORKDAYS A number of working days between 2 dates.
NETWORKDAYS.INTL
Working days between 2 dates, custom weekends.
Function Description
DAY Returns the day as a number (1-31).
WEEKDAY Returns the day of the week as a number (1-7).
WEEKNUM Returns the week number in a year (1-52).
MONTH Returns the month as a number (1-12).
YEAR Returns the year.
Conditional Excel Functions
Function Description
ISBLANK Test if the cell is blank. Results in TRUE/FALSE
ISTEXT Test if the cell is text. Results in TRUE/FALSE
ISODD Test if the cell value is odd. Results in TRUE/FALSE
ISERR Test if the cell value is an error, ignores #N/A. Results in TRUE/FALSE
ISERROR Test if the cell value is an error. Results in TRUE/FALSE
ISEVEN Test if the cell value is even. Results in TRUE/FALSE
ISFORMULA Test if the cell is a formula. Results in TRUE/FALSE
ISLOGICAL Test if the cell is logical (TRUE or FALSE). Results in TRUE/FALSE
ISNA Test if the cell value is #N/A. Results in TRUE/FALSE
ISNUMBER Test if the cell is a number. Results in TRUE/FALSE
Function Description
IF
If the given condition is met then do something, otherwise, do something else
IFNA
If the result is an #NA error then do something else.
IFERROR
If the result is an error then do something else.
