CPD · advanced
Computerized Accounting Specialist
Syllabus
Part 1 of 3 — Excel
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
Part 2 of 3 — Sage 50
Day 1 — Friday 1 May 20269 lessons · 1½ h
Sage Product Overview9 min
Software Installation Steps8 min
Trial Setup Options8 min
Sample Company Dashboard15 min
Modules and General Ledger12 min
System Settings Configuration15 min
Session Dates and Year-End11 min
Financial Reports Overview8 min
Software Applications Discussion8 min
Day 2 — Saturday 2 May 202618 lessons · 3 h
New Company Setup6 min
Fiscal Year Settings3 min
Business Type and Accounts8 min
Account Coding Principles11 min
Company Database Creation11 min
Cash Opening Balances10 min
Equity and Migration Balances10 min
Customer Account Setup13 min
Customer Codes and Sales13 min
Supplier Setup and Purchasing13 min
Inventory Item Setup12 min
Inventory Units and Accounts13 min
Product Setup Troubleshooting13 min
Inventory Costing Automation10 min
Receipts and Bank Deposits12 min
Fund Transfers and Dates10 min
Payment Voucher Processing10 min
Tax Setup Preview8 min
Day 3 — Sunday 3 May 202614 lessons · 2½ h
Interface Preferences13 min
Fiscal Year Closing14 min
Session Date Setup7 min
Sales Quotation Setup6 min
Quotation Line Items12 min
Quote to Sales Order10 min
Sales Orders and Inventory15 min
Sales Invoice Conversion7 min
Invoice Fulfillment Processing12 min
Customer Receipt Processing7 min
Purchase Orders and Payments14 min
Bank Account Reconciliation13 min
Trial Balance and Posting10 min
Software Licensing and Closing7 min
Part 3 of 3 — QuickBooks
Day 1 — Friday 8 May 202612 lessons · 2 h
QuickBooks Introduction5 min
Installation Prerequisites11 min
Company Setup Options8 min
Installation Troubleshooting9 min
Guided Software Installation8 min
QuickBooks Interface Navigation15 min
Company Files and Backups11 min
General Preferences14 min
Accounting and Currency Settings10 min
Lists and Customer Menu10 min
Vendors Banking and Reports10 min
Reports and Payroll Limitations12 min
Day 3 — Sunday 10 May 202616 lessons · 2½ h
Service Invoices24 min
Goods Invoices and Reports16 min
Customer Payment Receipt15 min
Undeposited Funds Transfer7 min
Cash Sales Receipts8 min
Entering Vendor Bills9 min
Expense Bills and Payables10 min
Paying Vendor Bills8 min
Immediate Cheque Payments7 min
Direct Bank Deposits8 min
Deposits With Cashback7 min
Audit Trail and Asset Setup12 min
Recording Asset Purchases7 min
Payroll and Tax Entries5 min
Financial Reports and Cash Flow11 min
Budgets and Forecasts15 min