Course curriculum

    1. Course Welcome

    2. Course Resources

    1. Microsoft Excel Home introduction

    2. Microsoft Excel Interface

    3. Microsoft Excel Data input

    4. Basic Excel Data Formatting

    5. Protect Excel Worksheet & Tab colours

    6. 10 Useful Basic Excel Keyboard Shortcuts

    1. What is Formula & What is Function ?

    2. Sum & Sumif Function

    3. Count, Counta & Countif

    4. Min & Max Function

    5. Average Function

    6. Sumproduct Function

    7. Important For Functions

    8. VLookup Function

    9. HLookup Function

    10. V & HLookup's Limitations

    11. Lookup Function

    12. Index & Match

    13. Xlookup Function

    14. Filter Function

    1. Conditional Formatting - Highlighting Cell Rules

    2. Conditional Formatting - Top & Bottom Rules

    3. Conditional Formatting - Data Bars & Icons

    4. Conditional Formatting - Highlighting Cells Using Formula

    1. Column & Bar Chart

    2. Excel Pie Chart

    3. Excel Histogram Chart

    4. Excel Line Chart

    1. Excel Table Benefits

    2. Excel Tables - Template Design

    3. Excel Tables - Formatting

    4. Excel Tables - Slicer

    5. Excel Tables - Filters

    6. Excel Tables - Structural Reference

    7. Excel Tables - SUM & SUMIFS

    8. Excel Tables - Lookups

    9. Excel Tables - Count & Countifs

About this course

  • $20.00
  • 44 lessons
  • 5.5 hours of video content

Discover your potential, starting today

Enroll today