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?

**abs**

Returns the absolute value of a number. The absolute value of a number is the number without its sign.

**acos**

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.

**asin**

Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is*number*. The returned angle is given in radians in the range -pi/2 to pi/2.

**atan**

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.

**average**

Returns the average (arithmetic mean) of the arguments.

**choose**

Uses index_num to return a value from the list of value arguments. Ex. CHOOSE(index_num,value1,value2,...)

**column**

Returns the column number of the given reference.

**columns**

Returns the number of columns in an array or reference

**concatenate**

Joins several text strings into one text string. CONCATENATE (text1,text2,...)

**convert**

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)

**cos**

Returns the cosine of the given angle.

**count**

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

**countblank**

Counts empty cells in a specified range of cells.

**countif**

Counts the number of cells within a range that meet the given criteria

**Date**

Returns the sequential serial number that represents a particular date DATE(year,month,day)

**day**

Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.

**degrees**

Converts radians into degrees

**find**

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)

**hlookup**

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

**hyperlink**

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.

**if**

Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE

**index**

Returns a value or the reference to a value from within a table or range.

**indirect**

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**

LEFT returns the first character or characters in a text string, based on the number of characters you specify

**lookup**

Returns a value either from a one-row or one-column range or from an array.

**match**

Returns the relative position of an item in an array that matches a specified value in a specified order.

**max**

Returns the largest value in a set of values.

**min**

Returns the smallest number in a set of values.

**month**

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).

**now**

Returns the serial number of the current date and time.

**offset**

Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.

**pi**

Returns the number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.

**power**

Returns the result of a number raised to a power. POWER(number,power)

**rand**

Returns an evenly distributed random number greater than or equal to 0 and less than 1.

**right**

RIGHT returns the last character or characters in a text string, based on the number of characters you specify

**row**

Returns the row number of a reference.

**rows**

Returns the number of rows in a reference or array.

**sin**

Returns the sine of the given angle

**sqrt**

Returns a positive square root.

**stdev**

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).

**substitute**

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)

**sum**

Adds all the numbers in a range of cells.

**sumif**

Adds the cells specified by a given criteria.

**tan**

Returns the tangent of the given angle.

**text**

Converts a value to text in a specific number format. TEXT(value,format_text)

**transpose**

Returns a vertical range of cells as a horizontal range, or vice versa.

**trim**

Removes all spaces from text except for single spaces between words.

**vlookup**

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.

**weekday**

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.

**year**

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**