Below is the list of Most Important 100+ Excel Functions along with its usage and formula. These Excel Functions are sub-divided into the following –

#### Financial Functions in Excel

 Calculates the future value of an investment at a specified rate of interest Calculates the interest of an investment for a specific period. IRR This excel function is simply the Internal Rate of Return for your investment in a series of cash flows. It is the Modified Internal Rate of return, which returns the percentage by taking into consideration both the Finance Rate & Reinvestment Rate. It is simply the number of installments or EMI’s required to clear off the loan. NPV Net Present Value is the value of future cash inflows and outflows by taking into consideration of present discount rate. This excel function returns the per month payment required to return the loan. It returns only the principal amount for an investment or loan It returns the redemption value per 100 face value. It gives the present value of an investment by taking into consideration of constant interest rate and payments. It returns the interest rate for an investment or loan. It returns the internal rate of return without any specific periodic period. YIELD It estimates the amount earned on investment security over a period of time.

#### Logical Functions in Excel

 AND If all the supplied conditions are true, it will return TRUE or else FALSE. IF This tests the logic given; it the condition is true, then we can get whatever the result we want if FALSE also we can other than the TRUE result value. This returns the specific value if the applied formula returns an error result. NOT This works indirectly, if the value is TRUE, it will result in FLASE, and if the result is FALSE, it will return TRUE. This is just like the AND function in excel, but if anyone of the supplied is true, it will return TRUE. TRUE This is the formula to get TRUE value without manual typing

#### Text Functions in Excel

 CHAR This excel function converts numbers to characters based on the American Standard Code For Information Interchange (ASCII). CLEAN It removes only non-printable values. This returns the numerical code for an alphabetic word. This tests two cell values, whether they are exact, are not. LEFT This will get the value from the left-hand side of a string based on the number of characters we specify. This excel function returns the numbers of characters in a cell. Space is also a character. This can fetch the data from the middle of the supplied value. PROPER This will arrange the text properly by changing the first character to an uppercase letter. REPLACE This excel function replaces the text with new text from the specified position REPT This will repeat the supplied character based on the number we specify. This will get the value from the right-hand side of a string based on the number of characters we specify. This will return the position of the supplied character in the specific value. This excel function substitutes the existing character with a new character. TEXT This will convert the value to text based on the format we specify. This eliminates unnecessary spaces or trailing spaces. This will convert the numerical values, which are in text format to number format.

#### Date and Time Functions in Excel

 DATE This excel function requires three elements, year, month, and day. It will format the supplied numbers as a date. DAY It extracts the day number from the supplied date. It is used to get a date on the same day of the month, x months in the past or future. This excel function returns the end of the month for the supplied date. It returns the current date and time. It requires three elements, hour, minute, and second. It gives the current date. It returns the weekday of the supplied date. This excel function returns the date from the supplied date based on the number of days we specify. This function extracts the year from the supplied date.

#### Lookup & Reference Functions in Excel

 ADDRESS This will create the cell reference or address of the cell as a text value. CHOOSE This excel function chooses the value from various values. COLUMN This function returns the selected column number It will return how many columns are selected It extracts data from the from the specified row and from the specified column It extracts data which is there horizontally based on the lookup value. This creates a URL to open the data, which is where your PC or laptop. INDEX It returns the value from the lookup value. This indirectly refers to the other cell from a different cell. It looks for a value in one row and one column This returns the row number of a lookup value from the array. This function returns a reference to a range. ROW Returns the first-row number in the reference provided This function is used to switch cells between rows and columns. This excel function returns the value of a lookup value from another table, which is there vertically.

#### Math Functions in Excel

 ABS This function converts all the negative numbers to positive numbers. AGGREGATE This excel function supplies some of the important formulas like Average, Count, Max, Min, and many other functions by ignoring error values Returns a rounded number based on a multiple significance. This function returns the number of combinations for a specified number of items. EVEN This excel function converts all the odd numbers to even numbers. It raises the supplied number to the power of e. This function is responsible for returning a number’s integer portion. This function is used to calculate the natural logarithm of a number. It returns the logarithm of a number to the base user gives This function converts all the even numbers to ODD numbers. This function raises the base number to a different number of times at the top of the base. This function simply does the multiplication of two supplied numbers. It returns values that are greater than zero but less than 1. This is a volatile function. ROUND It either rounds up or rounds down to a specified number of decimals. This excel function rounds the given floating-point number to a number of decimal places provided. To round off the given number, this function is used. SIGN This function calculates the sign of a supplied number. This function calculates the SIN of an angle Find a number of positive square roots This function ignores all the hidden rows and gives the calculation only for the visible rows. This excel function adds all the numerical values which are there in the range. This function adds the numbers based on the single criteria given by the user. TAN This function simultaneously does the summation as well as multiplication corresponding to the values. This function returns the tangent of an angle. TANH function gives the hyperbolic tangent of a given number, and the number is considered as an angle to radians.

#### Statistical Functions in Excel

 AVERAGE This excel function returns the average value of the supplied numbers. This is nothing but a correlation between two data sets. COUNT This function counts all the numerical values in the supplied range. This excel function counts only the value w specify This function is used to decide if two populations having have similar variances or the standard deviation. This function calculates or estimates the sales values based on previous trends. This excel function shows how often a certain value is occurring in an array GROWTH It of given numbers based on two data sets. LARGE It is responsible for returning the nth largest value from a given set of values in the spreadsheet. It is used to calculate a line’s stats. This function is given the maximum value from the supplied numbers. MEDIAN This function returns the middle value of the supplied numbers. This function is given the minimum value from the supplied numbers. MODE This excel function returns the MODE for each set of data. It estimates the probability of the variables plotting below or above a certain value. This is the inverse of standard normal cumulative distribution. This function returns the nth percentile of the set of values supplied. This function in excel is used to find the different quartiles of a data set. This function calculates how steep the line is This function returns the nth smallest value of the set of values supplied. SD shows how data spread outs among data points. T.TEST This function in excel calculates the probability associated with the of the student. TREND This function calculates the linear trend according to the given linear data set.