Financial Analysis in Excel Training Course

Who This Course Is For

Designed for Senior Management teams seeking a practical understanding of AML/CTF principles and prevention strategies, alongside awareness of current and emerging Financial Crime issues.

Course Format

The program utilises an interactive blend of:

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

Learning Outcomes

Upon completion, participants will be equipped to:

• Articulate methods for preventing AML and CTF activities
• Comprehend the key aspects of AML and CTF as they relate to their organisation, including national and international countermeasures
• Outline strategies for protecting the company and its workforce from the risks of Money Laundering and Terrorist Financing
• Identify how organisations may become targets for these crimes and explain how to use 'red flags' to detect, prevent, and report suspicious or confirmed criminal activity
• Gain insight into other significant 'hot spots' within the realm 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 covers processes and practices for managing overheads, calculating BOM costs, and determining product-level costing across manufacturing and service operations.

This instructor-led, live training (online or onsite) is aimed at intermediate-level practitioners who wish to configure, operate, and validate cost centre processes 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 programme offers a comprehensive look at institutional due diligence frameworks for financial institutions, blending regulatory, financial, operational, and ethical aspects of compliance. It weaves Common Reporting Standard (CRS) requirements into wider due diligence modules covering management, governance, technology, and business operations.

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

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

• Grasp and apply due diligence principles across institutional, financial, legal, and operational domains.
• Implement due diligence aligned with CRS and FATCA 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.

Course Format

• Interactive lectures and discussions.
• Case studies and group exercises.
• Practical application using mock due diligence documentation and workflows.

Course Customisation Options

• To request a customised training session for this course, please contact us to make arrangements.

This instructor-led, live training in Australia (online or onsite) is designed for finance and legal professionals seeking to master the principles and practices of extrajudicial and judicial recovery, empowering them to effectively manage and resolve outstanding debt issues.

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

• Assess the advantages and disadvantages of both extrajudicial and judicial recovery methods.
• Apply core methods and techniques for extrajudicial and judicial recovery.
• Evaluate the effectiveness and efficiency of extrajudicial and judicial recovery processes.
• Navigate the legal and ethical considerations inherent in extrajudicial and judicial recovery.
• Integrate extrajudicial and judicial recovery strategies in a comprehensive and cohesive manner.

This instructor-led, live training (available online or onsite) is designed for managers who want to identify and reduce the risk of fraud facing eCommerce merchants.

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

• Understand how eCommerce fraud occurs.
• Analyze vulnerabilities in their company's eCommerce platform and processes.
• Assess a company's 'readiness' for adopting new anti-fraud measures
• Communicate and incorporate appropriate anti-fraud policies.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

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

This introductory course delivers a premier and comprehensive understanding of key financial markets, including their purpose, function, core activities, and regulatory frameworks. Designed as a blend of refresher, educational, and challenging content, it ensures participants derive maximum benefit. Active feedback and discussion are encouraged throughout the interactive sessions, which go beyond mere fact-sharing to foster deep engagement.

Upon completion, delegates will be significantly better equipped to address client needs and contextually understand the services and markets in which they operate and trade.

This instructor-led live training in Australia (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 Australia (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, optimization 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 optimization.
• Prepare for the FinOps Certified FOCUS Analyst exam.

This instructor-led, live training in Australia (online or on-site) is designed for advanced-level cloud financial management professionals seeking to validate their expertise in financial operations (FinOps) related to cloud cost management.

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

• Aquire the advanced knowledge necessary for the FinOps Certified Professional exam.
• Comprehend complex FinOps practices, including cost optimisation, budget management, and reporting.
• Develop practical skills in applying FinOps strategies to real-world scenarios.
• Prepare for a successful outcome in the FinOps Certified Professional exam.

Introduction to Structured Products

This course is designed to provide delegates with an overview of the structured products utilised in investment banking. Upon completing the program, participants will possess a practical understanding of the subject and will be equipped to address

1. What constitute structured products?
2. Why are they issued?
3. How do issuers and investors derive benefit?
4. How to structure and price a variety of derivative products?
5. What are the associated risks and costs of creating structured financial instruments?
6. What are embedded derivatives?
7. What defines exotic options?
8. What considerations apply to pricing and hedging?

This instructor-led, live training in Australia (online or onsite) is designed for non-finance professionals at the beginner level who seek a foundational grasp of financial and accounting principles crucial for effective business decision-making.

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

• Grasp the fundamental financial and accounting concepts vital for business decision-making.
• Interpret and analyse financial statements, including income statements, balance sheets, and cash flow statements.
• Utilise key financial ratios to evaluate the financial health of an organisation.
• Create and manage budgets, and conduct variance analysis to monitor business performance.
• Apply break-even analysis to support operational and strategic decisions.

This instructor-led live training in Australia (online or onsite) is targeted at developers who wish to utilise the Open Bank Project API to develop and test decentralized applications that can be easily integrated with digital banking systems.

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

• Configure the necessary development environment to begin building applications using the OBP API.
• Gain a solid understanding of the Open Bank Project architecture, technology, and core concepts.
• Learn how to utilise and customise the OBP API to develop and construct banking applications.
• Explore the features, tools, APIs, and sandboxes available within OBP.
• Implement security measures and integrations within OBP API connectors and adapters.

This instructor-led, live training in Australia (online or onsite) is designed for application consultants and business process owners who wish to learn how to configure business processes for the SAP S4 HANA financials module.

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

• Grasp the fundamental customising settings within the primary components of Financial Accounting using SAP S4HANA.
• Set up master data configurations (G/L accounts, customer and vendor accounts) for FA in SAP S4HANA.
• Configure document control, posting control, and financial document clearing settings for FA in SAP S4HANA.