Financial Analysis in Excel Training Course

Target Audience

Senior management personnel who require a practical understanding of AML/CTF principles, their prevention, and awareness of current relevant Financial Crime issues;

Course Format

The course comprises a mix of the following elements:

• Guided Discussions
• Slide Presentations
• Case Studies
• Practical Examples

Course Objectives

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

• Explain methods for preventing AML and CTF activities
• Comprehend the key aspects of AML and CTF as they pertain to their organisations, as well as national and international efforts to combat these crimes
• Define how an organisation and its employees should safeguard against the risks associated with Money Laundering and Terrorist Financing
• Detail how an organisation may become a target for Money Laundering and Terrorist Financing, and explain which 'red flags' can assist in identifying, preventing, and reporting any (suspicious or confirmed) criminal activity
• Understand certain other 'hotspots' within Financial Crime

Combating money laundering is a priority on the global stage. Compliance officers, AML Officers, MLROs, KYC analysts, auditors, and managers must understand how to ensure adherence to Subsidiary 373.01, the Prevention of Money Laundering and Funding of Terrorism Regulations (PMLFTR).

Under the PMLFTR, all Subject Persons, including those within the regulated financial services sector, are mandated to appoint a Money Laundering Reporting Officer (MLRO).

This practical course provides you with the knowledge and essential guidance on how to approach AML compliance within your organisation, with specific attention to the regulatory environment in Malta.

Finance / Management

This instructor-led, live training (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 encompasses the routines and best practices for managing overheads, calculating Bills of Materials (BOM) costs, and determining product-level costs 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 organizational structures.
• Build and validate BOM costing using standard, activity-based, and overhead allocation methods.
• Integrate machine hours, operator hours, and labor 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 modeling.
• Application-focused labs simulating real costing and reconciliation workflows.

Course Customization Options

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

This instructor-led, live training (available online or onsite) is designed for managers who wish to identify and minimize the risk of fraud faced by 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 offers participants a comprehensive and practical understanding of essential financial markets, including their objectives, functions, key activities, and regulatory frameworks. Designed to serve as both a refresher and an educational challenge, the programme ensures that all delegates gain maximum value. Interactive feedback and discussion are actively encouraged throughout the sessions, which are structured to be engaging and dynamic rather than merely factual or reactive.

Upon completion, all course delegates will be significantly better equipped to address client needs and contextualise the services and markets in which they operate and invest.

This instructor-led, live training in Botswana (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 organization in the cloud.

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

This instructor-led, live training in Botswana (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 Botswana (online or on-site) is designed for advanced-level cloud financial management professionals who wish to validate their expertise in financial operations (FinOps) relating to cloud cost management.

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

• Acquire 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 successful completion of the FinOps Certified Professional exam.

This instructor-led, live training in Botswana (online or on-site) is aimed at professionals who wish to expand their understanding of FinOps and prepare for the FinOps Certified Practitioner certification exam.

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

• Understand cloud usage and cost modelling, cost allocation, and resource planning.
• Comprehend the core pillars of FinOps and how to implement them within an organisation.
• Learn how organisations define pricing model goals and utilise historical data to make informed adjustments.
• Approach the FinOps Certified Practitioner certification exam with confidence.

Introduction to Structured Products

This course aims to provide participants with a comprehensive introduction to the structured products utilised within investment banking. Upon completing the course, all delegates will possess a practical understanding of the subject matter and will be capable of answering

1. What constitute structured products?
2. What drives their issuance?
3. How do issuers and investors derive value from them?
4. How does one structure and price various derivative products?
5. What are the associated risks and costs of creating structured financial products?
6. What defines embedded derivatives?
7. What characterises exotic options?
8. What are the key considerations regarding pricing and hedging?

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

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

• Comprehend the basic financial and accounting concepts vital for business decision-making.
• Interpret and analyse financial statements, including income statements, balance sheets, and cash flow statements.
• Apply key financial ratios to evaluate 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 in Botswana (online or onsite) is aimed at developers who wish to use the Open Bank Project API to develop and test decentralized applications that can be integrated easily 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 the OBP API.
• Understand the Open Bank Project architecture, technology, and concepts.
• Learn how to use and customize the 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 Botswana (online or onsite) is aimed at application consultants and business process owners who wish to learn how to configure business processes for the SAP S/4 HANA financials module.

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

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