741,841 views
???? LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... ???? PRIVATE CLASS? TALK TO ME: / excellentjoao In this Excel video lesson, we will learn how to use the 10 most important Functions in Excel. Or even, the most important formulas in Excel with 10 practical everyday examples that can help you in the job market and 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 spreadsheet. 0:00 Introduction 0:30 Sum 2:25 Cont.Values 4:57 Count.Empty 8:12 Average 10:02 Maximum 11:19 Minimum 11:43 Procv 16:24 If 20:44 SumIf 23:37 Cont.If Below is a brief description of what each function is used for in the Excel spreadsheet. The Sum function adds the values in a range of cells. The Count.Values function counts the number of cells that are not empty in a range of cells. The Count.Empty function counts the number of cells that are empty in a range of cells. The Average function calculates the average of values in a range of cells. The Minimum function finds the smallest value in a range of cells. The Maximum function finds the largest value in a range of cells. The Procv function searches for a value in an array and returns the corresponding value from another array. The If function returns one value if a condition is true and another value if the condition is false. The SumIf function sums the values in a range of cells that meet a specific condition. The CountIf function counts the number of cells in a range of cells that meet a specific condition. #ExcelenteJoão #Excel #Dashboard