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

Excel for Accounting and Bookkeeping: a 10-Day Practice Program

27 graded exercises over 9 practice days, about 22 minutes a day, then the free 25-minute Level 2 test as the finish line. You build copy-proof sheets, run payables and receivables checks, summarize the month with SUMIFS grids and clean customer and order lists. This is spreadsheet operations, not financial modeling. Free, no sign-up.

  • 10 Tage
  • 27 bewertete Übungen
  • 15–31 Min. pro Tag
  • Abschlusstest: Stufe 2, 25 Min.
  • 3 Übungen nutzen Funktionen, die Excel 2019 und älteren Versionen fehlen
  • Kostenlos, ohne Anmeldung
Tag 1 starten

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

Programminhalte auf Englisch

  1. 1 Tag 1: Copy-proof sheets: a locked rate, a grid, formats
  2. 2 Tag 2: Totals, joins and flags: SUMIF, another sheet, IF
  3. 3 Tag 3: Payables checks: missing IDs, margins, Not found
  4. 4 Tag 4: Receivables and payroll: due dates, overdue, rates
  5. 5 Tag 5: Month-end grids: tiers, SUMIFS, revenue by month
  6. 6 Tag 6: Clean lists: missing SKUs, padded names, duplicates
  7. 7 Tag 7: Board-pack checks: Count vs Sum, % of total, series
  8. 8 Tag 8: Weighted cost, a two-way lookup, a live list
  9. P Tag 9: Projekttag
  10. T Tag 10: Testtag

T: Testtag · P: Projekttag

Ziellinie

Test der Stufe 2 · 20 Aufgaben · 25 Min. · unsere Bestehensgrenze liegt bei 80%

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

  • Accounts payable and receivable clerks, bookkeepers, payroll and finance assistants
  • Junior accountants who handle invoices, supplier lists, expense claims and month-end summaries
  • Candidates for those jobs facing an intermediate Excel test

Das können Sie danach

  • Build sheets that survive copying: a $-locked tax rate, a discount grid with mixed references, money and date formats
  • Run payables and receivables checks: missing Tax IDs, margins without #DIV/0!, prices not found, due dates, overdue invoices
  • Look up across sheets with VLOOKUP, XLOOKUP and INDEX/MATCH, a two-way lookup in a sales matrix and a two-key price list
  • Summarize the month: SUMIFS grids, revenue by category and month, % of grand total, a weighted average cost
  • Check a PivotTable that counts instead of sums, turn text dates into real dates and find duplicate customers

Noch nicht abgedeckt

  • Financial functions: PMT, NPV, IRR, XNPV, FV and RATE
  • Depreciation, loan schedules, financial statements and modeling
  • Bank reconciliation, consolidation across workbooks, Power Query and macros

Tag für Tag

10 Tage, 27 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

    Copy-proof sheets: a locked rate, a grid, formats

    16 Min.

    One tax rate locked with $, a discount grid with mixed references, and currency and date formats for statements.

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

      Anfänger · 5 Min.

    • Price grid for quantities × discounts (mixed references)

      Anfänger · 7 Min.

    • Apply currency and date formats

      Anfänger · 4 Min.

    • Excel formulas cheat sheet

      Zum Lesen, optional · 6 Min.

  2. Tag 2

    Totals, joins and flags: SUMIF, another sheet, IF

    15 Min.

    Totals by region with SUMIF, a customer tier from another sheet, and an IF with AND for bonus eligibility.

    • Sales by region with SUMIF

      Anfänger · 5 Min.

    • Look up a customer tier from another sheet

      Anfänger · 5 Min.

    • Bonus eligibility with IF and AND

      Anfänger · 5 Min.

  3. Tag 3

    Payables checks: missing IDs, margins, Not found

    17 Min.

    Flag suppliers with a missing Tax ID, margins without #DIV/0!, and Not found instead of an error.

    • Flag rows with missing data

      Fortgeschrittene · 5 Min.

    • Margin % without #DIV/0!

      Fortgeschrittene · 6 Min.

    • Replace VLOOKUP with XLOOKUP

      Fortgeschrittene · 6 Min.Excel 365

  4. Tag 4

    Receivables and payroll: due dates, overdue, rates

    20 Min.

    Invoice due dates at month end, an overdue-invoice highlight, and hourly rates looked up with INDEX and MATCH.

    • Invoice due dates with EOMONTH and EDATE

      Fortgeschrittene · 6 Min.

    • Highlight overdue invoices (conditional formatting)

      Fortgeschrittene · 8 Min.

    • INDEX and MATCH exact lookup

      Fortgeschrittene · 6 Min.

  5. Tag 5

    Month-end grids: tiers, SUMIFS, revenue by month

    25 Min.

    Tiered rates, totals by two conditions, and revenue by category and month without a PivotTable.

    • Commission tiers with nested IF, IFS or a lookup

      Fortgeschrittene · 8 Min.

    • Sales by region and product with SUMIFS

      Fortgeschrittene · 7 Min.

    • Pivot without a pivot: revenue by category and month with SUMIFS

      Fortgeschrittene · 10 Min.

