FREE EXCEL FILE TO DOWNLOAD: https://jopaexcel.com/30excelformulas5zdpb9btpwa

In this Excel video tutorial, we gonna learn the most useful excel formulas and the most useful excel function with practical and real examples. This is a free Excel course for beginners, intermediate and advanced.

In this Excel tutorial, we will learn the functions: VLOOKUP, XLOOKUP, RANDBETWEEN, CHAR, CONCAT, COUNTA, COUNTIF, CONVERT, ABS, NETWORKDAYS.INTL, IF, AND, OR, IFERROR, UPPER, LOWER, PROPER, TEXT, RIGHT, LEFT, FIND, STDEV.S, TODAY, SMALL, LARGE, AVERAGE, AVERAGEIF, SUM, SUMIF, SUMPRODUCT.

These functions in Excel and formulas in Excel can help you in a job interview and on a daily basis to automate tasks and automate repetitive processes.

00:00 LIKE the video.
00:20 Subscribe to the Channel!
0:32 VLOOKUP
5:32 XLOOKUP
9:02 RANDBETWEEN
12:20 CHAR
19:09 CONCAT
24:11 COUNTA
27:00 COUNTIF
28:27 ABS
31:10 CONVERT
33:14 NETWORKDAYS.INTL
35:54 IF
39:13 AND
42:39 OR
45:21 IFERROR
47:47 UPPER
48:00 LOWER
49:00 PROPER
50:00 TEXT
53:42 RIGHT
54:00 LEFT
56:00 FIND
59:32 STDEV.S
1:02:17 TODAY
1:05:42 SMALL
1:07:00 LARGE
1:08:29 AVERAGE
1:09:52 AVERAGEIF
1:10:26 SUM
1:11:27 SUMIF
1:12:28 SUMPRODUCT

#JopaExcel #Dashboard #Excel