Learn Excel
A free, interactive online Excel course. You work in a real spreadsheet on every lesson - typing formulas, not watching them - with a free certificate when you finish.
10,062+ codders enrolled
70 lessons62 challenges335 quiz questions
- Beginner friendly
AI-assisted coding help
Hands-on interactive lessons
Audio narration on every lesson
Quizzes to test your knowledge
Free certificate of completion
Syllabus
Section 1
Fundamentals
Start sectionStartStart your spreadsheet journey: the grid, cells, formulas, references and the everyday functions that make Excel powerful.Meet the Spreadsheet
5 lessons324Entering Data
5 lessons431Your First Formula
6 lessons539Cell References
5 lessons330Basic Functions
7 lessons648Working with Text
5 lessons532Decisions with IF
5 lessons431Project: Grade Book
4 lessons4Section 2
Formulas and Data Analysis
Start sectionStartBuild on Excel Fundamentals with reusable references, logical conditions, conditional summaries, exact lookups and text cleanup. Solve practical workbook challenges with formulas that adapt to changing data.Reusable Formulas
5 lessons920Logical Decisions
5 lessons920Conditional Summaries
5 lessons920Lookup Tables
5 lessons920Cleaning Imported Data
5 lessons920Final Challenges
3 lessons3
Learn by Doing
Write real code, query databases, build websites, and master AI prompts. Our interactive lessons cover every skill modern developers need.
Build Your Streak
Stay consistent and watch your progress grow! Track your daily coding habit, protect your streak with freeze days, and earn rewards for showing up every day.
12 days streak
Return tomorrow to keep your streak!
January 2026
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
21
22
23
24
25
26
27
28
29
30
Double or Nothing
Day 5 of 7
Streak Freeze
2 left
Code Anywhere
Take your coding journey on the go! No setup, no downloads: just open and start coding. Available on iOS, Android and Web with 4.9 star ratings.
You're Not Alone
Compete on global leaderboards, invite friends to earn rewards, and celebrate each other's wins. Coding is better with friends!
1
2
3
Promotion zoneEvery way to learn
Read, listen, test yourself, ask the AI, or look up anything you've already covered. Every lesson meets you where you are.
A variable is a named container that stores a value you can reference later in your program.
In Python, you create one by writing the name, an equals sign, then the value you want to store.
The value can change over time. Reassigning the name simply points it to a new value.
Earn a Certificate
Earn certificates for every course you complete. Add them to your LinkedIn profile and resume to showcase your coding expertise to employers.
Certificate of CompletionPython Fundamentals
Add to LinkedInWhy learn Excel with Coddy
- Work in a real spreadsheet in your browser. No Excel licence, no download, no Microsoft 365 subscription. Every lesson opens a live grid, you type the formula, and it's checked instantly.
- Excel as it's actually used at work: cell references and absolute references, SUM and AVERAGE, IF and nested conditions, COUNTIF and SUMIF, text and date functions, VLOOKUP and XLOOKUP, sorting, filtering, and summarizing a dataset into a report.
- Every lesson is a task, not a video. You get a small dataset and a goal - total this column, flag the rows over budget, look up the price for this product code - and you finish it in the sheet.
- Free Excel certificate when you finish the course. Excel is one of the most-listed skills on job postings, and a completion certificate is a credible line on a CV or LinkedIn profile.
Frequently asked questions about learning Excel
Do I need to own Microsoft Excel to take this course?
No. The lessons run in a spreadsheet inside your browser, so you don't need Excel installed or a Microsoft 365 subscription. The formulas you learn are standard spreadsheet formulas - they work the same way when you open a real .xlsx file in Excel, and almost identically in Google Sheets or LibreOffice Calc.
How long does it take to learn Excel?
Most people get comfortable with the everyday essentials - formulas, cell references, SUM/AVERAGE/IF, and basic lookups - in a couple of weeks of short daily sessions. Reaching the level employers mean by "strong Excel skills" (lookups, nested conditions, cleaning messy data, and summarizing it) usually takes a few weeks more of regular practice.
Is Excel hard to learn?
Excel is easier to start than a programming language: your first formula is one line and you see the result immediately. The parts people find hard are the ones that need practice rather than theory - absolute vs relative references, nested IFs, and lookup functions. Because each lesson here is a task in a live sheet, those are exactly the parts you spend your time doing.
Which Excel formulas should I learn first?
Start with SUM, AVERAGE, MIN, MAX and COUNT, then learn how cell references work (including the $ that makes them absolute). After that: IF for conditional logic, COUNTIF and SUMIF for conditional totals, the text functions (LEFT, RIGHT, MID, TRIM, CONCAT) for cleaning up data, and finally VLOOKUP, XLOOKUP or INDEX/MATCH for pulling values from another table. The course follows roughly that order.
Is this Excel course really free?
Yes. The full interactive Excel course on Coddy is free - lessons, spreadsheet exercises, quizzes, and a certificate of completion. Nothing to install, and you can start the first lesson without an account.
Do I get an Excel certificate when I finish?
Yes - completing the course issues a free certificate of completion you can share on LinkedIn or add to your CV. It's verifiable, so a recruiter can confirm it's real.
Will these skills transfer to Google Sheets?
Almost entirely. Formulas, cell references, IF, COUNTIF/SUMIF, the text and date functions, sorting and filtering all work the same way in Google Sheets. The main differences are in the interface and a handful of function names, so once you can build a formula in Excel you can build it in Sheets.
