Financial Analysis in Excel Training Course

Target Audience

This course is designed for Senior Management personnel who require a practical understanding of AML/CTF frameworks and their preventive measures, along with a comprehensive awareness of other pertinent and current financial crime challenges.

Course Delivery Method

The training is delivered through a blended approach comprising:

• Guided group discussions
• Presentations supported by slides
• Analysis of real-world case studies
• Practical illustrative examples

Learning Objectives

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

• Articulate strategies for preventing AML and CTF activities
• Comprehend the core components of AML and CTF as they pertain to their organizations, alongside an understanding of national and international initiatives aimed at combating these crimes
• Define the appropriate measures for an organization and its employees to mitigate risks associated with Money Laundering and Terrorist Financing
• Identify how a company may become a target for such activities and recognize key "red flags" that aid in identifying, preventing, and reporting suspicious or confirmed criminal acts
• Gain insight into other significant "hot spots" within the realm of Financial Crime

There is a strong global focus on combating money laundering. 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 required to appoint a Money Laundering Reporting Officer (MLRO).

This practical course provides you with the knowledge and essential guidance needed to implement AML compliance within your organization, with particular 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 Center module focuses on the routines and best practices for managing overheads, computing BOM costs, and establishing product-level costing across manufacturing and service operations.

This instructor-led live training, available online or on-site, is designed for intermediate-level professionals aiming to configure, operate, and validate cost center routines within enterprise systems.

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

• Create, configure, and maintain cost centers that align with organizational structures.
• Construct and validate BOM costing utilizing standard, activity-based, and overhead allocation methods.
• Incorporate machine hours, operator hours, and labor metrics into cost center calculations.
• Apply absorption costing principles to ensure precise product and period-end valuations.

Course Format

• Guided instruction featuring case-based demonstrations.
• Hands-on costing exercises and spreadsheet-based modeling.
• Application-focused labs that simulate real-world costing and reconciliation workflows.

Course Customization Options

• For tailored content, industry-specific costing models, or alignment with specific ERP platforms, please reach out to us.

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

Upon completing this training, participants will be able to:

• Comprehend how eCommerce fraud occurs.
• Analyze vulnerabilities in their company's eCommerce platform and processes.
• Evaluate a company's 'readiness' to adopt new anti-fraud measures
• Communicate and implement appropriate anti-fraud policies.

Format of the Course

• Interactive lecture and discussion.
• Extensive 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 the key financial markets, including their objectives, operations, core activities, and regulatory frameworks. Designed to serve as both a refresher and an educational deep-dive, while also challenging existing knowledge, the program aims to maximize the value derived by all delegates. Active feedback and discussion are encouraged throughout the interactive sessions, which go beyond simple factual presentation to foster engagement.

The primary goal is to ensure that upon completion, all participants are significantly better equipped to address client requirements and contextualize the services and markets in which they operate and participate.

This instructor-led live training in Kenya (online or onsite) is designed for 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 Kenya (online or onsite) is designed for 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 Kenya (online or onsite) is designed for advanced-level cloud financial management professionals aiming to validate their expertise in financial operations (FinOps) related to cloud cost management.

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

• Acquire the advanced knowledge necessary for the FinOps Certified Professional exam.
• Comprehend complex FinOps practices, such as cost optimization, budget management, and reporting.
• Develop practical skills for applying FinOps strategies in real-world scenarios.
• Prepare effectively for a successful pass of the FinOps Certified Professional exam.

Introduction to Structured Products

This course aims to equip participants with a foundational understanding of structured products within the investment banking sector. Upon completing the programme, attendees will possess practical knowledge that enables them to address the following key questions:

1. What constitutes a structured product?
2. What are the motivations for issuing them?
3. How do both issuers and investors derive benefits?
4. What methodologies are used to structure and price various derivative products?
5. What risks and costs are associated with creating structured financial products?
6. What are embedded derivatives?
7. What defines exotic options?
8. What considerations are critical for pricing and hedging?

This instructor-led live training (onsite or remote) is tailored for accountants and bookkeepers looking to utilize Xero for their bookkeeping needs.

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

• Gain real-time insights into cash flow.
• Link bank accounts to Xero to facilitate bank reconciliation.
• Prepare and verify VAT (Value Added Tax) returns within Xero.
• Generate reports for seamless sharing among team members.

This instructor-led, live training in Kenya (online or onsite) is aimed at beginner-level non-finance professionals who wish to have a foundational understanding of financial and accounting principles that are essential for effective decision-making in business.

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

• Understand basic financial and accounting concepts that are essential for business decision-making.
• Interpret and analyze financial statements such as 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.
• Use break-even analysis to support operational and strategic decisions.

This instructor-led live training, offered either online or onsite, is targeted at developers who wish to employ the Open Bank Project API to develop and test decentralized 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 Kenya (online or onsite) is designed for 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 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.