Module 1 Advanced Techniques in Financial Modelling
- Rebuild An Inherited Model
- Break A Complex Model into Several Sub-models for Model Auditing
- Automation: Record, Modify and Run VBA
Module 2 Data Organisation Techniques
- Sort without Sort
- Filter without Filter
- Pivot without Pivot Table
- Summarize Data According to Multiple Conditions
- Dynamic Data Range
Module 3 Modelling Procedures
- Starting Point of Modelling
- Format Requirements for Data Input
- Data Analysis with Different Perspectives
- Dynamic Elements – Customised (Interactive) Report
- Documentation Requirements
Module 4 Month – End Procedure & Models
- Month – End Procedure
- Case Study: Month – End Closing Checklist
- Accounts Receivable Closing Procedure
- Case Study: Commission Calculator (Based on Market, Product and Sales Amount)
- Accounts Payable Closing Procedure
- Case Study: Streamline the Process of Accrued Expense (Creditor Management – Accrued Expense)
- Case Study: Creditor Management – Prepayment
- Case Study: Amortisation Recognition – Prepayment
- Payroll Closing Procedure
- Case Study: Payroll Interface & Payroll General Journal
- Fixed Asset Closing Procedure
- Case Study: Depreciation Calculator with Variety Asset Categories
Module 5 Data Reconciliation Skills
- Same Structure Data Reconciliation
- Different Structure Data Reconciliation
- Speak Cell & Reconciliation
Module 6 Accounts Reconciliation
- Definition of Reconciliation and Why We Need It
- Reconciliation Issues
- Best Practices in Preparing Accounts Reconciliations
- Differences Between Bank Statement and Cash Accounts Ledger
- Case Study: Bank Reconciliation
- General Ledger to Sub-Ledger Reconciliation
- Case Study: Use Multi-data Source Pivot for GL Reconciliation
- Case Study: General Ledger Reconciliation Model
- Case Study: Annual Leave Liability Calculation
- Case Study: Long Service Leave Provision Calculation
- Case Study: BAS Report Template