This is the list of 50 common excel functions that I use on regular basis for all my work related task. I think anyone doing work on excel on regular basis should be conversant with all these formulas.
See how many of this do you know?
Returns the absolute value of a number. The absolute value of a number is the number without its sign.
Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi.
Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine isnumber. The returned angle is given in radians in the range -pi/2 to pi/2.
Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2.
Returns the average (arithmetic mean) of the arguments.
Uses index_num to return a value from the list of value arguments. Ex. CHOOSE(index_num,value1,value2,...)
Returns the column number of the given reference.
Returns the number of columns in an array or reference
Joins several text strings into one text string. CONCATENATE (text1,text2,...)
Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. CONVERT(number,from_unit,to_unit)
Returns the cosine of the given angle.
Counts the number of cells that contain numbers and also numbers within the list of arguments. Use COUNT to get the number of entries in a number field that's in a range or array of numbers
Counts empty cells in a specified range of cells.
Counts the number of cells within a range that meet the given criteria
Returns the sequential serial number that represents a particular date DATE(year,month,day)
Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.
Converts radians into degrees
FIND finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first character of within_text. FIND(find_text,within_text,start_num)
Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.
Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE
Returns a value or the reference to a value from within a table or range.
Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself
LEFT returns the first character or characters in a text string, based on the number of characters you specify
Returns a value either from a one-row or one-column range or from an array.
Returns the relative position of an item in an array that matches a specified value in a specified order.
Returns the largest value in a set of values.
Returns the smallest number in a set of values.
Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).
Returns the serial number of the current date and time.
Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.
Returns the number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.
Returns the result of a number raised to a power. POWER(number,power)
Returns an evenly distributed random number greater than or equal to 0 and less than 1.
RIGHT returns the last character or characters in a text string, based on the number of characters you specify
Returns the row number of a reference.
Returns the number of rows in a reference or array.
Returns the sine of the given angle
Returns a positive square root.
Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; SUBSTITUTE(text,old_text,new_text,instance_num)
Adds all the numbers in a range of cells.
Adds the cells specified by a given criteria.
Returns the tangent of the given angle.
Converts a value to text in a specific number format. TEXT(value,format_text)
Returns a vertical range of cells as a horizontal range, or vice versa.
Removes all spaces from text except for single spaces between words.
Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table.
Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default.
Returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999
That’s it. Read more excel related post by clicking on excel
Subscribe to my-aesi via mail or rss by clicking subscribe