Course curriculum

    1. Telegram Community Group

    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

    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

    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

    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. Module Quiz

About this course

  • $27.00
  • 48 lessons
  • 9 hours of video content

Discover your potential, starting today