Zum Inhalt springen
GridBelt
  • Excel-Test
  • Übungen
  • Programme
  • Preise
Anmelden
Kostenlosen Test starten
  • Excel-Test
  • Übungen
  • Programme
  • Preise
AnmeldenKonto erstellen
Kostenlosen Test starten
GridBelt

Excel üben – direkt im Browser.

Excel-Test

  • Stufe 1: Anfänger
  • Stufe 2: Fortgeschrittene
  • Stufe 3: Experten
  • Excel-Test in 7 Tagen
  • Bestenliste
  • Excel-Test im Bewerbungsverfahren
  • Excel-Test von Indeed

Übungen

  • Alle Übungen
  • Programme
  • Für Anfänger

Ratgeber

  • Excel-Formeln
  • Excel-Tastenkombinationen

Unternehmen

  • Über uns
  • Preise
  • So bewerten wir

© GridBelt. Alle Rechte vorbehalten.

  • Datenschutzerklärung
  • Nutzungsbedingungen
  • Rückerstattungsrichtlinie

Excel ist eine Marke der Microsoft Corporation. Indeed, TestGorilla, SHL und andere Marken sind Eigentum ihrer jeweiligen Inhaber. GridBelt ist eine unabhängige Übungsplattform, steht mit Microsoft, TestGorilla, SHL oder Indeed in keiner Verbindung und wird von keinem dieser Unternehmen unterstützt oder gesponsert.

  1. Übungen
  2. Programme

Programm · 14 Tage · kostenlos

Learn Excel From Scratch: a 14-Day Practice Program

39 graded exercises over 13 practice days, about 17 minutes a day, then the free 12-minute Level 1 test. The days build on each other: totals, references, counts and IF rules first, then lookups, cleanup and a tracker with a drop-down list. Free, no sign-up, nothing to install.

  • 14 Tage
  • 39 bewertete Übungen
  • 15–21 Min. pro Tag
  • Abschlusstest: Stufe 1, 12 Min.
  • 1 Übung nutzt eine Funktion, die Excel 2019 und älteren Versionen fehlt
  • Kostenlos, ohne Anmeldung
Tag 1 starten

Kostenlos, ohne Anmeldung. Ihr Fortschritt bleibt in diesem Browser.

Programminhalte auf Englisch

  1. 1 Tag 1: First formulas: SUM, a filtered list, text pieces
  2. 2 Tag 2: AVERAGE, MIN and MAX, sheets, a chart read right
  3. 3 Tag 3: Copy formulas: the fill handle, a $ rate, dates
  4. 4 Tag 4: Counts, full names and a price grid
  5. 5 Tag 5: Decide with IF, AND and OR
  6. 6 Tag 6: Count, total and share by condition
  7. 7 Tag 7: Look up prices and tiers, find the top 3
  8. 8 Tag 8: Sort, title a report, read a PivotTable
  9. 9 Tag 9: Formats, a frozen header, the right chart
  10. 10 Tag 10: Blanks, errors and messy names
  11. 11 Tag 11: COUNTIFS and SUMIFS grids, a chart flipped
  12. 12 Tag 12: Lookups beyond VLOOKUP: XLOOKUP, Not found, INDEX
  13. P Tag 13: Projekttag
  14. T Tag 14: Testtag

T: Testtag · P: Projekttag

Ziellinie

Test der Stufe 1 · 15 Aufgaben · etwa 12 Min. · eine Einstufung von „Mehr Übung nötig“ bis „Expertenniveau“

Jeder Versuch zieht seine Aufgaben zufällig, mit neuen Zahlen, daher können einzelne Aufgaben wiederkommen; bei den Stufen 2 und 3 werden auch die Arbeitsmappen und Projekte zufällig gezogen.

No program can promise a pass: employers set their own pass marks and rarely publish them. Our bands and pass lines are our own cutoffs.

Ist das etwas für Sie?

Für wen es gedacht ist

  • Complete beginners, career changers and students
  • People coming back to Excel after years away
  • Anyone who wants a steady route from the first SUM to a confident Level 1 result

