Excel is the number 1 office application today. A good grasp of Excel functions will help you calculate data quickly when practicing on spreadsheets and bring efficiency to your work. SO The most basic functions of Excel What is the name of the office workers? Together Blog Thiên Minh Find out below.
Sum function SUM
The Sum function is the first and most basic function that every Excel user should know. Using this function will save you a lot of time and effort instead of manual calculation.
Figure 1 – How to calculate sum in Excel
To calculate this function, you just need to specify the column to calculate. Then, in cell F10, type the phrase “=SUM” then drag the left mouse button to delimit the area to be calculated from the cell (F1:F9) as in the last example, press Enter and the result will appear as Figure 1.
MEAN . function to calculate the average value
Manually calculating the average of a series of numbers will take a lot of time and effort. With Excel’s AVERAGE function, you can easily calculate quickly in 1 note. Specifically, to calculate the average value of cells F1 through F9, you just need to type “=AVERAGE(F1:F9) as shown in Figure 2 and then press Enter to get the average result of that series of numbers .
Figure 2 – How to calculate the mean function
MIN/MAX function for maximum and minimum value
The Min/Max function is one of the Excel functions used quite often. It is used to find the minimum and maximum value in a data range. With a small number of numbers finding is very simple, but with a sequence of hundreds of numbers it is an extremely useful tool.
To perform this calculation, you just need to type in the cluster box the smallest value of “=MIN(F1:F9) and then press Enter as shown in figure 3, the result will return the smallest number in this beach.
Figure 3 – How to calculate the minimum value
To calculate the maximum value in a data range, you just need to type in the highest value cell “=MAX(F1:F9) and then press Enter as shown in Figure 4, then Excel will immediately return the results for you.
Figure 4 – How to calculate the maximum value
The NOW function returns the current date and time
Functions in Excel today, users often ignore the Now function and often enter date and time data manually. It can be said that it takes a lot of time and the data entry can be wrong. Therefore, you should take advantage of this feature if you want to show the current date and time on the sheet.
Figure 5 – How to enter date and time data in Excel
The NOW function is very simple, in the cell which should return the date and time value, you type “=NOW()” then Enter is the result to return the detailed date and time as shown in figure 5 above. Note that the function only changes the value when you make a change or want to change the data, but the Excel table does not update, so you don’t have to worry every time you open or close the file.
Functions LOWER, UPPER, PROPER convert uppercase, lowercase
The LOWER function allows users to quickly convert uppercase to lowercase. With this function, you just need to type “=LOWER(C23)” as shown in Figure 6, then press Enter, the result will be returned as cell D23.
Figure 6 – How to change uppercase to lowercase
Conversely, if you want to convert all characters in a cell to uppercase, use the UPPER function. The formula is the same as above and type “=UPPER (cell containing the string to be converted) then press Enter to get the result. If you want to capitalize all the first letters, use the PROPER function. The formula = PROPER(cell containing the string to convert).
above is basic functions in excel and convenient to use, but office workers often do not know or ignore. I hope the sharing in the article will be useful to you. Don’t forget to visit Thien Minh blog to read more useful information.
