Course curriculum

    1. Telegram Community Group

    2. Download and Install Microsoft Office 2021

    3. Download All Course Excel Files

    1. Excel Home Page Explained

    2. Excel Interface

    3. Microsoft Excel Data Entry

    4. Microsoft Excel Data Formating

    1. What is Formula & Function

    2. SUM, SUMIF & SUMIFS Function

    3. COUNT, COUNTIF & COUNTIFS Function

    4. MIN, MAX & MAXIFS Function

    5. AVERAGE & AVERAGEIFS Function

    6. SUMPRODUCT Function

    7. Excel References Explained

    8. IF & IFS Function

    9. EXCEL FORMULA ERROR'S

    10. IFERROR FUNCTION

    11. Formulas Part 1 Assignment

    12. Result: Excel Formulas Part 1 Assignment

    1. Lookup Function

    2. Lookup Limitations

    3. Vlookup Function

    4. Vlookup Limitations

    5. Hlookup Function

    6. Index & Match Function

    7. Xlookup Function

    8. Xlookup Limitations

    9. Filter Function

    10. Qaacidooyinka & Adeegsigooda

    11. Formulas Part 2 Assignment

    12. Result: Excel Formulas Part 2 Assignment

    1. Highlight Cells Rules - Conditional Formatting

    2. Top-Bottom Rules - Conditional Formatting

    3. Data Bars - Conditional Formatting

    4. Icons Set - Conditional Formatting

    5. Zebra Line Effect - Conditional Formatting

    6. Manage Rules - Conditional Formatting

    7. Formulas - Conditional Formatting

    8. Module Assignment

    9. Result: Excel Conditional Formatting Assignment

    1. Excel Tables Introduction & Formatting

    2. 8 Reasons to Choose Excel Tables

    3. Sorting In Excel Tables

    4. Filter In Excel Tables

    5. SLICER - Excel Tables

    6. SUM Function - Excel Tables

    7. COUNT Function - Excel Tables

    8. XLOOKUP Function - Excel Tables

    9. Excel Tables: Advanced Functions

    10. Module Quiz

    11. Result: Excel Tables Assignment

About this course

  • $27.00
  • 85 lessons
  • 15.5 hours of video content

Discover your potential, starting today