Courses
Excel for accountants
The Excel an accountant uses every week: clean tables from a ledger export, lookups, PivotTables, Power Query on bank statements, a reusable bank reconciliation, aged debtors and the checks that keep a workbook honest.
Curriculum
What this course covers.
The lessons, in the order you work through them. Lessons publish on a rolling basis, and your library shows exactly what is ready as each one publishes.
- Tables and clean data from the ledger export 10 min
- Lookups: matching invoices to payments 10 min
- PivotTables: sales by customer and month 10 min
- Power Query: importing and cleaning bank statements Coming
- A reusable bank reconciliation template Coming
- Aged debtors analysis Coming
- Checks and controls in a workbook Coming
- Charts that managers read 10 min
Buying
R950, twelve months, when it opens.
One price, twelve months.
R950
Not yet open for enrolment
Access covers every lesson published so far, plus lessons added and revisions made during your access period.
12 months of access
Every lesson published so far, plus every lesson added and every revision made during your access period. Your library shows exactly what is ready as each lesson publishes.
Practice only
12 months of TOOLS_EXCEL Practice, without the course
Exam-style questions on every lesson's objectives, each with a worked solution and the standard paragraph behind the answer, plus flashcards scheduled by how well you know them. Every test draws fresh questions and leans toward what you have found hardest.
Lessons are not included. If you want those too, the course is better value: course holders add Practice from their member area for less.
Questions
Before you enrol.
How long do I have access?
Twelve months from purchase. That covers every lesson in the course, every lesson added to it during your year and every revision made along the way.
Does this count towards CPD?
Yes, as evidence. Your certificate is verifiable CPD evidence: it states the hours of recorded instruction you completed and the learning outcomes of every lesson, and anyone can check it at the verification link printed on it. Amatle Institute is not an accredited CPD provider, so you log it with your professional body (SAICA, IRBA, ASSA, CIMA or ACCA, for example) under that body's own rules.