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 · 11 Tage · kostenlos

Excel for Administrative Assistants: an 11-Day Practice Program

30 graded exercises over 10 practice days, about 17 minutes a day, then the free 12-minute Level 1 test as the finish line. You make exports readable, count and total lists, write IF rules, look values up, tidy names and dates, and build a tracker that rejects bad input. Free, no sign-up.

  • 11 Tage
  • 30 bewertete Übungen
  • 15–22 Min. pro Tag
  • Abschlusstest: Stufe 1, 12 Min.
  • Kostenlos, ohne Anmeldung
Tag 1 starten

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

Programminhalte auf Englisch

  1. 1 Tag 1: First formulas: averages, a locked rate, days to a date
  2. 2 Tag 2: Count what is in a list: COUNTIF and SUBTOTAL
  3. 3 Tag 3: Rules in a cell: IF, AND and OR
  4. 4 Tag 4: Totals: by region, across sheets, as shares
  5. 5 Tag 5: Readable sheets: formats, a frozen header, a chart
  6. 6 Tag 6: Names and codes: full names, a tier, SKU parts
  7. 7 Tag 7: Reports: a two-level sort, a title, a PivotTable
  8. 8 Tag 8: Clean lists: missing IDs, messy names, Not found
  9. 9 Tag 9: Deadlines and contacts: due dates, working days
  10. P Tag 10: Projekttag
  11. T Tag 11: 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

  • Office and admin assistants, executive assistants, receptionists and coordinators
  • Job seekers whose application includes a basic Excel screening test
  • You can type data and write a simple SUM; nothing else is assumed

Das können Sie danach

  • Make an export readable: currency and date formats, a merged title, wrapped headers, a frozen header and a two-level sort
  • Count and total any list with COUNTIF, SUMIF, AVERAGE and a SUBTOTAL that follows the filter
  • Write IF rules with AND and OR, lock a rate with $ and pull values from another sheet with VLOOKUP
  • Tidy names, codes and dates: TRIM and PROPER, LEFT/MID/RIGHT, email domains, due dates and working days
  • Set up a tracker that rejects bad input: a drop-down list, a whole-number rule and an overdue highlight

Noch nicht abgedeckt

  • Mail merge, Word and Outlook
  • Printing, page setup and sheet protection
  • Building PivotTables and charts by hand: the grid asks about pictured reports instead
  • Excel tables (Ctrl+T), macros and Power Query

Tag für Tag

11 Tage, 30 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: averages, a locked rate, days to a date

    15 Min.

    AVERAGE, MIN and MAX, one tax rate locked with $ for every line, and the days left to a deadline.

    • AVERAGE, MIN and MAX of exam scores

      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.

    • Excel shortcuts cheat sheet

      Zum Lesen, optional · 5 Min.

  2. Tag 2

    Count what is in a list: COUNTIF and SUBTOTAL

    15 Min.

    Count numbers, names and blanks, count orders per status, and count only the rows a filter shows.

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

      Anfänger · 4 Min.

    • Orders per status with COUNTIF

      Anfänger · 5 Min.

    • Filter one region and count visible rows with SUBTOTAL

      Anfänger · 6 Min.

  3. Tag 3

    Rules in a cell: IF, AND and OR

    15 Min.

    Pass or fail with IF, a bonus that needs two conditions, and a free-shipping flag 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.

  4. Tag 4

    Totals: by region, across sheets, as shares

    15 Min.

    Sales by region with SUMIF, a total across three sheets, and each region's share of the total as a percentage.

    • Sales by region with SUMIF

      Anfänger · 5 Min.

    • Total across three regional sheets

      Anfänger · 5 Min.

    • Share of total per region, formatted as %

      Anfänger · 5 Min.

  5. Tag 5

    Readable sheets: formats, a frozen header, a 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.

Tage 6–11

  1. Tag 6

    Names and codes: full names, a tier, SKU parts

    15 Min.

    Join first and last names, look up a customer tier on another sheet, and cut a product code into its parts.

    • Full name with CONCAT or &

      Anfänger · 4 Min.

    • Look up a customer tier from another sheet

      Anfänger · 5 Min.

    • Extract category, year and serial from SKU

      Anfänger · 6 Min.

  2. Tag 7

    Reports: a two-level sort, a title, a PivotTable

    16 Min.

    Sort by region and then by sales, merge a report title, and read a PivotTable report 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.

  3. Tag 8

    Clean lists: missing IDs, messy names, Not found

    18 Min.

    Flag rows with missing data, clean padded names, and show Not found instead of #N/A.

    • Flag rows with missing data

      Fortgeschrittene · 5 Min.

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

      Fortgeschrittene · 6 Min.

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

      Fortgeschrittene · 7 Min.

  4. Tag 9

    Deadlines and contacts: due dates, working days

    20 Min.

    Invoice due dates at month end, working days to close a ticket, and the domain of each email address.

    • Invoice due dates with EOMONTH and EDATE

      Fortgeschrittene · 6 Min.

    • Working days to resolve tickets (NETWORKDAYS)

      Fortgeschrittene · 7 Min.

    • Split email into user and domain (FIND/LEFT/RIGHT or TEXTBEFORE/TEXTAFTER)

      Fortgeschrittene · 7 Min.

  5. Tag 10

    Project day: a shared tracker nobody can break

    Projekttag · 22 Min.

    A drop-down list of approved regions, a rule that accepts whole quantities only, and an overdue highlight: a tracker colleagues can fill in safely.

    • Drop-down list of regions (data validation)

      Fortgeschrittene · 7 Min.

    • Restrict quantity to whole numbers 1–100

      Fortgeschrittene · 7 Min.

    • Highlight overdue invoices (conditional formatting)

      Fortgeschrittene · 8 Min.

  6. Tag 11

    Final test: Level 1

    Abschlusstest · 12 Min.

    The free Level 1 test: 15 tasks with a 90-second limit each, about 12 minutes. Aim for the Highly proficient band, 80% or more.

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

      →
    • How we grade the test

      Zum Lesen, optional · 5 Min.

Fragen zu diesem Plan

How long does Excel for Admin Assistants take?

11 days: 10 practice days of 15 to 22 minutes, then the 12-minute Level 1 test. Go at your own pace; nothing locks, and exercises you already solved count.

Do I need Excel experience for the admin program?

Only typing data into cells and a simple SUM. Day 1 starts with averages and a locked tax rate, and every exercise has hints and a worked solution.

Does Excel for Admin Assistants cover mail merge?

No. Mail merge runs in Word and Outlook, which the practice grid cannot open. The program covers the Excel side: clean names and emails, joined and split text, and lists ready to merge.

How do I know the admin program 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). After it, the 7-day Level 2 plan is the natural next step.

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 Sales and Marketing

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

  • Excel for Accounting and Bookkeeping

    For AP/AR, bookkeeping and month-end work: tax lines, due dates, overdue invoices, SUMIFS by month and lookups.

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.