Tage 6–10

  1. Tag 6

    Clean lists: missing SKUs, padded names, duplicates

    21 Min.

    Discontinued items that return Not found, padded customer names, and duplicate customers listed once.

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

      Fortgeschrittene · 7 Min.

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

      Fortgeschrittene · 6 Min.

    • List unique customers (UNIQUE) — remove duplicates

      Fortgeschrittene · 8 Min.Excel 365

  2. Tag 7

    Board-pack checks: Count vs Sum, % of total, series

    26 Min.

    A PivotTable that counts instead of sums, shares of the grand total, and chart series read both ways.

    • Fix a PivotTable that counts instead of sums

      Fortgeschrittene · 12 Min.

    • Share of revenue by channel: % of Grand Total with formulas

      Fortgeschrittene · 7 Min.

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

      Fortgeschrittene · 7 Min.

  3. Tag 8

    Weighted cost, a two-way lookup, a live list

    26 Min.

    A quantity-weighted average with SUMPRODUCT, a monthly sales figure looked up by month and region, and a live FILTER list.

    • Weighted average price with SUMPRODUCT

      Experten · 8 Min.

    • Two-way lookup in a matrix

      Experten · 8 Min.

    • Orders over $1,000 in West with FILTER

      Experten · 10 Min.Excel 365

  4. Tag 9

    Project day: close the month

    Projekttag · 31 Min.

    Order dates typed three ways turned into real dates, a two-key price lookup, and revenue with margin % on one chart.

    • Turn text dates into real dates and group by month

      Experten · 12 Min.

    • Two-criteria lookup (product and region)

      Experten · 10 Min.

    • Revenue and margin % in one readable chart

      Experten · 9 Min.

  5. Tag 10

    Final test: Level 2

    Abschlusstest · 25 Min.

    The free Level 2 test: 20 tasks in 25 minutes. Its expense-claim and inventory workbooks are close to accounting work, but each attempt draws 2 of 4 families at random.

    • Abschlusstest: Stufe 2 · 20 Aufgaben · 25 Min.

      →
    • How we grade the test

      Zum Lesen, optional · 5 Min.

Fragen zu diesem Plan

How long does Excel for Accounting take?

10 days: 9 practice days of 15 to 31 minutes (about 22 on average), then the 25-minute Level 2 test. Nothing locks, and exercises you already solved count.

What should I know before the accounting program?

SUM, a simple IF and the $ sign. Day 1 revisits $ references and number formats before the lookups and summaries start.

Does Excel for Accounting cover NPV, IRR or PMT?

Not yet. There are no exercises on financial functions, depreciation or loan schedules, so the program stops at the Level 2 test. Level 3 can draw an equipment-financing project with PMT, NPER and Goal Seek that this program does not teach.

How do I know the accounting program worked?

The finish line is the free Level 2 test: 20 tasks in 25 minutes, with our pass line at 80%. No program can promise a pass: employers set their own pass marks, and our cutoffs are our own.

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 Data Analysts

    For analyst work and the Level 3 project test: summary grids, cleanup, expert lookups and pivot-style reports.

  • 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.