Here is a quick reference of important formulas in MS Excel. Functions are pre-defined formulas in Excel and can be interchangeably used with term Formula. The list has been prepared using Excel 2007. But most of the formulas should be applicable to other versions as well.
Lower/Upper/Proper – You can use these formulas to convert text to your desired case (lower case, UPPER CASE, Proper Case).
Left/Right/Mid – Use these functions to extract data from a cell or text.
Concatenate – Concatenate multiple cells or strings into one.
Trim – Leaves only one space between words.
Len – Display number of characters in text string.
Find – Returns starting position of text string in cell or another text string.
Sum – Adds all the numbers in a range of numbers of cells.
Sumif – Adds all the numbers based on given criteria.
Average – Returns average of range of cells.
Min/Max – Returns minimum/maximum value from given range.
Round – Rounds a number or cell to given number of decimals
Count – Count number of cells with numbers
CountA – Counts number of cells that are not empty
CountIf – Counts number of cell in a range based on given criteria
If – Returns a true value and false value for a given condition
And – Returns true value if all the conditions are true and false if any one condition is false
Or – Returns true value if any of the condition is true and false if all conditions are false
PMT – Calculate monthly payment for a loan or mortgage.
Days360 – Returns number of days between two dates.
Now – Returns current date and time
VLookup – Vertical Look Up returns value from the specified column while looking value in left most column of a table. Table must be in ascending order for the function to work.
HLookup – Horizontal Look Up returns value from the specified row while looking value in the top row of a table. Table must be in ascending order.
