LearnThisNext

Excel practice and exercises

All Excel topics in a sensible order, each with a short explanation and exercises you solve right in your browser.

The learning path

Each level builds on the one before. You can also open any lesson directly if you already know a topic or want to practice something specific. Check marks show what you have solved.

  1. Level 1: Getting started

    1. Basic math: add, subtract, multiply, divide 3 exercises
    2. SUM 2 exercises
    3. Relative and absolute references 2 exercises
    4. Percentages 3 exercises
    5. ROUND 3 exercises
    6. AVERAGE, MIN, MAX 2 exercises
    7. COUNT and COUNTA 3 exercises
    8. Creating and totaling tables 3 exercises

  2. Level 2: Everyday office work

    1. IF function 2 exercises
    2. AND and OR 3 exercises
    3. IFS and nested IF 3 exercises
    4. COUNTIF 2 exercises
    5. COUNTIFS 3 exercises
    6. SUMIF 2 exercises
    7. SUMIFS 2 exercises
    8. AVERAGEIF(S) 3 exercises
    9. MAXIFS and MINIFS 3 exercises
    10. LARGE, SMALL, RANK 3 exercises
    11. Sort and filter 2 exercises
    12. Conditional formatting 2 exercises
    13. Drop-down lists and data validation 3 exercises

  3. Level 3: Looking up and connecting data

    1. VLOOKUP 2 exercises
    2. VLOOKUP approximate match 3 exercises
    3. XLOOKUP 2 exercises
    4. VLOOKUP with multiple criteria 3 exercises
    5. XLOOKUP with multiple criteria 3 exercises
    6. INDEX and MATCH 2 exercises
    7. IFERROR 2 exercises
    8. Excel error values 3 exercises

  4. Level 4: Working with data

    1. Text functions 2 exercises
    2. MID, FIND, SEARCH 3 exercises
    3. SUBSTITUTE, TRIM, PROPER 3 exercises
    4. Combining text 3 exercises
    5. Date functions 3 exercises
    6. DATEDIF, workdays, week numbers 3 exercises
    7. Time and working hours 3 exercises
    8. FILTER, SORT, UNIQUE 2 exercises
    9. Finding and removing duplicates 3 exercises
    10. Creating charts 3 exercises
    11. PivotTables 2 exercises

  5. Level 5: Real work and final test

    1. Interest, growth rate, loan payments 3 exercises
    2. Case study: finance 3 exercises
    3. Case study: sales 3 exercises
    4. Case study: HR 3 exercises
    5. Final testcertificate after levels 1 to 4

  6. Bonus: Keyboard shortcuts

    Bonus, not needed for the certificate
    1. Shortcuts: navigating and selecting 3 exercises
    2. Shortcuts: editing and formulas 3 exercises

Start with lesson 1 About the Excel course

How the topic pages work

Every page explains the function briefly, shows its structure in English and German, lists common mistakes and has exercises with real office data. “More exercises on this topic” gives you as many new tasks with fresh data as you like.

English and German function names

All exercises accept both languages. All names side by side are in the Excel function translator.

Frequently asked questions

Where should I start?

New to Excel? Start with basic math, then SUM. If you know simple formulas, XLOOKUP is a great next step.

How long does it take to learn Excel?

The basics for office work take a few weeks of regular practice. Short daily sessions of ten to fifteen minutes work better than long ones.

Write to us