Hello friends. Welcome back to the Basic Excel Series for beginners. And today, let’s take a look at the 10 most common functions
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
COUNT function
The COUNT function is used to count how many cells have a numeric value
Can COUNTA be used to count all cells with values
SUM . function
The SUM function has the purpose of calculating the total value of an interval
Note: The SUM function can be used to sum 1 row. Example: =SUM(5:5)
IF . function
The if function checks whether the value is true or false and returns the result
AVERAGE function
The AVERAGE function is capable of calculating the average of cells in Excel
COUNTIF . function
COUNTIF can be used to count with 1 associated condition (in the example below is the value with the word Star in that cell)
SUMIF . function
SUMIF function to sum a certain range with a specified condition
VLOOKUP . function
VLOOKUP is a function used to search for a value based on a given condition
MIN . function
The MIN function is used to find the smallest value of an interval .
MAX . function
The MAX function is used to find the maximum value of an interval .
SUMPRODUCT . function
The SUMPRODUCT function will help us quickly calculate the total amount based on the quantity and price
So I just went through the 10 most common functions in Excel. Leave a comment to let me know what you think!
