Lesson 3.2 — Filters (3–4 minutes)

Course Content

MODULE 1 — Getting Started with Excel

Goal: Learners understand the interface and can confidently open, save, and navigate a workbook.

0/5

The Excel Environment and Navigation

06:14

Lesson 1.1 — What is Excel & What Can It Do?

07:00

Lesson 1.2 — Excel Interface Tour

Lesson 1.3 — Creating, Saving & Opening Files (2–3 minutes)

Lesson 1.4 — Navigating a Spreadsheet (2–3 minutes)

MODULE 2 — Entering & Formatting Data

Goal: Learners can enter data cleanly and make it readable.

0/4

Lesson 2.1 — Entering Text, Numbers & Dates (2–3 minutes)

Lesson 2.2 — Basic Cell Formatting (3–4 minutes)

Lesson 2.3 — Number Formatting (2–4 minutes)

Lesson 2.4 — Copy, Cut, Paste & AutoFill (2–3 minutes)

MODULE 3 — Essential Excel Skills

Goal: Learners can work with data more efficiently.

0/4

Lesson 3.1 — Sorting Data (3 minutes)

Lesson 3.2 — Filters (3–4 minutes)

Lesson 3.3 — Freeze Panes (2 minutes)

Lesson 3.4 — Basic Printing Setup (3–4 minutes)

MODULE 4 — Introduction to Formulas

Goal: Build confidence typing formulas from scratch.

0/3

Lesson 4.1 — How Formulas Work (2–3 minutes)

Lesson 4.2 — AutoSum & Basic Functions (3–4 minutes)

Lesson 4.3 — Relative vs. Absolute References (3–4 minutes)

MODULE 5 — Working With Tables & Simple Charts

Goal: Learners can present information clearly.

0/3

Lesson 5.1 — Converting Data to a Table (2–3 minutes)

Lesson 5.2 — Creating a Basic Chart (3–4 minutes)

Lesson 5.3 — Formatting Charts (3–4 minutes)

MODULE 6 — Practical Mini-Projects (Guided Practice)

Goal: Apply skills to real beginner tasks.

0/3

Lesson 6.1 — Monthly Budget Tracker (3–4 minutes)

Lesson 6.2 — Simple Contact List (2–3 minutes)

Lesson 6.3 — Basic Sales Dashboard (4 minutes)

MODULE 7 — Wrap Up & Next Steps

0/2

Lesson 7.1 — Course Review (2 minutes)

Lesson 7.2 — What to Learn Next (2 minutes)

Mastering Microsoft Excel Fundamentals

Adding filters
Filtering by text, number, date
Clearing filters