Das können Sie danach

  • Total and summarize: SUM, AVERAGE, MIN, MAX, COUNT, LARGE and SMALL, the fill handle and totals across sheets
  • Copy formulas safely with relative, $-locked and mixed references, and work out shares and dates
  • Decide and summarize with IF, AND, OR, COUNTIF and SUMIF, and look values up with VLOOKUP and XLOOKUP
  • Make a sheet readable: number formats, a two-level sort, a filter, a merged title and a frozen header
  • Read a PivotTable and a chart, and pick the right chart for a question

Noch nicht abgedeckt

  • A tour of the Excel desktop interface: the ribbon, saving and printing
  • Building PivotTables and charts by hand: you read pictured ones instead
  • Keyboard-shortcut drills: see the Excel shortcuts cheat sheet

Tag für Tag

14 Tage, 39 bewertete Übungen. Die Minutenangaben sind Schätzungen für einen Versuch; nichts wird gesperrt, Sie bestimmen also selbst das Tempo.

✓ erledigt · ◐ begonnen · ○ offen

Tage 1–5

  1. Tag 1

    First formulas: SUM, a filtered list, text pieces

    15 Min.

    Your first total with SUM, a filtered list counted with SUBTOTAL, and a product code cut into parts.

    • Total revenue with SUM

      Anfänger · 3 Min.

    • Filter one region and count visible rows with SUBTOTAL

      Anfänger · 6 Min.

    • Extract category, year and serial from SKU

      Anfänger · 6 Min.

  2. Tag 2

    AVERAGE, MIN and MAX, sheets, a chart read right

    15 Min.

    Averages and extremes, a total across three sheets, and reading a column chart correctly.

    • AVERAGE, MIN and MAX of exam scores

      Anfänger · 4 Min.

    • Total across three regional sheets

      Anfänger · 5 Min.

    • Read a clustered column chart of revenue by region

      Anfänger · 6 Min.

  3. Tag 3

    Copy formulas: the fill handle, a $ rate, dates

    15 Min.

    Fill a formula down, lock one rate with $ so it copies correctly, and count the days to a deadline.

    • Row totals with the fill handle

      Anfänger · 4 Min.

    • Apply one tax rate to every line ($ reference)

      Anfänger · 5 Min.

    • Days to deadline and tenure in years (TODAY, DATEDIF)

      Anfänger · 6 Min.

  4. Tag 4

    Counts, full names and a price grid

    15 Min.

    Count numbers, names and blanks, join first and last names, and fill a price grid with mixed references.

    • Count orders, names and blanks (COUNT, COUNTA, COUNTBLANK)

      Anfänger · 4 Min.

    • Full name with CONCAT or &

      Anfänger · 4 Min.

    • Price grid for quantities × discounts (mixed references)

      Anfänger · 7 Min.

  5. Tag 5

    Decide with IF, AND and OR

    15 Min.

    Pass or fail with IF, a bonus that needs two conditions, and free shipping that needs one of two.

    • Pass or Fail with IF

      Anfänger · 4 Min.

    • Bonus eligibility with IF and AND

      Anfänger · 5 Min.

    • Free-shipping flag with IF and OR

      Anfänger · 6 Min.

Tage 6–10

  1. Tag 6

    Count, total and share by condition

    15 Min.

    Orders per status with COUNTIF, sales by region with SUMIF, and each region's share of the total.

    • Orders per status with COUNTIF

      Anfänger · 5 Min.

    • Sales by region with SUMIF

      Anfänger · 5 Min.

    • Share of total per region, formatted as %

      Anfänger · 5 Min.

  2. Tag 7

    Look up prices and tiers, find the top 3

    15 Min.

    VLOOKUP on the same sheet and on another one, then the top and bottom three with LARGE and SMALL.

    • Pull the unit price with VLOOKUP (exact match)

      Anfänger · 5 Min.

    • Look up a customer tier from another sheet

      Anfänger · 5 Min.

    • Top 3 and bottom 3 reps with LARGE and SMALL

      Anfänger · 5 Min.

  3. Tag 8

    Sort, title a report, read a PivotTable

    16 Min.

    A two-level sort, a merged and centered title, and a PivotTable report read correctly.

    • Sort by Region, then Sales descending

      Anfänger · 4 Min.

    • Merge and center the title; wrap header text

      Anfänger · 4 Min.

    • Read a PivotTable report and check one of its cells

      Anfänger · 8 Min.

  4. Tag 9

    Formats, a frozen header, the right chart

    16 Min.

    Currency and date formats, a header row that stays in view, and the chart that fits each question.

    • Apply currency and date formats

      Anfänger · 4 Min.

    • Freeze the header row of a long export

      Anfänger · 3 Min.

    • Pick the right chart for each question

      Anfänger · 9 Min.

  5. Tag 10

    Blanks, errors and messy names

    17 Min.

    Your first intermediate steps: flag missing data, avoid #DIV/0! with IFERROR, and clean padded names.

    • Flag rows with missing data

      Fortgeschrittene · 5 Min.

    • Margin % without #DIV/0!

      Fortgeschrittene · 6 Min.

    • Clean padded, lower-case names with TRIM and PROPER

      Fortgeschrittene · 6 Min.

