Financial Analysis in Excel Training Course

Target Audience

This course is designed for all Senior Management personnel who require a practical understanding of AML and CTF frameworks, their preventive measures, and an awareness of contemporary financial crime issues.

Course Format

The learning experience is delivered through a blend of:

• Guided group discussions
• Slide-based presentations
• Real-world case studies
• Practical examples

Learning Objectives

Upon completing this course, participants will be equipped to:

• Articulate strategies for preventing AML and CTF breaches
• Comprehend the core elements of AML and CTF as they pertain to their organisations, including national and global initiatives to combat these crimes
• Outline the measures companies and their employees must take to safeguard against Money Laundering and Terrorist Financing risks
• Explain how organisations may become targets for these financial crimes and identify key "red flags" to detect, prevent, and report suspicious or confirmed illicit activities
• Gain insight into significant emerging areas of financial crime

Finance / Management

This instructor-led, live training in (online or onsite) is aimed at manufacturing managers and engineers who wish to strengthen their ability to evaluate investments, build robust business cases, and present compelling narratives for capital projects.

By the end of this training, participants will be able to: calculate and apply core investment appraisal metrics to manufacturing scenarios, build a complete CAPEX investment case including cash flow projections and sensitivity analysis, use templates and Capex Cards to streamline the approval process, and prepare clear executive-level narratives to justify capital expenditure requests.

The Cost Centre module outlines the routines and best practices for managing overheads, calculating BOM costs, and determining product-level costing across manufacturing and service operations.

This instructor-led, live training (available online or onsite) is designed for intermediate-level practitioners who wish to configure, operate, and validate cost centre routines within enterprise environments.

Upon completing this course, participants will gain the ability to:

• Create, configure, and maintain cost centres aligned with organisational structures.
• Build and validate BOM costing using standard, activity-based, and overhead allocation methods.
• Integrate machine hours, operator hours, and labour metrics into cost centre calculations.
• Apply absorption costing principles to ensure accurate product and period-end valuations.

Format of the Course

• Guided instruction with case-based demonstrations.
• Hands-on costing exercises and spreadsheet-based modelling.
• Application-focused labs simulating real costing and reconciliation workflows.

Course Customisation Options

• For tailored content, industry-specific costing models, or ERP platform alignment, please contact us.

This course offers a thorough overview of institutional due diligence frameworks designed for financial institutions, blending regulatory, financial, operational, and ethical compliance aspects. It harmonises Common Reporting Standard (CRS) requirements with broader due diligence modules spanning management, governance, technology, and business operations.

This instructor-led, live training (available online or on-site) targets intermediate-level compliance, risk, and operations professionals keen on implementing a holistic due diligence programme aligned with international best practices and jurisdictional standards.

Upon completing this training, participants will be able to:

• Understand and apply due diligence principles across institutional, financial, legal, and operational domains.
• Implement CRS and FATCA-aligned due diligence for tax-residency verification and reporting.
• Integrate governance, ESG, and business integrity measures into compliance systems.
• Develop risk-based due diligence frameworks encompassing management, marketing, and IT functions.
• Prepare internal teams for audits, regulatory reviews, and continuous improvement cycles.

Format of the Course

• Interactive lecture and discussion.
• Case studies and group exercises.
• Hands-on practice using mock due diligence documentation and workflows.

Course Customization Options

• To request a tailored training for this course, please contact us to arrange.

This instructor-led, live training in South Africa (online or onsite) is designed for finance and legal professionals keen on mastering the principles and practices of extrajudicial and judicial collection, thereby empowering them to effectively manage and resolve collection challenges.

Upon completion of this training, participants will be able to:

• Understand the advantages and disadvantages of extrajudicial and judicial collection.
• Apply the main methods and techniques of extrajudicial and judicial collection.
• Evaluate the effectiveness and efficiency of extrajudicial and judicial collection.
• Navigate the legal and ethical issues involved in extrajudicial and judicial collection.
• Integrate extrajudicial and judicial collection in a comprehensive and coherent way.

This instructor-led, live training (available online or onsite) is designed for managers seeking to identify and mitigate fraud risks faced by eCommerce businesses.

Upon completing this training, participants will be able to:

