Excel Practice Sheets

Excel Practice for Accountants

Accounting Excel is reconciliation work: two lists that should agree, and the job of finding out where they do not.

Start Accounting Practice22 exercises, free, no account needed

What the job actually asks for

The month-end close is a sequence of comparisons — ledger against bank, subledger against control account, this period against last. Most of it is lookups and conditional sums over data that arrives inconsistently formatted, with trailing spaces and numbers stored as text.

The recurring tasks

  • Match transactions across two ledgers
  • Age accounts receivable by invoice date
  • Summarise expenses by account code
  • Flag entries that fall outside policy

Where people get caught

Values that look identical but will not match, because one side has a trailing space or a number stored as text. A lookup returns #N/A and the instinct is to blame the formula rather than the data.

What interviews test

Aging receivables by invoice date, summing by account code with more than one condition, and spotting why two apparently identical values fail to match.

Excel skills accountants actually use

Each of these is a task the job asks for, with the exercises that drill it.

Practice built from accounting work

22 exercises using the situations above. Work down the levels — each one assumes the one before it.

Intermediate

10 exercises · 2–3 steps

Two or three functions combined, or one function with conditions.

Advanced

7 exercises · 3–5 steps

Nested logic across a realistic dataset, with edge cases that bite.

Prefer to work in real Excel? Download the practice files — the same datasets with the answer cells left blank. You lose the feedback, which is the part that does the teaching.

Other roles

Skills every role needs

These are not specific to accounting — they are the keystrokes and the misconceptions that catch everyone out, whatever the spreadsheet is about.