Tage 11–14

  1. Tag 11

    COUNTIFS and SUMIFS grids, a chart flipped

    21 Min.

    Counts and totals by two conditions, and the same chart read with rows and columns switched.

    • Orders per region and month with COUNTIFS

      Fortgeschrittene · 7 Min.

    • Sales by region and product with SUMIFS

      Fortgeschrittene · 7 Min.

    • Series or categories? Read a chart both ways and flip its table

      Fortgeschrittene · 7 Min.

  2. Tag 12

    Lookups beyond VLOOKUP: XLOOKUP, Not found, INDEX

    19 Min.

    XLOOKUP for an exact match, Not found instead of #N/A, and INDEX with MATCH.

    • Replace VLOOKUP with XLOOKUP

      Fortgeschrittene · 6 Min.Excel 365

    • Show "Not found" instead of #N/A

      Fortgeschrittene · 7 Min.

    • INDEX and MATCH exact lookup

      Fortgeschrittene · 6 Min.

  3. Tag 13

    Project day: a tracker that stays right

    Projekttag · 21 Min.

    Invoice due dates, an overdue highlight and a drop-down list of approved regions: a small tracker that keeps itself correct.

    • Invoice due dates with EOMONTH and EDATE

      Fortgeschrittene · 6 Min.

    • Highlight overdue invoices (conditional formatting)

      Fortgeschrittene · 8 Min.

    • Drop-down list of regions (data validation)

      Fortgeschrittene · 7 Min.

  4. Tag 14

    Final test: Level 1

    Abschlusstest · 12 Min.

    The free Level 1 test: 15 tasks with a 90-second limit each. Aim for the Highly proficient band (80% or more); Proficient (65% or more) is a good first milestone.

    • Abschlusstest: Stufe 1 · 15 Aufgaben · 12 Min.

      →
    • How we grade the test

      Zum Lesen, optional · 5 Min.

Fragen zu diesem Plan

How long does Learn Excel From Scratch take?

14 days: 13 practice days of 15 to 21 minutes, then the 12-minute Level 1 test. Nothing locks, so go at your own pace; at five days a week it takes about three weeks.

Do I need Excel installed to learn from scratch?

No. Every exercise runs in a spreadsheet grid in your browser and is checked automatically. One exercise uses XLOOKUP, which needs Excel 2021 or later, or Microsoft 365, at work.

What comes after Learn Excel From Scratch?

The 7-day Level 2 plan, or a job program that ends with the Level 2 test: Excel for Sales and Marketing or Excel for Accounting and Bookkeeping.

How do I know learning from scratch worked?

The finish line is the free Level 1 test: 15 tasks with a 90-second limit each. Aim for the Highly proficient band (80% or more); Proficient (65% or more) is a good first milestone.

Weitere Programme

  • Prepare for your Excel test in 7 days

    Day 1: the free timed test at your level. Days 2–6: three graded exercises a day. Day 7: retake it and compare.

  • Excel for Administrative Assistants

    For office and admin work: tidy exports, counts, IF rules, lookups, due dates and a tracker that rejects bad input.

  • Excel for Sales and Marketing

    For sales and marketing ops: totals by region and rep, commission tiers, lookups, clean customer lists and live reports.

Excel ist eine Marke der Microsoft-Unternehmensgruppe. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria und andere Marken sind Eigentum ihrer jeweiligen Inhaber. GridBelt ist unabhängig, steht mit keinem dieser Unternehmen in Verbindung und wird von keinem von ihnen unterstützt oder gesponsert.