Lesson · Excel for accountants
Checks and controls in a workbook
Add balance and completeness checks to a workbook.
9 minutes Standard as at 5 November 2026
What you will be able to do
- Add balance and completeness checks to a workbook
- Protect formulas and document assumptions
This is a preview of a member lesson. The full lesson is in the Excel for accountants library, open to everyone who enrols.
Free · one email a week
IFRS and SAM, one requirement at a time
Each week you get the Institute's new articles: one requirement of IFRS 17, IFRS 9, IFRS 15, IFRS 18 or SAM, worked on a South African case. You start with the free IFRS 18 readiness checklist, ten areas to work through before IFRS 18 takes effect, each with its paragraph reference.