CPD · advanced
Excel for Accounting & Finance Professionals
Syllabus
Module 1 — Friday 24 and Saturday 25 April 202619 lessons · 2½ h
Welcome and Your Course Workbook4 min
The Excel Interface: Ribbon, Sheets and Cells7 min
The Sales Summary Lab6 min
Counting Records with COUNTIF9 min
Totalling Sales with SUMIF9 min
Absolute Cell References with F412 min
Percentage of Total and Your Assignment5 min
SUMIF Payment Totals5 min
Absolute Cell References14 min
Category Sales Summaries12 min
Invoice Statistics Functions8 min
Invoice Status Analysis10 min
Expense Schedule Analysis7 min
Variance Classification with IF8 min
IF Formula Review5 min
Formula Syntax Troubleshooting4 min
Student Grade Classification6 min
Student Count Summaries8 min
Multiple Criteria Counting7 min
Module 2 — Sunday 26 April 20269 lessons · 1½ h
Workbook Setup and Cleanup2 min
Nested IF Grading Basics8 min
Completing Grade Formulas10 min
Grade Points and Interpretation7 min
Lookup Functions Introduction4 min
VLOOKUP Short Descriptions18 min
VLOOKUP Categories and Ranges9 min
Retail Price Lookup11 min
Cost Formula and Wrap-Up5 min
Module 3 — Thursday 30 April 20266 lessons · 1 h
XLOOKUP Fundamentals16 min
Excel Tables and Named Ranges19 min
INDEX MATCH Discounts14 min
SUMPRODUCT Basics6 min
PAYE Tax Calculation8 min
Course Wrap-Up and Questions5 min