30 EXCEL FUNCTIONS

These are 30 excel functions that i believe that everyone must know. Other functions are equally as important.

These functions are arranged according to the function, type and use.

AND: Logical type, Returns TRUE if all of the arguments are TRUE

AVERAGEIFS: Statistical type, Returns the average of all cells that meets multiple criteria.

AVERAGE: Statistical type, Returns the average of its argument

BIN2DEC: Engineering type, Converts a binary numbers to decimal.

BIN2HEX: Engineering type, Converts a binary numbers to hexadecimal.

CELL: Information type, Returns information about the location, formatting, or contents of a cell.

CONCATENATE: Text type, Joins several text items to one text item.

COUNT: Statistical type, Counts how many numbers are in a list of arguments.

COUNTA: Statistical type, Counts how many values are in a list of arguments.

DATE: Date and time type, Returns the serial number of a particular date

DATEDIF: Date and time type, Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.

DCOUNTA: Database type, Counts nonblank cells in a database

EFFECT: Financial type, Returns the effective annual interest rate.

EXACT: Text type, Checks to see if two text values are identical

ERROR.TYPE: Information type, Returns a number corresponding to an error type.

FALSE: Logical type, Returns the logical value FALSE.

FILTER: Lookup and reference type, Filters a range of data based on criteria you define.

FIND: Text type, Finds one text value within another (case-sensitive).

GEOMEAN: Statistical type, Returns the geometric mean.

GETPIVOTDATA: Lookup and reference type, Returns data stored in a PivotTable report.

HLOOKUP: Lookup and reference type, Looks in the top row of an array and returns the value of the indicated cell.

HYPERLINK: Lookup and reference type, Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.

IF: Logical type, Specifies a logical test to perform.

IFERROR: Logical type, Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.

IFS: Logical type, Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

ISERROR: Information type, Returns TRUE if the value is any error value.

ISNUMBER: Information type, Returns TRUE if the value is a number.

LEFT: Text type, Returns the leftmost characters from a text value.

LEN: Text type, Returns the number of characters in a text string.

MAX : Statistical type, Returns the maximum value in a list of arguments