CPD · advanced
Computerized Accounting Specialist
Syllabus
Part 1 of 3 — Excel
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
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