Advanced Skills in Excel 2021 Free Course
Learn advanced skills in Excel and learn the most important and most commonly used equations in Excel
Advanced Excel Outputs:
- Explanation of the most important and most commonly used functions in Excel
- Explanation of the working methods of pivot tables
- Explain how to find and replace in Excel
- Explain how to divide and quotation cells in Excel
- Explain how to arrange and filter data Sort, Filter S
- Explain how to protect cells that contain equations with a password
Advanced Excel Requirements:
- Seriousness and desire to learn
- The practical application of the course step by step while watching the explanation
Course coach:
Coach Hesham Abdul-hamid Eisa
Excel Course Contents:
- the first lecturer
- The easiest explanation of the if, if compound function
- How to search for a specific need in the excel file – replace words with other words
- How to make Sort, Filter in Excel
- The second lecture
- Explanation of the SUMIF function, Sumifs
- COUNT Function COUNT,COUNTA,COUNTBLANK,COUNTIF,COUNTIFS
- How to split a cell in excel
- Third lecture
- Explanation of the AND function, OR-0
- Explanation of how to link the iF function with And and Or (Ifand, If or)
- How to protect specific cells in the excel sheet
- Fourth lecture
- Pivot table Pivot tables
- Explanation of Data Validation drop-down list in Excel
