In this Excel tutorial, we will learn how to use the 10 most important functions in Excel. Or rather, the most important formulas in Excel with 10 practical examples from everyday life that can help you in the job market and save time.
There are many functions in Excel that help us automate tasks and processes. In this free Excel tutorial, we will see several of these formulas and functions in the Excel spreadsheet.
00:00 SUBSCRIBE TO THE CHANNEL
00:25 LIKE THE VIDEO
00:55 SUM
07:40 SUMIF
10:55 VLOOKUP
15:45 XLOOKUP
18:03 DATEDIF
22:07 IF
24:31 AND
28:51 OR
33:03 AVERAGE
34:22 AVERAGEIF
36:23 LEN
39:33 COUNTA
41:29 COUNTBLANK
43:17 COUNTIF
44:31 TODAY
46:46 TEXT
50:29 EOMONTH
53:08 MAX
55:24 MIN
56:39 TRIM
The SUM function adds up the values in a range of cells.
The COUNTA function counts the number of non-empty cells in a range of cells.
The COUNTBLANK function counts the number of empty cells in a range of cells.
The AVERAGE function calculates the average of the values in a range of cells.
The MIN function finds the smallest value in a range of cells.
The MAX function finds the largest value in a range of cells.
The VLOOKUP function looks 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 adds up the values in a range of cells that meet a specific condition.
The COUNTIF function counts the number of cells in a range that meet a specific condition.
XLOOKUP searches for a value in an array or table and returns a corresponding result from another column or row, functioning more flexibly than VLOOKUP and HLOOKUP.
DATEDIF calculates the difference between two dates in years, months, or days, useful for determining age or the time between dates.
AVERAGEIF returns the average of values in a range that meet a specific criterion.
LEN counts the number of characters (including spaces) in a cell.
TEXT formats a numeric value or date as text, allowing for format customization.
EOMONTH returns the date of the last day of the month, allowing you to add or subtract months from a starting date.
TODAY returns the current system date and is automatically updated.
OR checks if at least one of the conditions is true and returns TRUE or FALSE.
AND checks if all specified conditions are true, returning TRUE only if all are met.
TRIM removes extra spaces in a text, leaving only one space between words.
#ExcellentJoão #Excel #Dashboard