6 Excel Basic Formulas You Should Know

Who does’t know Excel? I think it’s installed on most PC in the world, especially in office. Excel help users to solves so many problems in data processing in the office. If you’re working in the office, you should know some basic excel formulas that will ease your job.

When you process the data in the table, it’s better to using Excel instead of Word. Word only for word processing. If you want to calculate the number or statistics, you should use Excel. Below are 6 Excel formulas that will help you finish your job faster.

MAX formula

I give an example, you can look at picture below.

excel max

I have 10 row data contain people and the score. MAX formula is used to get the highest score in the table. To use it, you just type =MAX(B2:B11) in formula bar or type it in a cell you want to show the result . B2 is the first cell and B11 is the last cell in range. Or you just click and drag from the first cell until the last cell.

MIN formula

excel min

MIN formula is used to get minimum or lowest score in the table. To use it, you just type =MIN(B2:B11). B2 is the first cell and B11 is the last cell in range. Or you just click and drag from the first cell until the last cell.

AVERAGE formula

excel average

AVERAGE is a formula to get average value. To use it, you just type =AVERAGE(B2:B11). B2 is the first cell and B11 is the last cell in range. Or you just click and drag from the first cell until the last cell.

SUM formula

excel sum

SUM is a formula to get sum value. To use it, you just type =SUM(B2:B11). B2 is the first cell and B11 is the last cell in range. Or you just click and drag from the first cell until the last cell.

COUNT formula

excel count

COUNT is used to count the rows that has data. If some cells area empty, then they won’t be counted. To use it, you just type =COUNT(B2:B11). B2 is the first cell and B11 is the last cell in range. Or you just click and drag from the first cell until the last cell.

COUNTIF formula

excel countif

COUNTIF has a little bit difference with COUNT. COUNTIF is used to count the rows that has data with a criteria. For example, look at the picture above. I want to get how many people that has score more than 70. So I just type =COUNTIF(B2:B11,”>=70″). B2 is the first cell and B11 is the last cell in range. Or you just click and drag from the first cell until the last cell.

There are so many formulas in excel. Not only describes above. You might learn some formulas such as LARGE, INDEX, INDIRECT. These are helpful for sort data in excel automatically.

I think those formulas will help you in the office. You can try it. Good luck!