Excel Fundamentals for Work

The formulas, data cleaning habits, and reporting basics that show up in almost every entry-level office job — taught the way you'll actually use them.

2 hrsTotal video

BeginnerLevel

Self-pacedFormat

EnglishLanguage

LifetimeAccess

A1 · Who it's for

Absolute beginners to Excel

If you've only ever used Excel to type numbers into cells, this course gets you to the point where you can confidently clean data and build a simple report — the baseline expected in almost any office role.

B1 · What you'll be able to do

Outcomes

✓ Format and validate data so it's error-free and consistent
✓ Use SUMIFS, COUNTIFS, VLOOKUP/XLOOKUP confidently
✓ Nest IF statements for real conditional logic
✓ Build a basic PivotTable summary report

C1 · Curriculum

2 modules, 1 mini-project

~2 hours of video · 1 practice dataset

Formatting, data validation, avoiding common entry errors
Sorting, filtering, and removing duplicates

SUMIFS, COUNTIFS, VLOOKUP/XLOOKUP
Nested IF logic
Mini project: clean and summarize a messy sales dataset

D1 · Where to go next

Ready for more once you finish this?

This course feeds directly into our flagship program, which adds Power BI and a full portfolio project.

See Job-Ready Data Skills: Excel + Power BI