Course Modules

Check out what you'll be learning!

    1. A Quick Hello from Your Instructor 👋🏽

    2. Let Me Show You Around

    3. Download Your Materials 📥

    4. 🛠️ Course Help & Support

    5. How To Use This Platform

    1. Nice to meet you, Excel!

    2. Excel's Structure

    3. 🔑 Correctly Referencing Cells (Part 1)

    4. 🔑 Correctly Referencing Cells (Part 2)

    5. 🔑 Correctly Referencing Cells (Part 3)

    6. Hardcoded vs. Dynamic Cells

    7. Keyboard Shortcuts Are Critical

    8. Manage Common Error Codes

    9. New Window View

    10. Freeze Parts of your Sheet

    11. No Grid Lines

    1. Welcome to Formatting!

    2. Formatting 101

    3. Number Formats

    4. Alignment Options

    5. Borders

    6. Cell Shading & Styles

    7. Visible Cells Only

    8. Paste Special (Part 1)

    9. Paste Special (Part 2)

    10. Paste Special (Part 3)

    1. Welcome to Conditional Formatting!

    2. Using the Pre-Sets (in CF)

    3. Creating New Rules (in CF)

    4. Conditional Formatting for Whole Rows

    5. Conditional Formatting Cheat Sheet

    1. An Introduction to Functions in Excel

    2. Anatomy of a Function

    3. Basic Maths Functions (SUM, PROD, COUNT)

    4. Logical Statements (IF)

    5. Sum Cells Based on Specific Criteria (SUMIFS)

    6. Count Cells Based on Specific Criteria (COUNTIFS)

    1. Welcome to Lookup Functions!

    2. Why VLOOKUP Is Dead 💀

    3. XLOOKUP instead of VLOOKUP

About this course

  • 3.5 hours of video content
  • 50+ lessons

The Excel Confidence Course

Transform the way you work with Excel. Learn the most powerful features in simple steps - no fluff, just real skills that make your workday easier.

Enrol Now