New video: The first lesson in the Pivot Table The first step in creating reports professionally How to insert a pivot table Explain the components and elements of the pivot table How to create quarterly reports How to add a new column or row to the main data of the pivot table (change pivot table data source) How to update the pivot table Explain the filter system in the pivot table How to convert a pivot table into a PDF file All files used in the videos are available, God willing, on the HR Online Lessons group on Telegram t.me/Dross_HR_Online How to make a professional report How to insert a pivot table Explain the components of the pivot table How to make quarterly reports How to add a new column or row to the main data of the pivot table (change pivot table data source) How to update the pivot table Explain the filter system in the pivot table (Slicer) How to convert a pivot table into a PDF file 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 all beginners 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_Two: A complete explanation of the Count (Count Family) function 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 - Excel course... #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 (SUM Family) equations 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 Merge the VLOOKUP function with the 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... #Episode_Six Lesson title: 10 date equations in Excel • The 10 most important date equations in Excel - Co... Lesson contents: 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 On 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 combine the EOMONTH functions with DAY #Episode_Seven 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 Link to the episode on YouTube: • The 7 most important text equations in Excel - Episode 8 How to use the 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