75,581 views
🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... 🔵 EXCEL SPREADSHEET FREE DOWNLOAD: https://excelentejoao.com.br/wp-conte... In this video Excel class, we will learn the main formulas and functions in Excel 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: Procv, Procx, Concat, Cont.If, Cont.Valores, If, And, Or, Seerror, Average, Averagese, Devpad.A, Sum, Sumif, Sumproduct, Randombetween, Caract, Dayworktotal .Intl, Convert, Abs, Uppercase, Lowercase, Pri.Capital, Right, Left, Search, Text, Today, Largest, Smallest. These functions in Excel and formulas in Excel can help you in the job market, in everyday life to automate tasks and automate repetitive processes, and help you in a job interview that has an Excel test. 00:00 Leave a LIKE on the video. 00:20 Subscribe to the Channel! 00:40 Procv 05:10 Procx 08:49 Randombetween 14:03 Caract 18:10 Concat 22:35 Cont.values 25:19 Cont.if 26:57 Abs 29:36 Convert 32:03 Dayworktotal.Intl 34:34 If 38:02 E 41:42 Or 44:42 Seerro 47:07 Uppercase 47:40 Lowercase 48:30 Pri.Capital 49:18 Text 52:14 Left 53:30 Right 54:20 Search 57:11 Devpad.A 59: 36 Today 01:04:42 Smallest 01:07:08 Largest 01:08:11 Average 01:09:08 Averagese 01:10:10 Sum 01:10:37 Sumse 01:11:37 Addproduct #ExcelenteJoão #Excel #Dashboard