Financial Analysis in Excel Training Course

Target Audience

Senior leaders who require a practical understanding of AML/CTF frameworks and preventive measures, along with awareness of other pertinent and emerging Financial Crime challenges;

Course Delivery Method

The training integrates multiple approaches:

• Guided group discussions
• Presentation slides
• Real-world case studies
• Practical examples

Learning Objectives

Upon completing this course, participants will be equipped to:

• Describe methods for preventing AML and CTF activities
• Grasp the key components of AML and CTF as they relate to their organizations, alongside national and global initiatives aimed at combating these issues
• Outline strategies for companies and employees to mitigate risks associated with Money Laundering and Terrorist Financing
• Explain how organizations may attract Money Laundering and Terrorist Financing activities, and identify key 'red flags' to detect, prevent, and report suspicious or confirmed criminal behavior
• Gain insight into other significant 'hotspots' within Financial Crime

Finance / Management

This live, instructor-led training (online or onsite) is aimed at manufacturing managers and engineers who wish to enhance 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 covers routines and practices for managing overhead, 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 center routines within enterprise environments.

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

• Create, configure, and maintain cost centers 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 center 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 course offers a thorough overview of institutional due diligence frameworks designed for financial institutions, merging regulatory, financial, operational, and ethical compliance aspects. It combines Common Reporting Standard (CRS) requirements with extensive due diligence modules covering management, governance, technology, and business operations.

This live, instructor-led training (available online or onsite) targets intermediate-level compliance, risk, and operations professionals aiming to implement a holistic due diligence program that aligns 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 areas.
• Implement due diligence aligned with CRS and FATCA for verifying and reporting tax residency.
• 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.
• Hands-on practice using mock due diligence documentation and workflows.

Course Customization Options

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

This instructor-led, live training in Brazil (online or onsite) is designed for finance and legal professionals aiming to master the principles and practices of extrajudicial and judicial collection, empowering them to effectively manage and resolve collection challenges.

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

• Grasp the pros and cons of both extrajudicial and judicial collection.
• Implement key methods and techniques for extrajudicial and judicial collection.
• Assess the effectiveness and efficiency of extrajudicial and judicial collection efforts.
• Navigate the legal and ethical considerations associated with extrajudicial and judicial collection.
• Seamlessly integrate extrajudicial and judicial collection strategies into a cohesive framework.

This instructor-led live training, available online or onsite, is designed for managers seeking to identify and reduce 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 processes.
• Evaluating an 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 practice.
• Hands-on implementation within a live lab environment.

Customization Options

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

This introductory course offers participants a comprehensive and practical understanding of key financial markets, including their objectives, functions, primary activities, and regulatory frameworks. Designed as a blend of refresher, educational, and challenging content, it ensures that all delegates gain maximum value. Active feedback and discussion are encouraged throughout the interactive sessions, which go beyond mere facts to foster engagement.

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

This instructor-led live training, held in Brazil (either online or onsite), is tailored for cloud administrators, cloud architects, technology leaders, 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 Brazil (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 Brazil (online or on-site) is designed for advanced cloud financial management professionals who want 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 the advanced knowledge required for the FinOps Certified Professional exam.
• Understand complex FinOps practices, including cost optimization, 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) targets accountants and bookkeepers who wish to use Xero for bookkeeping.

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

• Get a real-time view of cashflow.
• Link bank accounts to Xero for bank reconciliation.
• Prepare and check VAT (Value Added Tax) returns in Xero.
• Create reports for sharing amongst team members.

This instructor-led, live training in Brazil (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 in Brazil (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 Brazil (online or onsite) is targeted at application consultants and business process owners who wish to acquire skills in configuring business processes for the SAP S/4 HANA financials module.

By the conclusion 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.