10 indispensable equations for every beginner in Excel Explanation of the LARGE function Explanation of the SMALL function Explanation of the MIN function Explanation of the MAX function Explanation of the AVERAGE function Explanation of the CANCATENATE function Explanation of the UPPER function Explanation of the PROPER function Explanation of the NOW function Explanation of the TODAY function I hope I live up to your expectations and can provide you with even a small, simple, useful piece of information ???????????? The beginning of the Excel course #Episode_1: 10 indispensable equations for every beginner in Excel Lesson contents: Explanation of the LARGE function Explanation of the SMALL function Explanation of the MIN function Explanation of the MAX function Explanation of the AVERAGE function Explanation of the CANCATENATE function Explanation of the UPPER function Explanation of the PROPER function Explanation of the NOW function Explanation of the TODAY function • The 10 most important equations in Excel - Excel course... #Episode_2: A complete explanation of the Count (Count Family) function Lesson contents: Explanation of the COUNT function Explanation of the COUNTA Explanation of the COUNTBLANK function Explanation of the COUNTIF function Explanation of the COUNTIF function How to use the CONDITIONAL FORMATTING • Explanation of all COUNT equations in Excel - Core... #Episode_Three: Explanation of IF equations (IF Family) Lesson contents: Explanation of the IF function Explanation of the IFS function How to create a description of student grades, sales, or employee salaries using the IFS equation • A detailed explanation of the IF and IFS functions in Excel... #Episode_Four: Explanation of SUM equations (SUM Family) Lesson contents: Explanation of the SUM function Explanation of the SUMIF function Explanation of the SUMIFS function Explanation of the TRANSPOSE property • A complete explanation of the SUMIF and SUMIFS equations in... #Episode_Five: Explanation of the VLOOKUP function Lesson contents: A complete explanation of the VLOOKUP function How to use it to create a research system Merging the VLOOKUP function with the IFNA function How to create a description of student grades or sales Or employee salaries via the VLOOKUP equation • Explanation of using the vlookup function Excel course for... #Political_Episode Lesson title: 10 equations for dates in Excel • The 10 most important equations for dates in Excel - Ko... Lesson content: Explanation of the following equations in a practical way: 1- DATE How to form a date 2- DAY How to extract a day from a date 3- MONTH How to extract a month from a date 4- YEAR How to extract a year from a date 5- TEXT How to get the name of the day from the date 6- WEEKNUM How to get the order of the week in the year for a specific date 7- DAYS How to calculate the difference in days between two dates 8- EOMONTH How to determine the number of days in the month 9- DATEDIF How to calculate the difference between two dates by day, month, and year 10- EDATE How to determine the end date based on the start date and the number of months 11- How to combine the VLOOKUP functions with DATE 12- How to merge the EOMONTH with DAY #Episode_7 How to extract all data from the national number Explanation of the equations LEFT RIGHT MID LEN FIND ISODD ISEVEN How to combine the following equations: - LEFT +FIND MID + FIND + LEN RIGHT + FIND + LEN IF + LEN IF + LEFT + MID IF + ISODD + MID VLOOKUP + MID CONDITIONAL FORMATTING Episode link on YouTube: • The 7 most important equations for texts in Excel - Use... #Episode_8 How to use equations to find the minimum, maximum and average Explanation of the equations MIN MINIFS MAX MAXIFS AVERAGE AVERAGEIF AVERAGEIFS Episode link on YouTube: • The most important equations to find the minimum and maximum... #Episode_9 A full explanation of the SUMPRODUCT equation How to use the SUMPRODUCT equation to perform the tasks of the following equations: SUM SUMIF SUMIFS COUNT COUNTIF COUNTIFS Episode link on YouTube: • A full explanation of the secrets of the SUMPRODUCT equation in... #Episode_10 Lesson content: - A full explanation of the OFFSET equation Combining the OFFSET function with the MATCH function • Excel course - Episode 10 - A full explanation of... #Episode_11 Lesson content: - How to create a drop-down list with a variable field Dynamic Range Explanation of combining the INDIRECT function with the COUNTA function • Excel course - Episode 11 - A full explanation of... #Episode_12 Lesson content: - How to create a sequential drop-down list How to create a complete search system using the OFFSET function Combining the OFFSET function with the MATCH function with the COUNTIF function • Excel course - Episode 12 - A full explanation of the INDEX function and how to combine it with the MATCH function to determine the row and column number Episode link • Excel Course - Episode Thirteen - Sh... #Episode_Fourteen How to link more than one t