Free Excel course
10 lessons, no lectures. Do the task in the sheet and the site checks it right away.
Lesson 1: Typing in cells
- Click cell A2, type Milk and press Enter
- Click B2 and type 2
- In row 3: Bread, amount 1
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | |||
| 3 | |||
| 4 | Eggs | 30 | |
| 5 | Cheese | 2 | |
| 6 | Delete me | ||
| 7 |
- A2 = Milk
- B2 = 2
- A3 = Bread
- B3 = 1
All lessons
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
The course goes from easy to hard: type in cells, format a table, write your first formula, then SUM and AVERAGE, dragging and filling with $, MAX, MIN and COUNT, IF and COUNTIF, sorting, charts, and finally a family budget project. Each lesson takes 5 to 10 minutes.
The sheet works like Excel in English: column A is on the left, Enter moves down a row, Tab moves to the next column, F2 edits a cell, Ctrl+B makes text bold, Ctrl+D fills down and Ctrl+Z undoes. While you type a formula you can click a cell or drag across a range, and the address is typed into the formula for you.
Frequently asked questions
Do I need Excel installed on my computer?
No. All the practice happens in the sheet inside the page, and the site checks every task right away. After each lesson, try the same thing in Excel or Google Sheets. The formulas are the same.
Who is the course for?
Complete beginners: parents, teachers, job seekers and students from about age 10. There is no background reading. Each lesson is a sheet with a real-life task, like a shopping list, test scores or a budget.
Which formulas will I learn?
Adding, subtracting, multiplying and dividing, SUM, AVERAGE, MIN, MAX, COUNT, COUNTBLANK, IF and COUNTIF, absolute references with $, AutoFill by dragging, sorting, dollar formatting and charts.
Do the formulas here work in real Excel?
Yes. They use the same English function names and commas that Excel uses in the US, so you can copy them straight into Excel or Google Sheets. In some countries Excel uses semicolons instead of commas, and the sheet here accepts both.
Is my progress saved?
Yes, in the browser where you practiced. A finished task gets a ✓, and a finished lesson gets a ✅.
Explore more: Lesson 1: Typing in cells.