Learn Excel by actually using it.
A short explanation, a real task, instant feedback. Right in your browser, no installation and no hours of video.
Task In C8, calculate the revenue of all orders from Berlin.
| A | B | C | |
|---|---|---|---|
| 1 | City | Orders | Revenue $ |
| 2 | Berlin | 3 | 1200 |
| 3 | Hamburg | 5 | 1800 |
| 4 | Berlin | 2 | 900 |
| 5 | Munich | 4 | 1500 |
| 6 | Berlin | 1 | 450 |
| 7 | |||
| 8 | Berlin | Total revenue: |
How LearnThisNext works
- Understand it quickly. Every function gets a short explanation with an example from real office work. No theory you will never use.
- Type it yourself. You write the formula into a sheet that feels like Excel. Click a cell to insert its reference, drag to select a range.
- Get instant feedback. The exercise checks your result and tells you exactly what is missing. One hint at a time, the solution only when you ask for it.
- Repeat until it sticks. Every correct answer earns points. What you get wrong more often comes back more often.
What you can practice
We start with the functions that are used most at work and asked most in Excel assessment tests. Every page has an explanation and exercises you can solve right away.
The learning path also covers percentages, rounding, COUNTIFS, rankings, VLOOKUP with tiers and with multiple criteria, INDEX and MATCH, error values, text and date functions, FILTER and PivotTables. For every topic, "More exercises on this topic" creates as many new tasks as you like. The task at the top of this page is already a SUMIF exercise.
Why practice beats watching
A video about VLOOKUP feels clear while it plays. The next day, in front of an empty sheet, much of it is gone. Watching only lets your brain recognize the solution. It never has to produce it.
Active practice is different. You have to remember how the formula is built, which column you need and where the comma goes. That act of recalling is what makes knowledge last. That is why every page here is built around a task, not around a long text.
Your Excel language, your Excel version
Many people work with a German, French or Spanish Excel at one company and an English one at the next. Our exercises accept English and German function names, so =SUMIF(A2:A6,"Berlin",C2:C6) and =SUMMEWENN(A2:A6;"Berlin";C2:C6) both count as correct.
Versions matter too. XLOOKUP, for example, only exists in Microsoft 365 and Excel 2021 or newer. Every topic page tells you which versions have a function and what to use in older ones.
Excel for work and job interviews
Many employers test Excel skills before hiring, often with a short practical task or an online assessment. Typical topics are SUM and AVERAGE, IF, VLOOKUP or XLOOKUP, SUMIF and sorting and filtering lists. Solving these tasks a few times yourself makes a real difference when the test starts.
Frequently asked questions
Is LearnThisNext free?
You can solve the exercises on the topic pages for free and without signing up. A subscription for the full learning path, tests and certificates will follow. Free content stays free.
Do I need Excel installed?
No. Everything runs in your browser.
Does it work on my phone?
Yes. On touch devices you get an extra key row with the equals sign, brackets, comma and colon. Longer tasks are more comfortable with a keyboard.
Is my progress saved?
Without an account, your browser remembers which exercises you have solved. With a free account your progress is available on every device, and you see your points, streak and weak spots.
Get started
The quickest way in is the task at the top of this page. After that, continue with XLOOKUP.