Advanced Excel for Auditors & Accountants

Course Objectives: By the end of this course, participants will: Master advanced Excel tools and techniques to streamline auditing and accounting tasks. Automate repetitive tasks using Excel functions, formulas, and macros. Analyze large datasets efficiently using PivotTables, Power Query, and advanced filtering. Create dynamic and interactive financial reports and dashboards. Enhance data accuracy and integrity through data validation and error-checking tools. Apply Excel skills to real-world auditing and accounting scenarios. Credits 24 CPD Hours 24 Days 3 Cost - Virtual R 3999 Physical R 4999 Email: Training@psaaa.co.za

Planning & Preparing for External Audit

The main focus of the learning in this knowledge module is to build an understanding of auditing process and reporting and implementation of audit recommendations. The learning will enable learners to demonstrate an understanding of:  KM-10-KT01: Nature of municipal audit functions (10%)  KM-10-KT02: Planning and conducting financial regularity audit (40%)  KM-10-KT03: Internal audit engagements within the municipality (10%)  KM-10-KT04: Audit of Performance Information (AOPI) and other special investigations (25%)  KM-10-KT05: Reporting of external audit findings and recommendations (10%)  KM-10-KT06: Design of Financial Management Improvement Action Plan (5%) 16 Credits 16 Hours 3 Days Cost: Virtual R 3999 Physical R 4999

AI in Auditing

Comprehensive 3-day workshop agenda on AI in Auditing tailored for auditors and accountants. The workshop is designed to provide a mix of theoretical knowledge, practical applications, and hands-on exercises to help participants understand and leverage AI in their profession. Objectives & Outcomes: Importance of AI in the future of Auditing.Basics of AI Machine learning Basics Relavance to Audting.AI Applications in Auditing Use cases in Auditing - Fraud Detection - Risk Assessment - Transaction Monitoring - Predictive Anaytics for financial forecasting.Tools & Technologies Overview of AI Tools - Data Analytics Platform - AI powered Audit Tools 3 Days 3 CPD Hours Cost - Virtual R 5999 Physical R 6999

Municipal Revenue & Expenditure Management

The main focus of the learning in this knowledge module is to build an understanding of tools and processes of on how to manage municipal revenues and associated sources to enhance delivery of constitutionally mandated services. The learning will enable learners to demonstrate an understanding of:  KM-05-KT01: Revenue, credit control and debt management policy (40%)  KM-05-KT02: Expenditure Management (30%)  KM-05-KT03: Municipal revenue sustainability management (15%)  KM-05-KT04: Indigent revenue management strategies and reporting (15%) 12 Credits 12 Hours 3 Days Cost: Virtual R 3999 Physical R 4999

Coporate Governance & Risk Management

The main focus of the learning in this knowledge module is to build an understanding of the importance of corporate governance and risk management with the municipal context. The learning will enable learners to demonstrate an understanding of:  KM-06-KT01: Purpose of Risk Management Policy within the municipal context (10%)  KM-06-KT02: Risk Management Framework (15%)  KM-06-KT03: Institutional mechanisms (committees) (15%)  KM-06-KT04: Establishing integrated risk management model (10%)  KM-06-KT05: Municipal leadership and governance (50%) 12 Credits 12 CPD Hours 3 Days Cost: Virtual R 3999 Physical R 4999

Fraud Auditing & Investigation

By the end of this course, participants will: 1. Understand the fundamentals of fraud, including types, causes, and red flags. 2. Learn how to design and implement effective fraud prevention and detection controls. 3. Develop skills to conduct fraud investigations, including evidence collection and interviewing techniques. 4. Gain knowledge of legal and ethical considerations in fraud investigations. 5. Apply fraud auditing techniques to real-world scenarios. 3 Credits 3 CPD Hours 3 Days Cost - Virtual R 3999 Physical R 4999

Develop and Conduct outcome Base Assessment

The learning outcomes covered during the course are: •Demonstrate knowledge of the principles and process of team building in workplace activities. •Obtain agreement from team members on objectives timeframes, rules and guidelines. •Lead teams to complete workplace activities. •Delegate tasks and review decisions and the progress with delegated tasks. 10 Credits 10 CPD Hours Cost: Virtual R 3999 Physical R 4999

Municipal Asset and Liability Management

The main focus of the learning in this knowledge module is to build an understanding of principles and practices of sound asset and liability management. The learning will enable learners to demonstrate an understanding of:  KM-04-KT01: South African regulatory framework (10%)  KM-04-KT02: Municipal current assets and liabilities (25%)  KM-04-KT03: Municipal non-current assets and non-current liabilities (50%)  KM-04-KT04: Managing municipal investments (15%) 12 Credits 12  CPD Hours Cost: Virtual R 3999 Physical R 4999