Lesson 13: Excel Functions you need to know – Basic Excel

Hello friends. Welcome back to the Basic Excel Series for beginners. And today, let’s take a look at the 10 most common functions

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!