Free Excel Course for Beginners with Quizzes (2026): Learn Spreadsheets That Actually Stick
The best free Excel courses for beginners in 2026 — with quizzes, not just video walkthroughs. Learn why passive watching leaves you stuck at SUM() and what to do instead.
You've watched an Excel tutorial. You followed along, typed in the formulas, felt good about it. Then you opened a blank spreadsheet at work and couldn't remember how VLOOKUP worked.
This is normal. It's also fixable — but not by watching more tutorials.
The problem with most free Excel courses isn't the content. It's the format. You watch someone else use Excel. Your brain creates the illusion of understanding. Two days later, without the video in front of you, nothing is there. Passive learning is good at building familiarity. It's terrible at building skill.
The fix is retrieval practice: making your brain produce the answer without a cue. That's what quizzes do. Every time you struggle to recall a formula or explain what a pivot table does, you're doing the work that actually creates long-term retention. The research on this goes back decades — retrieval practice outperforms re-reading and re-watching by a significant margin, especially for procedural skills like spreadsheet use.
This guide covers the free Excel courses worth your time in 2026 — specifically the ones that include quizzes, exercises, or some form of active recall, not just hours of screencasting.
What "Learning Excel" Actually Means
Excel has about 500 functions. No one needs to know all of them. What you actually need depends on what you're doing.
Here's a more honest breakdown of Excel skill levels:
Level 1 — Functional (most people's goal):
- Entering and formatting data
- Basic formulas: SUM, AVERAGE, COUNT, MIN, MAX
- Sorting and filtering
- Simple charts
Level 2 — Useful (what employers actually mean by "Excel skills"):
- IF, SUMIF, COUNTIF
- VLOOKUP or XLOOKUP (VLOOKUP is older; XLOOKUP is the 2026 standard)
- Named ranges
- Basic pivot tables
- Data validation
Level 3 — Advanced (data analysts, finance, operations):
- Nested IF and logical functions (AND, OR, NOT)
- INDEX/MATCH
- Power Query for cleaning messy data
- Dynamic arrays (FILTER, SORT, UNIQUE)
- Macro basics with VBA or Power Automate
The mistake beginners make is trying to learn all of this linearly, starting from cell formatting and grinding toward VBA. A better approach: learn exactly what you need for your current job or project, quiz yourself on that subset until it's automatic, then expand.
Free Excel Courses with Quizzes Worth Using
ChaptrAI — Business and Data Skills with Built-in Quizzes
ChaptrAI's free courses include built-in quizzes after every module — the kind that make you recall concepts rather than just recognise them. The Business courses on ChaptrAI cover spreadsheet fundamentals, data interpretation, and analytical thinking as part of a broader curriculum. The Data Science courses pair well for anyone who wants to move from Excel basics into more analytical work. Quiz scores are tracked per module, so you can see at a glance where your understanding is solid and where it isn't.
No account required to start. Free.
GCFGlobal Excel Training
GCFGlobal (from Goodwill Community Foundation) has been making free, genuinely beginner-friendly courses for years. Their Excel section includes chapter quizzes — not just walkthroughs. The material covers Level 1 and most of Level 2. It's slightly dry in presentation, but it's thorough and the quizzes actually test your understanding rather than just asking you to identify a menu item.
Microsoft's Own Free Training
Microsoft has free Excel training at support.microsoft.com and through Microsoft 365 Training. The tutorials are good for specific functions — use them as references when you hit a concept you don't understand. There are no quizzes, but the built-in Excel practice exercises (when available) fill some of that gap.
ExcelJet Formulas Reference with Practice
ExcelJet isn't a structured course, but it's one of the best formula references available — with examples you can try yourself. Best used as a companion to a course: learn a concept, go to ExcelJet to see a clean worked example, then come back and quiz yourself.
Chandoo.org Excel School (Free Tier)
Chandoo has a free Excel email series that covers beginner to intermediate content. It's more newsletter than course, but the exercises included are genuinely useful and more practical than most. Good for Level 2 concepts specifically.
The Three Functions Beginners Should Master First
Before anything else, get these automatic — meaning you can write them without looking anything up:
1. IF
=IF(A1>100, "High", "Low") — evaluates a condition and returns one of two values. Once you understand IF, nested IF and SUMIF follow naturally. The quiz question that reveals whether you actually understand it: "Write an IF formula that shows 'Pass' if score is above 60, otherwise 'Fail'."
2. XLOOKUP
=XLOOKUP(lookup_value, lookup_array, return_array) — finds a value in one column and returns a corresponding value from another. Replaced VLOOKUP in modern Excel. The test: given a table of product IDs and prices, write an XLOOKUP that returns the price for a specific product ID.
3. SUMIF
=SUMIF(range, criteria, sum_range) — sums values that meet a condition. More useful day-to-day than SUM alone. The test: given a sales table with regions and amounts, sum only the sales from the East region.
If you can write these three from memory and explain what each argument does, you're past the beginner stage for practical purposes.
A Two-Week Study Plan That Actually Works
Days 1–3: Interface and basics. Learn cells, ranges, basic arithmetic formulas, formatting. Take a quiz on cell references (relative vs absolute — this is where most people have a hidden gap). Make sure you understand the difference between =A1, =$A1, =A$1, and =$A$1 before moving on.
Days 4–7: Core functions. Learn SUM, COUNT, AVERAGE, MIN, MAX. Then learn IF. Build a simple grade tracker from scratch — a table of names and scores that automatically marks each as Pass or Fail. Don't copy a template. Build it yourself.
Days 8–10: Lookup functions. Learn XLOOKUP (or VLOOKUP if you're on an older version). Practice with a real dataset — download any free sample data from Kaggle or use a table you already have. Quiz yourself: given this table, write the formula to look up X.
Days 11–14: Pivot tables. These seem intimidating and are actually straightforward. Build one from a dataset with at least 100 rows. Drag fields around until you understand what rows/columns/values/filters do. The understanding clicks through doing, not watching.
After two weeks, take a free online Excel quiz (GCFGlobal or an Excel practice test) and see where you land. Identify your bottom two or three areas and spend the following week specifically on those.
Frequently Asked Questions
How long does it take to learn Excel for free?
For practical Level 1–2 skills, 2–4 weeks of focused daily practice (30–60 minutes a day) is realistic. Getting comfortable with pivot tables and XLOOKUP typically takes a couple of weeks on top of that. "Learning Excel" in the sense of being genuinely fast and fluent takes longer — it builds through real use, not courses.
Is Microsoft Excel still worth learning in 2026?
Yes. Despite competition from Google Sheets, Notion databases, and BI tools like Power BI, Excel remains the most widely used spreadsheet tool in professional environments — especially in finance, operations, accounting, and data-adjacent roles. The skills transfer almost entirely to Google Sheets for anything not Excel-specific.
What's the difference between Excel and Google Sheets?
They're about 90% the same for beginner and intermediate use. The core functions (SUM, IF, VLOOKUP/XLOOKUP, pivot tables) work identically. The main differences are: Excel has more advanced features (Power Query, VBA), Google Sheets is better for real-time collaboration. If you learn one, you can use the other.
Do I need Microsoft 365 to learn Excel?
No. Microsoft 365's web version (excel.microsoft.com) is free with a Microsoft account and covers everything through Level 2. The desktop app has more power features, but you don't need it to start.
Can Excel help with data analysis?
Yes, especially at the beginner level. Excel handles most common data analysis tasks — cleaning data, calculating summaries, building charts, running simple statistics. For anything beyond that — large datasets, machine learning, automation — tools like Python and SQL become more appropriate. The free Data Science courses on ChaptrAI and Statistics courses pair naturally with Excel skills for building analytical thinking before moving to code.
Is a free Excel certificate worth anything?
It demonstrates completion, not competence. What matters to employers is whether you can actually do the task. That said, completing a structured course and earning a certificate — particularly from a recognizable platform — gives you a talking point in interviews and creates a real finish line. The free Business courses on ChaptrAI include completion certificates at no cost.
The Bottom Line
Free Excel courses are everywhere. The ones that actually work are the ones that make you practice recalling formulas, not just watching them. The standard "watch a video, feel good, close the tab" loop doesn't build skill. Quizzes do.
Pick a course that includes testing. Build the core functions — IF, XLOOKUP, SUMIF — until they're automatic. Build something real in week two. The rest will follow.