• Comprehend the mechanisms behind eCommerce fraud.
• Analyze vulnerabilities within their organisation's eCommerce platform and operational processes.
• Assess their company's 'readiness' for implementing new anti-fraud measures.
• Effectively communicate and integrate suitable anti-fraud policies.

Course Format

• Interactive lectures and discussions.
• Ample exercises and practical application.
• Hands-on implementation within a live-lab environment.

Course Customisation Options

• To request customised training for this course, please contact us to arrange.

This foundational course offers participants a high-calibre, detailed understanding of key financial markets, including their objectives, functions, primary activities, and regulatory frameworks. Designed as a blend of refresher content, educational material, and practical challenge, it ensures that all delegates maximise their learning outcomes. Active feedback and discussion are encouraged throughout the interactive sessions, moving beyond mere factual recall to foster deeper engagement.

The primary objective is to equip delegates with enhanced capabilities to address client needs and contextualise the services and markets in which they operate and participate.

This instructor-led live training in South Africa (online or onsite) is aimed at cloud administrators, cloud architects, technology heads, and financial analysts who wish to record, manage, monitor, and process financial assets of an organisation in the cloud.

By the end of this training, participants will be able to use FinOps practices in an organisation to forecast costs, optimise processes, and perform financial management operations in the cloud.

This instructor-led, live training in South Africa (online or onsite) is aimed at intermediate-level finance professionals who wish to gain a comprehensive knowledge of FinOps principles and methodologies, including cloud financial management, optimisation strategies, and collaboration among finance, engineering, and business teams.

By the end of this training, participants will be able to:

• Understand the FinOps framework, principles, and phases.
• Manage cloud costs effectively through data analysis and governance.
• Collaborate between finance, engineering, and business units to align cloud spend.
• Use FinOps tools for cost allocation, forecasting, and optimisation.
• Prepare for the FinOps Certified FOCUS Analyst exam.

This instructor-led, live training in South Africa (online or onsite) is aimed at advanced-level cloud financial management professionals who wish to validate their expertise in financial operations (FinOps) related to cloud cost management.

By the end of this training, participants will be able to:

• Gain advanced knowledge required for the FinOps Certified Professional exam.
• Understand complex FinOps practices, including cost optimisation, budget management, and reporting.
• Develop practical skills in applying FinOps strategies in real-world scenarios.
• Prepare for a successful completion of the FinOps Certified Professional exam.

This instructor-led live training (onsite or remote) is designed for accountants and bookkeepers aiming to utilise Xero for their bookkeeping duties.

Upon completion of this training, participants will be able to:

• Gain real-time visibility into cash flow.
• Connect bank accounts to Xero for bank reconciliation.
• Prepare and verify VAT (Value Added Tax) returns within Xero.
• Generate reports for sharing with team members.

This instructor-led, live training in South Africa (online or onsite) is designed for beginner-level non-finance professionals who wish to gain a foundational understanding of the financial and accounting principles essential for effective business decision-making.

Upon completion of this training, participants will be able to:

• Grasp fundamental financial and accounting concepts crucial for business decision-making.
• Interpret and analyse financial statements, including income statements, balance sheets, and cash flow statements.
• Apply key financial ratios to assess the financial health of a business.
• Develop and manage budgets, and perform variance analysis to monitor business performance.
• Utilise break-even analysis to support operational and strategic decisions.

This instructor-led live training, offered South Africa (online or onsite), is designed for developers who wish to use the Open Bank Project API to develop and test decentralised applications that can be easily integrated with digital banking systems.

By the end of this training, participants will be able to:

• Set up the necessary development environment to start developing applications with OBP API.
• Understand the Open Bank Project architecture, technology, and concepts.
• Learn how to use and customize OBP API to develop and build applications for banking.
• Explore the features, tools, APIs, and sandboxes in OBP.
• Implement security and integrations in OBP API connectors and adapters.

This instructor-led live training in South Africa (online or onsite) is targeted at application consultants and business process owners who wish to learn how to configure business processes for the SAP S/4HANA financials module.

Upon completion of this training, participants will be able to:

• Understand the basic customizing settings in the main components of Financial Accounting with SAP S/4HANA.
• Configure the master data settings (G/L accounts, customer and vendor accounts) of FA with SAP S/4HANA.
• Configure document control, posting control, and financial document clearing settings of FA with SAP S/4HANA.