Full explanation of the FILTER function in Excel How to filter a set of data based on one condition How to filter a set of data based on two conditions that must occur together How to filter a set of data based on two conditions (if one of them occurs) How to filter data based on a condition that is greater or less than a specific value How to display specific columns after completing the filtering process How to download Office 365 from the Microsoft website for free and officially • How to download Office 365 from the Microsoft website... A complete Excel course for beginners #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) function Family) Lesson contents: Explanation of the COUNT function Explanation of the COUNTA function 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 search system Merge the VLOOKUP function with IFNA Function How to create a description of student grades, sales or employee salaries using 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 - Co... Lesson Content: Explanation of the following equations in a practical way: 1- DATE How to create 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 a 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 a 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 function 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 merge the following equations: - LEFT +FIND MID + FIND + LEN RIGHT + FIND + LEN IF + LEN IF + LEFT + MID IF + ISODD + MID VLOOKUP + MID CONDITIONAL FORMATTING Link to the episode 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 Link to the episode on YouTube: • The most important equations to find the minimum and maximum... #Episode_9 Full explanation of the SUMPRODUCT equation How to use the equation SUMPRODUCT To perform the following equation tasks: 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 MATCH function to determine row and column number Episode link • Excel course - Episode thirteen - Sh... #Episode_fourtee