CPD · advanced
Excel for Accounting & Finance Professionals
Syllabus
Day 1 — Saturday 25 April 202612 lessons · 2½ h
SUMIF Payment Totals14 min
Absolute Cell References15 min
Category Sales Summaries14 min
Invoice Statistics Functions10 min
Invoice Status Analysis13 min
Expense Schedule Analysis10 min
Variance Classification with IF12 min
IF Formula Review9 min
Formula Syntax Troubleshooting9 min
Student Grade Classification13 min
Student Count Summaries14 min
Multiple Criteria Counting15 min
Day 2 — Sunday 26 April 20269 lessons · 2 h
Workbook Setup and Cleanup5 min
Nested IF Grading Basics9 min
Completing Grade Formulas15 min
Grade Points and Interpretation24 min
Lookup Functions Introduction10 min
VLOOKUP Short Descriptions24 min
VLOOKUP Categories and Ranges11 min
Retail Price Lookup20 min
Cost Formula and Wrap-Up8 min
Day 3 — Thursday 30 April 20267 lessons · 1½ h
XLOOKUP Fundamentals32 min
Excel Tables and Named Ranges29 min
INDEX MATCH Discounts15 min
Payroll Template Setup6 min
SUMPRODUCT Basics7 min
PAYE Tax Calculation14 min
Course Wrap-Up and Questions8 min