---
title: "Free Excel course online: from zero to job-ready | PracticeExcel"
description: "An Excel course for beginners in nine modules, from cells and SUM to lookups and summary tables. You practice in the browser, and the first part is free with no account."
canonical_url: "https://practiceexcelonline.com/learn/how-to-learn-excel"
locale: en
meta:
"og:description": "An Excel course for beginners in nine modules, from cells and SUM to lookups and summary tables. You practice in the browser, and the first part is free with no account."
"og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RnJlZSBFeGNlbCBjb3Vyc2Ugb25saW5lOiBmcm9tIHplcm8gdG8gam9iLXJlYWR5%2Cdescription_~QW4gRXhjZWwgY291cnNlIGZvciBiZWdpbm5lcnMgaW4gbmluZSBtb2R1bGVzLCBmcm9tIGNlbGxzIGFuZCBTVU0gdG8gbG9va3VwcyBhbmQgc3VtbWFyeSB0YWJsZXMuIFlvdSBwcmFjdGljZSBpbiB0aGUgYnJvd3NlciwgYW5kIHRoZSBmaXJzdCBwYXJ0IGlzIGZyZWUgd2l0aCBubyBhY2NvdW50Lg%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9ob3ctdG8tbGVhcm4tZXhjZWwi%2Cs_2GhckB7Yguq-_1ts.png"
"og:image:height": "600"
"og:image:type": image/png
"og:image:width": "1200"
"og:title": "Free Excel course online: from zero to job-ready | PracticeExcel"
"twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RnJlZSBFeGNlbCBjb3Vyc2Ugb25saW5lOiBmcm9tIHplcm8gdG8gam9iLXJlYWR5%2Cdescription_~QW4gRXhjZWwgY291cnNlIGZvciBiZWdpbm5lcnMgaW4gbmluZSBtb2R1bGVzLCBmcm9tIGNlbGxzIGFuZCBTVU0gdG8gbG9va3VwcyBhbmQgc3VtbWFyeSB0YWJsZXMuIFlvdSBwcmFjdGljZSBpbiB0aGUgYnJvd3NlciwgYW5kIHRoZSBmaXJzdCBwYXJ0IGlzIGZyZWUgd2l0aCBubyBhY2NvdW50Lg%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9ob3ctdG8tbGVhcm4tZXhjZWwi%2Cs_2GhckB7Yguq-_1ts.png"
---
> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)
# **Free Excel course online: learn Excel from your first formula to job-ready**
An Excel course for beginners in nine modules, from cells and SUM to lookups and summary tables. You practice in the browser, and the first part is free with no account.
By Nicolaj Gajhede, founder of PracticeExcel · Updated November 2, 2026 · 13 min read
Most people learn Excel the hard way: a deadline, a spreadsheet someone else built, and a lot of searching for "how to sum only some rows". It works, eventually, but it leaves gaps. You end up knowing the three functions your old job used and nothing in between.
This course gives you a better order. It's an Excel course for beginners that you take online at your own pace, split into nine modules, from the grid and your first formulas to lookups, text, dates and keyboard speed. Each module says what to learn, how long it usually takes and how to know you're ready to move on. Every module links to exercises where you type the formulas yourself in a real spreadsheet and get them graded right away.
## The course on one page
| **Module** | **What you learn** | **Time** | **Start here** |
| --- | --- | --- | --- |
| 1. The grid | Cells, selecting, Enter, Tab and Esc | An hour or two | [**Cells, rows and columns**](https://practiceexcelonline.com/practice/the-grid/cells-rows-and-columns) |
| 2. First formulas | =, cell references and operators | An afternoon | [**Add two cells**](https://practiceexcelonline.com/practice/first-formulas/add-two-cells) |
| 3. The basic functions | SUM, AVERAGE, MIN, MAX, COUNT and ROUND | A few days | [**Add up a column with SUM**](https://practiceexcelonline.com/practice/sum/sum-a-column) |
| 4. Copying formulas | References that move, $, Ctrl+D and F4 | A day | [**Fill a formula down and right**](https://practiceexcelonline.com/practice/editing-and-filling/fill-down-and-right) |
| 5. Logic with IF | IF, nested IF, AND and OR | A few days | [**Pass or fail with IF**](https://practiceexcelonline.com/practice/if/if-pass-fail) |
| 6. Conditional counts and sums | COUNTIF, SUMIF, SUMIFS and summary tables | A week | [**COUNTIF with a text condition**](https://practiceexcelonline.com/practice/countif/countif-text) |
| 7. Lookups | VLOOKUP, XLOOKUP, INDEX and MATCH and IFERROR | A week | [**Look up a price with VLOOKUP**](https://practiceexcelonline.com/practice/vlookup/vlookup-exact-match) |
| 8. Text and dates | Clean up text and calculate with dates | A week | [**Remove extra spaces with TRIM**](https://practiceexcelonline.com/practice/trim-proper-upper/trim-extra-spaces) |
| 9. Speed | Keyboard shortcuts | Ongoing | [**Shortcut drills**](https://practiceexcelonline.com/shortcuts) |
Every exercise in the Start here column is free. Take the modules in order, and move on only when you can solve the exercises without hints. At 20 to 30 minutes most days, you'll get through the whole course in about six weeks.
## What's free?
You can read the whole course for free, and a large part of the exercises is free too. With no account and no payment, you get:
- **Getting started**, the grid and first formulas topics from modules 1 and 2.
- **The whole SUM, AVERAGE and COUNT topics** from module 3.
- **The shortcut drills** from module 9.
- **The first exercise in every other topic**, so you can try each module.
- **A timed preview** of every mock test.
Premium unlocks the rest of the exercises and a certificate for every topic you complete, with your name and a link anyone can check. While you practice without an account, your progress is saved in the browser, and it moves into your account when you create one.
## Why order matters
Excel is not a list of 500 functions to memorize. It is a small number of ideas that everything else builds on. Learn them in the right order and each new function is a variation on something you already know. Learn them out of order and every function feels like a new trick.
Three ideas carry most of the weight:
1. **A formula is a calculation that refers to cells**, not to numbers. `**=B2*C2**` keeps working when the quantity in B2 changes. `**=4*25**` does not.
2. **References move when you copy a formula**, unless you tell them not to with `**$**`. This is what lets one formula fill a whole column.
3. **Ranges and conditions**: most useful functions take a range (B2:B100) and often a condition ("North", ">1000"). Once you understand SUMIF, you understand COUNTIF, AVERAGEIF and SUMIFS.
Every module below leans on these three. If something later on feels confusing, it is usually one of them that has not clicked yet.
## Module 1: the grid (an hour or two)
Before any formulas, get comfortable with the sheet itself. You should know:
- What a **cell**, a **row**, a **column** and a **range** are, and how cells are named (B3 is column B, row 3).
- How to **select** a range with the mouse and with Shift+Arrow keys.
- How to **type and edit** text and numbers, and the difference between Enter (move down), Tab (move right) and Esc (cancel).
- That **text aligns left and numbers align right** by default, which is a quick way to spot a number stored as text.
Our [**Getting started**](https://practiceexcelonline.com/practice/the-grid) topic covers this with short guided steps. It is free and takes about ten minutes. Start with [**cells, rows and columns**](https://practiceexcelonline.com/practice/the-grid/cells-rows-and-columns) even if you think you know it; the keyboard habits it builds pay off later.
## Module 2: first formulas (an afternoon)
Every formula starts with `**=**`. After that you can use cell references, numbers and the arithmetic operators `**+**`, `**-**`, `*****` and `**/**`.
- [**Add two cells**](https://practiceexcelonline.com/practice/first-formulas/add-two-cells): `**=B2+B3**`.
- [**Multiply quantity by price**](https://practiceexcelonline.com/practice/first-formulas/multiply-two-cells): `**=B2*C2**`.
- [**Click cells into a formula**](https://practiceexcelonline.com/practice/first-formulas/click-cells-into-a-formula) instead of typing the references, which avoids typos.
Two habits to build now. First, never type a number into a formula if it is already in a cell. Second, when you have written a formula, change one of its input cells and watch the result update. That moment, when you see the sheet recalculate, is when formulas start to make sense.
## Module 3: the basic functions (a few days)
Functions are named formulas that take arguments in parentheses. The first ones to learn all summarize a range:
B6=SUM(B2:B5)
| | A | B |
| --- | --- | --- |
| 1 | Month | Visitors |
| 2 | Jan | 420 |
| 3 | Feb | 515 |
| 4 | Mar | 610 |
| 5 | Apr | 580 |
| 6 | | **2125** |
SUM adds every number in the range. Typing the range once beats clicking each cell into a + chain.
- **SUM** adds up a range. Practice with [**adding up a column**](https://practiceexcelonline.com/practice/sum/sum-a-column), then [**a block of cells**](https://practiceexcelonline.com/practice/sum/sum-a-block-of-cells) and [**two separate ranges**](https://practiceexcelonline.com/practice/sum/sum-separate-ranges).
- **AVERAGE** gives the mean, and quietly ignores empty cells.
- **MIN** and **MAX** give the smallest and largest value.
- **COUNT** counts numbers, **COUNTA** counts anything that is not empty.
That second point about AVERAGE is worth seeing once:
D1=AVERAGE(B2:B6)
| | A | B | C | D |
| --- | --- | --- | --- | --- |
| 1 | Student | Score | | **78** |
| 2 | Ana | 72 | | |
| 3 | Ben | 85 | | |
| 4 | Cleo | | | |
| 5 | Dev | 64 | | |
| 6 | Eli | 91 | | |
AVERAGE skips the empty cell, so this is the average of four scores, not five.
An empty cell is skipped, but a cell with 0 in it counts as a score of 0. If a missing score should count as zero, type 0. If it should not count at all, leave it empty. The [**AVERAGE skips blank cells**](https://practiceexcelonline.com/practice/average/average-blank-cells) exercise makes the point with real numbers.
Add **ROUND** to this module too. `**=ROUND(B2*1.25,2)**` rounds a price to two decimals. Formatting a cell to show two decimals only changes what you see; ROUND changes the value. Practice it in [**rounding a price**](https://practiceexcelonline.com/practice/round/round-two-decimals).
**You are ready to move on when** you can total, average and count a column without looking anything up, and you type the range rather than clicking every cell.
## Module 4: copying formulas and the dollar sign (a day)
This module is short, but it is the one most self-taught users skip, and it causes more broken spreadsheets than anything else.
When you fill a formula down, Excel shifts every reference by one row. `**=B2*C2**` in row 2 becomes `**=B3*C3**` in row 3. That is almost always what you want. The exception is a reference to a single fixed cell, such as a tax rate or an exchange rate. Put a `**$**` before the column letter and the row number, `**$E$1**`, and the reference stays fixed however far you fill.
Learn the keyboard for it now: Ctrl+D to [**fill down**](https://practiceexcelonline.com/shortcuts/fill-down) and F4 to [**toggle the dollar signs**](https://practiceexcelonline.com/shortcuts/toggle-absolute) while editing. The [**fill down and right**](https://practiceexcelonline.com/practice/editing-and-filling/fill-down-and-right) lesson drills both.
## Module 5: logic with IF (a few days)
IF lets a formula decide. It takes a test, a value if the test is true and a value if it is false: `**=IF(B2>=50,"Pass","Fail")**`.
Start with [**pass or fail**](https://practiceexcelonline.com/practice/if/if-pass-fail), then return a calculation rather than text with [**calculating a bonus**](https://practiceexcelonline.com/practice/if/if-calculate-bonus). When you need more than two outcomes, put one IF inside another:
C2`=IF(1B2>=90,2"A",3IF(B2>=70,"B","C"))`
| | A | B | C |
| --- | --- | --- | --- |
| 1 | Student | Score | |
| 2 | Ana | 76 | **B** |
**In plain words:** 1If the score in B2 is 90 or more, 2give an A. 3Otherwise run a second IF: B from 70, C below that.
The first test that is true decides the answer: 76 is not 90 or more, but it is 70 or more, so B.
Nested IFs are read from the outside in, and the first true test wins. That is why the highest band goes first. The [**nested IF**](https://practiceexcelonline.com/practice/if/nested-if) exercise asks exactly this. Once that makes sense, learn AND and OR for combined tests, and IFS for long chains, which reads more easily than three levels of parentheses.
**You are ready to move on when** you can write an IF with a comparison, text in quotes and a calculation, and you know which operator "at least", "more than" and "up to" mean.
## Module 6: conditional counts and sums (a week)
This is where Excel starts to save real time. COUNTIF counts the cells that meet a condition; SUMIF adds up the values on the rows that do.
D1`=COUNTIF(1B2:B6,2"Leeds")`
| | A | B | C | D |
| --- | --- | --- | --- | --- |
| 1 | Customer | City | | **3** |
| 2 | Hale Ltd | Leeds | | |
| 3 | Brook & Co | York | | |
| 4 | Pine plc | Leeds | | |
| 5 | Moss Ltd | Hull | | |
| 6 | Ash Ltd | Leeds | | |
**In plain words:** Count the cells 1in B2:B6 that say 2Leeds.
COUNTIF counts the rows where the city is exactly Leeds.
- [**COUNTIF with a text condition**](https://practiceexcelonline.com/practice/countif/countif-text) and [**with a number condition**](https://practiceexcelonline.com/practice/countif/countif-greater-than).
- [**SUMIF with a text criterion**](https://practiceexcelonline.com/practice/sumif/sumif-text-criteria), then with [**the criterion in a cell**](https://practiceexcelonline.com/practice/sumif/sumif-criteria-from-a-cell).
- AVERAGEIF works the same way for averages.
- SUMIFS and COUNTIFS take several conditions at once: region is North *and* product is Shoes.
Spend a whole week here if you need to. Every report you will ever build at work is some version of "total this, for that group", and these functions are how you do it without a calculator. The [**summary tables**](https://practiceexcelonline.com/practice/summary-tables) topic then shows how one SUMIF, with the right dollar signs, fills a whole table, which is also what a pivot table does for you. Our [**pivot table guide**](https://practiceexcelonline.com/learn/pivot-tables) covers that link.
## Module 7: lookups (a week)
A lookup finds a value in one list and returns something from the same row: the price of a product, the department of an employee, the name for a customer number. It is the most requested skill in job ads after SUM.
Learn VLOOKUP first, because you will meet it in every older spreadsheet: `**=VLOOKUP(F2,A2:C5,3,FALSE)**` looks up F2 in the first column of A2:C5 and returns the third column. Always end it with FALSE for an exact match. Then learn XLOOKUP, which is simpler and more flexible if your Excel has it, and INDEX with MATCH, which works everywhere. Our [**lookup guide**](https://practiceexcelonline.com/learn/vlookup-vs-xlookup-vs-index-match) explains when to use which.
Practice with [**VLOOKUP for a price**](https://practiceexcelonline.com/practice/vlookup/vlookup-exact-match), then the [**XLOOKUP**](https://practiceexcelonline.com/practice/xlookup) and [**INDEX and MATCH**](https://practiceexcelonline.com/practice/index-match) topics, and finally [**IFERROR**](https://practiceexcelonline.com/practice/iferror) to show "Unknown" instead of `**#N/A**` when a value is not found.
## Module 8: text and dates (a week)
Real data is messy. Names have stray spaces, codes are in the wrong case, and dates arrive as text. Two families of functions clean it up.
**Text functions** fix and split text:
B1=TRIM(A1)
| | A | B |
| --- | --- | --- |
| 1 | Maya Jensen | **Maya Jensen** |
TRIM removes the spaces before and after the name and squeezes the double space in the middle to one.
- [**TRIM**](https://practiceexcelonline.com/practice/trim-proper-upper/trim-extra-spaces) removes extra spaces, which is the first thing to try when a lookup fails on a value you can see.
- PROPER, UPPER and LOWER fix capitals.
- LEFT, RIGHT and MID take characters from the start, end or middle; FIND and SEARCH tell you where a character is.
- `**&**` and TEXTJOIN join text together.
**Date functions** rely on one fact: Excel stores a date as a number of days. That is why you can [**subtract one date from another**](https://practiceexcelonline.com/practice/dates/days-between-dates) to get the days between them. From there, learn DATE, MONTH and YEAR, EDATE and EOMONTH for months, and NETWORKDAYS for working days.
## Module 9: speed (ongoing)
By now you know enough Excel for most jobs. What separates a confident user from an average one is speed, and most of that comes from the keyboard.
- **Ctrl+Arrow** [**jumps to the end of your data**](https://practiceexcelonline.com/practice/moving-and-selecting/jump-to-the-end-of-your-data), and **Ctrl+Shift+Arrow** selects to it.
- **F2** edits a cell, **Ctrl+D** and **Ctrl+R** fill, **F4** toggles `**$**`.
- **Ctrl+Z** undoes, **Alt+=** adds an AutoSum.
Five minutes of [**shortcut drills**](https://practiceexcelonline.com/shortcuts) a day for two weeks makes them automatic. The [**speed-run**](https://practiceexcelonline.com/shortcuts/speed-run) tells you whether it is working.
Speed also comes from layout. A sheet with one header row, one record per row, no blank rows in the middle and no merged cells is faster to work with, because Ctrl+Arrow, filters, sorting and every function in this guide behave the way you expect. When a sheet you inherit is slow to work in, it is often the layout rather than you. Tidying it into a plain table first is time well spent.
## How to practice so it sticks
The order matters, but the way you practice matters more. These are the habits that work, from what we see in thousands of graded answers.
**Type it yourself.** Watching a video of someone writing a VLOOKUP feels like learning. It is not, until you have written ten of them yourself and got three wrong. Every exercise on PracticeExcel makes you type the formula into a real grid for that reason.
**Get feedback straight away.** The worst way to learn a formula is to get it wrong, not notice, and repeat the mistake for a month. Practice somewhere that tells you immediately whether the answer is right and, when it is not, why.
**Keep sessions short and frequent.** Twenty minutes a day for three weeks beats a whole Saturday. Your memory needs the gaps between sessions to make things stick.
**Mix old and new.** Every session, redo one exercise from an earlier module before starting a new one. If it is slow, you have found what to review.
**Use your own data.** Once you know a function, use it on something you care about: your budget, a club's membership list, your running times. Real data has the quirks that exercises leave out.
**Test yourself under time pressure.** A timed test shows the difference between "I can do it" and "I can do it now". The [**Excel test for job interviews**](https://practiceexcelonline.com/tests/excel-test-for-job-interview) is a good check at the end of module 7.
## When you get stuck
Everyone gets stuck, usually at the same few places. Knowing them in advance makes them shorter.
**The formula shows as text.** If a cell shows `**=SUM(B2:B5)**` instead of a number, the cell was formatted as text before you typed, or there is a space before the `**=**`. Change the format to General, then press F2 and Enter to make Excel read it again.
**The answer is wrong, but there is no error.** This is the most dangerous kind of mistake, and the most common. Check the range first: does it cover every row? Then check the references after filling down: press F2 on a cell further down the column and look at what it points to. Excel colors each reference and draws a box around the cells it refers to, which makes a range that has slid out of place easy to spot.
**An error code you don't recognize.** Each one tells you something specific:
- `**#DIV/0!**` means a division by zero or by an empty cell.
- `**#N/A**` means a lookup did not find its value.
- `**#NAME?**` means Excel does not recognize a function name, usually a typo, or text without quotes.
- `**#VALUE!**` means the wrong kind of value, such as text in a calculation.
- `**#REF!**` means a reference to cells that no longer exist, usually after deleting rows or columns.
**You can't remember the arguments.** Type the function name and the opening parenthesis, and Excel shows the arguments in a tooltip under the cell. The bold one is the argument you are typing now. That tooltip is worth reading every time until the order is automatic.
**It worked yesterday and not today.** Usually someone has sorted one column without the others, typed a number over a formula, or deleted a row the formula used. Undo is your friend, and so is keeping a copy of the file before big changes.
## Learning Excel or Google Sheets
You do not have to choose. The grid, references, the `**$**` sign and the common functions work the same way in both, so almost everything in this guide applies to Google Sheets too. SUM, IF, SUMIF, VLOOKUP, XLOOKUP and INDEX MATCH have the same names and arguments.
The main differences are around the edges: menus are in different places, some shortcuts differ, Google Sheets has a few functions Excel does not (QUERY, IMPORTRANGE, GOOGLEFINANCE), and Excel has features Sheets lacks (Power Query, Power Pivot, most of VBA). Learn the one you will use day to day, and pick up the other when you need it. A week of using the other one is usually enough to feel at home.
## How long it really takes
People ask this more than anything else. Honest answers, assuming twenty to thirty minutes of practice most days:
| **Module** | **What you can do** | **Typical time** |
| --- | --- | --- |
| 1–3 | Enter data, write simple formulas, SUM, AVERAGE, COUNT | Two or three days |
| 4–5 | Copy formulas correctly, IF and nested IF | One more week |
| 6–7 | SUMIF, COUNTIF, SUMIFS, VLOOKUP, XLOOKUP | Two to three more weeks |
| 8–9 | Text and dates, keyboard speed | Another two to four weeks |
That puts most people at a solid intermediate level in about six weeks, which is what most office jobs and most Excel tests expect. If you already use Excel at work, you will move through the early modules much faster; do them anyway, quickly, to find the gaps.
## What to skip, for now
Excel has features you can safely ignore until you need them. Skipping them early keeps you focused on what pays off.
- **VBA and macros.** Useful for automating repeated work, but not needed for most roles.
- **Power Query and Power Pivot.** Excellent for large or messy data, but learn formulas first so you understand what they do for you.
- **Array formulas the old way** (Ctrl+Shift+Enter). Modern Excel handles arrays on its own.
- **Every function in the list.** Of more than 450 functions, most people use about 30. Our [**function pages**](https://practiceexcelonline.com/functions) cover the ones that matter.
## Summary
Learn Excel in layers: the grid, simple formulas, the basic functions, references and `**$**`, IF, conditional sums and counts, lookups, then text, dates and speed. Each layer builds on the one before, and each takes days or weeks, not months. Practice by typing formulas yourself, with instant feedback, in short daily sessions, and test yourself against a clock once you reach lookups.
The practice block below follows the same order as the course. Start at the top, and stop when the exercises feel easy, not when you have read about them. The first exercise in every topic is free, so try one now.
**About the author**
## **Nicolaj Gajhede**, founder of PracticeExcel
I'm a software developer, and I built PracticeExcel to help others get comfortable with Excel, and the best way to get there is to work through the formulas yourself.
[Nicolaj Gajhede on LinkedIn](https://www.linkedin.com/in/nicolaj-gajhede/) [More about Nicolaj Gajhede](https://practiceexcelonline.com/about#nicolaj-gajhede)
## **Practice what this guide covers**
Graded exercises in a real grid, in the order the guide uses them.
- [**Cells, rows and columns**The grid →](https://practiceexcelonline.com/practice/the-grid/cells-rows-and-columns)
- [**Add two cells**First formulas →](https://practiceexcelonline.com/practice/first-formulas/add-two-cells)
- [**Click cells into a formula**First formulas →](https://practiceexcelonline.com/practice/first-formulas/click-cells-into-a-formula)
- [**Add up a column with SUM**SUM →](https://practiceexcelonline.com/practice/sum/sum-a-column)
- [**AVERAGE skips blank cells**AVERAGE →](https://practiceexcelonline.com/practice/average/average-blank-cells)
- [**Find the fastest time with MIN**MIN, MAX and LARGE →](https://practiceexcelonline.com/practice/minmax/min-function)
- [**Round a price to two decimals**ROUND, ROUNDUP and ROUNDDOWN →](https://practiceexcelonline.com/practice/round/round-two-decimals)
- [**Pass or fail with IF**IF →](https://practiceexcelonline.com/practice/if/if-pass-fail)
- [**Three outcomes with nested IF**IF →](https://practiceexcelonline.com/practice/if/nested-if)
- [**COUNTIF with a text condition**COUNTIF →](https://practiceexcelonline.com/practice/countif/countif-text)
- [**SUMIF with a text criterion**SUMIF →](https://practiceexcelonline.com/practice/sumif/sumif-text-criteria)
- [**Look up a price with VLOOKUP**VLOOKUP →](https://practiceexcelonline.com/practice/vlookup/vlookup-exact-match)
- [**Remove extra spaces with TRIM**TRIM, PROPER and UPPER →](https://practiceexcelonline.com/practice/trim-proper-upper/trim-extra-spaces)
- [**Days between two dates**Dates and DATE →](https://practiceexcelonline.com/practice/dates/days-between-dates)
- [**Jump to the end of your data**Moving and selecting →](https://practiceexcelonline.com/practice/moving-and-selecting/jump-to-the-end-of-your-data)
- [**Fill a formula down and right**Editing and filling →](https://practiceexcelonline.com/practice/editing-and-filling/fill-down-and-right)
### **Function pages**
- [**SUM**](https://practiceexcelonline.com/functions/sum)
- [**AVERAGE**](https://practiceexcelonline.com/functions/average)
- [**COUNT**](https://practiceexcelonline.com/functions/count)
- [**IF**](https://practiceexcelonline.com/functions/if)
- [**COUNTIF**](https://practiceexcelonline.com/functions/countif)
- [**SUMIF**](https://practiceexcelonline.com/functions/sumif)
- [**VLOOKUP**](https://practiceexcelonline.com/functions/vlookup)
- [**TRIM**](https://practiceexcelonline.com/functions/trim)
### **Timed tests**
- [Excel test for job interviews](https://practiceexcelonline.com/tests/excel-test-for-job-interview) · 20 questions in 30 minutes
## **Questions**
### How long does it take to learn Excel?
The basics, meaning entering data, SUM, AVERAGE and simple formulas, take a few hours. Intermediate skills such as IF, SUMIF and VLOOKUP take two to four weeks of regular practice. Being quick and confident with lookups, summary tables and dates takes a few months of using Excel at work or practicing most days.
### Is this Excel course free?
The course and a large part of the exercises are free, with no account needed. Getting started, the whole SUM, AVERAGE and COUNT topics, the shortcut drills and the first exercise in every other topic are free. Premium unlocks the rest of the exercises and certificates.
### Is the course for beginners?
Yes. Module 1 starts with cells, rows and columns, and you don't need to know anything beforehand. If you already know the basics, move through the first modules quickly and spend the time on IF, SUMIF and lookups.
### Do I get a certificate when I finish?
With premium, you get a certificate for every topic you complete, with your name and a link anyone can check. You can add it to your résumé or your LinkedIn profile.
### Can I learn Excel for free?
Yes. Microsoft's own help pages, free video channels and free practice sites cover everything up to an intermediate level. What most of them lack is exercises where you type the formula yourself and get it graded, and that's what this course is built on.
### Should I learn Excel or Google Sheets first?
Either. The grid, references and the common functions work the same way in both, so what you learn in one carries over. Learn the one you will use at work or in your course, and pick up the differences later.
### Do I need to learn VBA or macros?
Not for most jobs. Formulas, tables, pivot tables and a few shortcuts cover what most office and finance roles need. VBA is worth learning once you find yourself repeating the same steps every week.
### What is the best way to practice?
Short, frequent sessions where you type the formulas yourself and get told straight away whether the answer is right. Twenty minutes a day beats three hours once a week, and doing beats watching.
## **More guides**
- [**Excel for job interviews: what gets tested and how to prepare**What employer Excel tests ask, the formulas that come up again and again, how the timer changes your approach, and a two-week plan to get ready.](https://practiceexcelonline.com/learn/excel-for-job-interviews)
- [**VLOOKUP vs XLOOKUP vs INDEX MATCH: which lookup to use**How VLOOKUP, XLOOKUP and INDEX with MATCH work, where each one breaks, and which to use in a test, an old workbook or a sheet you are building today.](https://practiceexcelonline.com/learn/vlookup-vs-xlookup-vs-index-match)
- [**Excel for finance and accounting: the skills you actually use**The Excel skills finance and accounting teams use every day, from SUMIFS on a ledger and budget variances to rounding, month-end dates, PMT, NPV and check totals.](https://practiceexcelonline.com/learn/excel-for-finance)
```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#webpage","dateModified":"2026-11-02","datePublished":"2026-10-29","description":"An Excel course for beginners in nine modules, from cells and SUM to lookups and summary tables. You practice in the browser, and the first part is free with no account.","name":"Free Excel course online: from zero to job-ready","url":"https://practiceexcelonline.com/learn/how-to-learn-excel","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/1"},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/2"},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/3"},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/4"},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/5"},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/6"},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/7"},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/8"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/learn/how-to-learn-excel"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel guides","item":"https://practiceexcelonline.com/learn","position":2},{"@type":"ListItem","name":"Free Excel course online: from zero to job-ready","position":3}]},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#article","@type":"Article","dateModified":"2026-11-02","datePublished":"2026-10-29","description":"An Excel course for beginners in nine modules, from cells and SUM to lookups and summary tables. You practice in the browser, and the first part is free with no account.","headline":"Free Excel course online: from zero to job-ready","inLanguage":"en-US","thumbnailUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RnJlZSBFeGNlbCBjb3Vyc2Ugb25saW5lOiBmcm9tIHplcm8gdG8gam9iLXJlYWR5%2Cdescription_~QW4gRXhjZWwgY291cnNlIGZvciBiZWdpbm5lcnMgaW4gbmluZSBtb2R1bGVzLCBmcm9tIGNlbGxzIGFuZCBTVU0gdG8gbG9va3VwcyBhbmQgc3VtbWFyeSB0YWJsZXMuIFlvdSBwcmFjdGljZSBpbiB0aGUgYnJvd3NlciwgYW5kIHRoZSBmaXJzdCBwYXJ0IGlzIGZyZWUgd2l0aCBubyBhY2NvdW50Lg%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9ob3ctdG8tbGVhcm4tZXhjZWwi%2Cs_2GhckB7Yguq-_1ts.png","author":{"@id":"https://practiceexcelonline.com/#/schema/person/1"},"image":{"@id":"https://practiceexcelonline.com/#/schema/image/1"},"isPartOf":{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#webpage"},"mainEntityOfPage":{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#webpage"},"publisher":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How long does it take to learn Excel?","acceptedAnswer":{"@type":"Answer","text":"The basics, meaning entering data, SUM, AVERAGE and simple formulas, take a few hours. Intermediate skills such as IF, SUMIF and VLOOKUP take two to four weeks of regular practice. Being quick and confident with lookups, summary tables and dates takes a few months of using Excel at work or practicing most days."}},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Is this Excel course free?","acceptedAnswer":{"@type":"Answer","text":"The course and a large part of the exercises are free, with no account needed. Getting started, the whole SUM, AVERAGE and COUNT topics, the shortcut drills and the first exercise in every other topic are free. Premium unlocks the rest of the exercises and certificates."}},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Is the course for beginners?","acceptedAnswer":{"@type":"Answer","text":"Yes. Module 1 starts with cells, rows and columns, and you don't need to know anything beforehand. If you already know the basics, move through the first modules quickly and spend the time on IF, SUMIF and lookups."}},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"Do I get a certificate when I finish?","acceptedAnswer":{"@type":"Answer","text":"With premium, you get a certificate for every topic you complete, with your name and a link anyone can check. You can add it to your résumé or your LinkedIn profile."}},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"Can I learn Excel for free?","acceptedAnswer":{"@type":"Answer","text":"Yes. Microsoft's own help pages, free video channels and free practice sites cover everything up to an intermediate level. What most of them lack is exercises where you type the formula yourself and get it graded, and that's what this course is built on."}},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/6","@type":"Question","inLanguage":"en-US","name":"Should I learn Excel or Google Sheets first?","acceptedAnswer":{"@type":"Answer","text":"Either. The grid, references and the common functions work the same way in both, so what you learn in one carries over. Learn the one you will use at work or in your course, and pick up the differences later."}},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/7","@type":"Question","inLanguage":"en-US","name":"Do I need to learn VBA or macros?","acceptedAnswer":{"@type":"Answer","text":"Not for most jobs. Formulas, tables, pivot tables and a few shortcuts cover what most office and finance roles need. VBA is worth learning once you find yourself repeating the same steps every week."}},{"@id":"https://practiceexcelonline.com/learn/how-to-learn-excel#/schema/question/8","@type":"Question","inLanguage":"en-US","name":"What is the best way to practice?","acceptedAnswer":{"@type":"Answer","text":"Short, frequent sessions where you type the formulas yourself and get told straight away whether the answer is right. Twenty minutes a day beats three hours once a week, and doing beats watching."}},{"@id":"https://practiceexcelonline.com/#/schema/person/1","@type":"Person","description":"I'm a software developer, and I built PracticeExcel to help others get comfortable with Excel, and the best way to get there is to work through the formulas yourself.","jobTitle":"founder of PracticeExcel","name":"Nicolaj Gajhede","url":"https://practiceexcelonline.com/about#nicolaj-gajhede","image":{"@id":"https://practiceexcelonline.com/#/schema/image/2"},"sameAs":["https://www.linkedin.com/in/nicolaj-gajhede/"]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RnJlZSBFeGNlbCBjb3Vyc2Ugb25saW5lOiBmcm9tIHplcm8gdG8gam9iLXJlYWR5%2Cdescription_~QW4gRXhjZWwgY291cnNlIGZvciBiZWdpbm5lcnMgaW4gbmluZSBtb2R1bGVzLCBmcm9tIGNlbGxzIGFuZCBTVU0gdG8gbG9va3VwcyBhbmQgc3VtbWFyeSB0YWJsZXMuIFlvdSBwcmFjdGljZSBpbiB0aGUgYnJvd3NlciwgYW5kIHRoZSBmaXJzdCBwYXJ0IGlzIGZyZWUgd2l0aCBubyBhY2NvdW50Lg%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9ob3ctdG8tbGVhcm4tZXhjZWwi%2Cs_2GhckB7Yguq-_1ts.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RnJlZSBFeGNlbCBjb3Vyc2Ugb25saW5lOiBmcm9tIHplcm8gdG8gam9iLXJlYWR5%2Cdescription_~QW4gRXhjZWwgY291cnNlIGZvciBiZWdpbm5lcnMgaW4gbmluZSBtb2R1bGVzLCBmcm9tIGNlbGxzIGFuZCBTVU0gdG8gbG9va3VwcyBhbmQgc3VtbWFyeSB0YWJsZXMuIFlvdSBwcmFjdGljZSBpbiB0aGUgYnJvd3NlciwgYW5kIHRoZSBmaXJzdCBwYXJ0IGlzIGZyZWUgd2l0aCBubyBhY2NvdW50Lg%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9ob3ctdG8tbGVhcm4tZXhjZWwi%2Cs_2GhckB7Yguq-_1ts.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/2","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/authors/nicolaj-gajhede.webp","inLanguage":"en-US","url":"https://practiceexcelonline.com/authors/nicolaj-gajhede.webp"}]}
```
## Sitemap
See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.