Financial Analysis in Excel Training Course

Target Audience

This course is designed for all Senior Management personnel requiring a practical understanding of AML and CTF frameworks and their preventive measures, alongside an awareness of contemporary and pertinent Financial Crime challenges.

Course Structure

The session employs a blended approach consisting of:

• Guided Discussions
• Slide-Based Presentations
• Analytical Case Studies
• Practical Examples

Learning Objectives

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

• Articulate methods for preventing AML and CTF activities.
• Comprehend the core components of AML and CTF as they relate to their organisations, as well as the national and global initiatives aimed at combating these crimes.
• Specify the measures companies and staff should implement to mitigate the risks associated with Money Laundering and Terrorist Financing.
• Identify how an organisation may become a target for such crimes and explain which 'red flags' can assist in identifying, preventing, and reporting (suspicious or confirmed) criminal behaviour.
• Gain insight into other key 'hotspots' within the Financial Crime landscape.

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 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 centre routines 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 course offers a thorough examination of institutional due diligence frameworks tailored for financial institutions, blending regulatory, financial, operational, and ethical aspects of compliance. It combines Common Reporting Standard (CRS) requirements with broader 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 program aligned 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 domains.
• Implement due diligence processes 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.

Format of the Course

• Interactive lecture and discussion.
• 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.

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

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

• Understand the advantages and disadvantages of extrajudicial and judicial collection.
• Apply the main methods and techniques of extrajudicial and judicial collection.
• Evaluate the effectiveness and efficiency of extrajudicial and judicial collection.
• Deal with the legal and ethical issues involved in extrajudicial and judicial collection.
• Integrate extrajudicial and judicial collection in a comprehensive and coherent way.

The CRS represents the OECD standard for the automatic exchange of financial account information between jurisdictions. It is designed to combat cross-border tax evasion by requiring financial institutions to identify and report accounts held by foreign tax residents.

This instructor-led live training (available online or onsite) is tailored for intermediate-level compliance and operational professionals who wish to implement robust CRS-focused policies, perform accurate tax-residency due diligence, and align internal processes with FATCA-like reporting requirements.

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

• Explain the CRS reporting framework, key definitions, and jurisdictional obligations under the OECD standard.
• Apply CRS due diligence procedures, including indicia searches and self-certification handling, to accurately identify reportable accounts.
• Map and align internal KYC/AML workflows to meet CRS requirements and related FATCA-like obligations.
• Design controls, data workflows, and reporting processes to produce compliant CRS submissions.

Format of the Course

• Interactive lecture and discussion.
• Practical exercises and template-based labs (self-certification review, indicia assessment).
• Hands-on implementation examples for operationalizing CRS in onboarding and reporting systems.

Course Customization Options

• To request a customized version of this course (jurisdiction-specific rules, systems integration, or deeper FATCA comparison), please contact us to arrange.

This instructor-led live training (available online or on-site) 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.

Designed for cloud administrators, cloud architects, technology leaders, and financial analysts, this instructor-led live training in Portugal (online or on-site) equips participants with the skills to record, manage, monitor, and process organisational financial assets within cloud environments.

Upon completion of this training, participants will be adept at applying FinOps methodologies to forecast costs, streamline processes, and execute financial management tasks in the cloud.

This instructor-led, live training in Portugal (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 Portugal (online or onsite) targets advanced cloud financial management professionals who wish 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) is targeted at accountants and bookkeepers who intend to use Xero for their bookkeeping requirements.

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

• Obtain a real-time perspective on cash flow.
• Link bank accounts to Xero to support bank reconciliation.
• Prepare and validate VAT (Value Added Tax) returns in Xero.
• Create reports suitable for distribution among team members.

This instructor-led, live training in Portugal (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 Portugal (online or onsite) is designed for 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 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 Portugal (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 essential customizing settings within the primary components of Financial Accounting using SAP S/4HANA.
• Configure master data settings (G/L accounts, customer, and vendor accounts) for FA in SAP S/4HANA.
• Set up document control, posting control, and financial document clearing settings for FA in SAP S/4HANA.