Financial Analysis in Excel Training Course

Audience

Senior management professionals who require a practical understanding of AML and CTF principles, their preventive measures, and an awareness of current and relevant financial crime issues.

Course Format

The course is delivered through a blend of:

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

Course Objectives

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

• Describe methods for preventing AML and CTF violations.
• Grasp the key aspects of AML and CTF as they relate to their organizations, along with national and international efforts to combat these crimes.
• Outline how companies and their employees should safeguard against the risks of money laundering and terrorist financing.
• Explain how organizations may become targets for money laundering and terrorist financing, and identify the "red flags" that aid in detecting, preventing, and reporting suspicious or actual criminal activity.
• Gain insight into other prominent 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 Center module addresses the routines and best practices for managing overhead, calculating Bills of Materials (BOM) costs, and determining product-level costs across both manufacturing and service operations.

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

After completing this course, participants will be able to:

• Create, configure, and maintain cost centers that align 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 center calculations.
• Apply absorption costing principles to ensure accurate 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.

Customization Options

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

This course delivers a thorough examination of institutional due diligence frameworks designed for financial institutions, merging regulatory, financial, operational, and ethical compliance aspects. It connects Common Reporting Standard (CRS) requirements with extensive due diligence components covering management, governance, technology, and business operations.

This live training, led by an instructor, is available online or on-site. It targets intermediate-level professionals in compliance, risk, and operations who aim to establish a holistic due diligence program aligned with international best practices and local jurisdictional standards.

After completing this training, participants will be capable of:

• Grasping and applying due diligence principles across institutional, financial, legal, and operational areas.
• Executing CRS and FATCA-compliant due diligence for tax residency verification and reporting.
• Incorporating governance, ESG, and business integrity measures into compliance systems.
• Building risk-based due diligence frameworks that encompass management, marketing, and IT functions.
• Preparing 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.

Customization Options

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

This instructor-led live training, available online or on-site, is designed for managers seeking to identify and reduce the fraud risks affecting eCommerce merchants.

Upon completing this training, participants will be capable of:

• Understanding the mechanisms behind eCommerce fraud.
• Analyzing vulnerabilities within their company’s eCommerce platform and operational processes.
• Evaluating the organization's readiness to implement new anti-fraud measures.
• Effectively communicating and integrating appropriate anti-fraud policies.

Course Format

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

Customization Options

• To request a tailored version of this course, please contact us to arrange.

This foundational course offers participants a comprehensive and practical understanding of essential financial markets, including their objectives, functions, core activities, and regulatory frameworks. Designed to serve as both a refresher and an educational challenge, the program ensures that all attendees gain maximum value from the experience. Active feedback and discussion are encouraged throughout the sessions, which are crafted to be interactive and engaging rather than merely reactive or factual.

Upon completion, delegates will be significantly better equipped to address client needs effectively and to contextualize the services and markets in which they operate and participate.

This instructor-led live training in Mexico (online or onsite) is designed for cloud administrators, cloud architects, technology leaders, and financial analysts who wish to record, manage, monitor, and process their organization's financial assets within the cloud.

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

This instructor-led, live training in Mexico (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 conducted in Mexico (online or onsite) targets advanced-level cloud financial management professionals who want to validate their expertise in financial operations (FinOps) related 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 examination.
• Comprehend complex FinOps practices, such as cost optimization, budget management, and reporting.
• Develop practical abilities in applying FinOps strategies to real-world situations.
• Prepare effectively to successfully pass the FinOps Certified Professional exam.

Introduction to Structured Products

This course is designed to give participants an overview of the structured products utilized in investment banking. Upon finishing the program, attendees will gain practical knowledge of the topic and be equipped to address the following key questions:

1. What defines a structured product?
2. What are the reasons for issuing them?
3. How do both issuers and investors derive value from them?
4. What is the process for structuring and pricing various derivative products?
5. What risks and costs are associated with creating structured financial instruments?
6. What constitutes embedded derivatives?
7. What are exotic options?
8. What considerations apply to pricing and hedging?

This instructor-led live training (on-site or remote) is tailored for accountants and bookkeepers aiming to use Xero for bookkeeping.

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

• Obtain real-time visibility of cash flow.
• Link bank accounts to Xero for reconciliation purposes.
• Prepare and review VAT (Value Added Tax) returns in Xero.
• Create reports for sharing with team members.

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

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 in Mexico (online or onsite) is aimed at developers who wish to use 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 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 Mexico (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 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.