Excel practice for accountants: all lessons
Lessons 1 to 4 are free with no sign-up. Progress is saved in this browser only.
- Lesson 1: SUM, AVERAGE and MAX on a cash ledger
3 exercisesFree - Lesson 2: Absolute references: lock the tax rate with $
3 exercisesFree - Lesson 3: Running balances with debits and credits
3 exercisesFree - Lesson 4: SUMIF: build a trial balance from journal lines
3 exercisesFree - Lesson 5: VLOOKUP and XLOOKUP with a chart of accounts
3 exercisesFull course - Lesson 6: Accounts receivable aging with dates and nested IF
3 exercisesFull course - Lesson 7: Bank reconciliation: find outstanding checks
3 exercisesFull course - Lesson 8: Depreciation schedules with SLN and DDB
4 exercisesFull course - Lesson 9: SUMIFS: expenses by department and month
2 exercisesFull course - Lesson 10: Prepaid and accrual schedules with EOMONTH and ROUND
3 exercisesFull course - Lesson 11: INDEX and MATCH: look up to the left
2 exercisesFull course - Lesson 12: Clean a GL export: LEFT, TRIM and VALUE
3 exercisesFull course - Lesson 13: Loan payments and interest with PMT
3 exercisesFull course - Lesson 14: Timed mock test: 10 mixed accounting Excel tasks
10 exercisesFull course