← All courses
📊Beginner
Microsoft Excel Essentials
Work confidently with spreadsheets — cells, formulas, functions, charts and tidy, useful data.
5 modules · 23 lessons · 23 lessons
Share
Free
What you'll learn
- Cells & ranges
- Formulas
- Functions
- Charts
Curriculum
6 modules · 23 lessonsModule 1Getting started4 lessons
Cells, rows & columnsPreviewEntering data
Number formatting
Selecting & ranges
Module 2Formulas4 lessons
Your first formula
Cell references
Relative vs absolute references
Copying formulas
Module 3Functions5 lessons
SUM & AVERAGE
COUNT & COUNTA
MIN & MAX
IF (logic)
VLOOKUP & XLOOKUP
Module 4Working with data4 lessons
Sorting
Filtering
Tables
Conditional formatting
Module 5Charts & visuals3 lessons
Creating a chart
Choosing the right chart
Formatting charts
Module 6Putting it together3 lessons
Building a simple budget
Common mistakes
Where to go next
Reviews
No reviews yet.
