Microsoft Excel 2021 — The Complete Introduction
Self-paced video training — 7 modules, 19 lessons. Work through it at your own pace — every lesson is real recorded training, not slide-reading.
▶INSIDE THE COURSE · 19 LESSONSABOUT THIS COURSE
In this beginner course, students learn the fundamentals of Microsoft Excel 2021, including basic functions, formulas, and the differences between relative and absolute cell references. The course covers how to create and use key functions like IF and VLOOKUP, as well as how to visually represent data through charts. Additionally, students will practice importing data from the web to enhance their data management skills.
CURRICULUM
7 modules, in order.
01Introduction1 LESSONS
this lesson provides an overview of the course and what to expect.
02Starting out5 LESSONS
learn the fundamental features and interface of excel.
understand the difference between relative and absolute cell references.
discover the distinction between functions and formulas in excel.
explore basic formulas used in excel for calculations.
engage in a practical exercise to apply basic excel skills.
03Functions4 LESSONS
get introduced to various functions available in excel.
learn how to use the IF function for logical comparisons.
understand how to use the VLOOKUP function for data retrieval.
participate in a practical exercise to practice using functions.
04Charts and data4 LESSONS
learn methods for visually representing data in excel.
discover how to create and utilize charts in excel.
learn how to import data from the web into excel.
engage in a practical exercise focused on data visualization.
05Pivot tables1 LESSONS
get introduced to the concept and features of pivot tables.
06Project 1 Creating a gradebook3 LESSONS
begin building the architecture of a gradebook application.
learn to enter necessary functions for the gradebook project.
manipulate data and tests as part of the gradebook project.
07Final Words1 LESSONS
receive final thoughts and wrap up the course.
CURATED BY
Selected from experienced educators' training libraries and kept whole — modules, worked examples and walkthroughs exactly as taught.
GOOD TO KNOW
Lessons stream in the browser and remember where you stopped.
Watch on two devices at once — phone, tablet or desktop.
Download buttons are disabled; delivery is encrypted and authenticated per request.
$39 · ONE PAYMENT
Own every lesson, for life.
One payment unlocks all 19 lessons instantly — start with lesson one the moment you check out.