MS Excel is the most commonly used industry-standard software for data analysis. To become a highly skilled individual in financial analysis, the basic know-how of Microsoft Excel is a must. But, learning the basic Excel formulas can be a critical task for beginners.
Here are seven basic Excel formulas, which will make your task easier:
The very basic and must-know formula in Excel is the SUM function. It sums up the values from selected columns or rows from your selected range.
The formula looks like – SUM (number1, [number2], …)
If A represents the columns and B represent the rows, then;
Ø Formula to sum up the values of a row would be – SUM(B1: G9).
Ø Formula to sum the values of a column would be – SUM(A6: A12).
Ø To add selected values from range A2 to A7, skips A8, adds A9, jumps A10 and A11, then finally add from A12 to A15, the formula would be – SUM(A2: A7, A9, A12: A15)
Another basic formula used in Excel is the Subtraction formula. Subtracting does not have its formula but you can still perform this function. All you need to do is enter the cells you want to subtract in the mentioned format, =SUM (A3, -B4). This will give a subtracted value.
If A3 is 45 and B4 was 40, =SUM (A1, -B1) would perform 45 + -40, returning a value of 5.
To perform the Multiplication function in Excel, the formula used is an asterisk. To multiply cell A1 by cell B1, enter the cells you are multiplying in the given format, =A1*B1.
If A3 was 15 and B1 was one, =A3*B1 would return a value of 15.
The Division formula uses a forward slash “/,” to divide cell A by cell B. To perform the simple function, enter the cells you’re dividing in the format, =A3/B2.
For example, if A3 was 6 and B2 was 3, =A3/B2 would return a decimal value of 2.
The AVERAGE function helps one to find out simple averages of data such as the average sum and much more.
The formula looks like – AVERAGE (number1, [number2] …)
If we enter =AVERAGE (B7: B12) – It will show a simple average same as – (SUM(B7: B12)/6).
The COUNT function is used to count only numeric values contained in a selected range.
The formula looks like – COUNT (value1, [value2], …)
COUNT(A: A) –This will count all the numerical values that are in column A.
If you want to count some selected set of values, you can use a formula like it’s used below:
COUNT(A1: C1) –This will count all the numeric values which are present in between of column A to Column C.
MAX & MIN –
The purpose of MAX and MIN functions is to help us to find out the maximum value and the minimum value from a selected range of values.
The formula looks like – MIN (number1, [number2], …)
If you enter – MIN(B3: C10) – It will find the minimum number between column B from B3 and column C from C10 to row 11 in both columns B and C.
If you enter – MAX(number1, [number2], …)
Like, MAX(B5: C10) – Similarly, it will help you to find the maximum number present between column B from B5 and column C from C10 to row 11 in both columns B and C.
So these are some basic MS Excel Formulas that you can use to simplify things while using MS Excel.
Also, if you want to know more about Microsoft Excel and it’s formulas for making your mathematical calculations more efficient, please check out the MS Excel Formulas Tutorial.