FREE EXCEL FILE TEMPLATE TO DOWNLOAD: https://jopaexcel.com/wpcontent/uplo...

In this Excel video tutorial, we gonna see how to use the 10 most important Functions in Excel. The most important formulas in Excel with 10 practical examples that can help us on a daily basis, to automate tasks and to save time.

There are many functions in Excel that help us automate tasks and automate processes. In this free Execel tutorial, we will see several of these formulas and functions in the Excel template.

SUM, Adds up all the numbers in a range of cells.
MAX, Returns the largest number in a range of cells.
MIN, Returns the smallest number in a range of cells.
VLOOKUP, Looks up a value in the first column of a range and returns a value in the same row from a specified column.
COUNTA, Counts the number of nonempty cells in a range.
COUNTBLANK, Counts the number of empty cells in a range.
AVERAGE, Calculates the average (arithmetic mean) of a range of numbers.
IF, Performs a logical test and returns one value if true and another value if false.
SUMIF, Adds the cells specified by a given condition or criteria.
COUNTIF, Counts the number of cells that meet a specified condition.

00:00 Subscribe!
00:13 SUM
00:50 MAX
01:37 MIN
01:51 VLOOKUP
04:01 COUNTA
05:30 COUNTBLANK
06:36 AVERAGE
07:01 IF
08:50 SUMIF
09:45 COUNTIF

#JopaExcel #Dashboard #Excel