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

  • SUM

  • AVERAGE

  • MIN / MAX

  • Counting data (COUNT vs COUNTA)

Previous
Next