Course Modules

Check out what you'll be learning!

    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. Quick Cheat Guide to Conditional Formatting

    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

    1. Welcome to Cleaning Data

    2. ⭐ Always Make A Copy!

    3. Remove Duplicates

    4. No Blank Cells, Please

    5. No Sub-Totals, Please

    6. Consistent Data Types are Key

    7. Clean Data Checklist

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