Financial Analysis in Excel Training Course

Audience

Senior Management personnel who require a practical understanding of AML/CTF frameworks, their preventive measures, and an awareness of contemporary financial crime issues;

Course Format

The session integrates:

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

Course Objectives

Upon completion, participants will be able to:

• Outline methods for preventing AML and CTF violations
• Grasp the core components of AML and CTF as they relate to their organisations, alongside national and global initiatives to combat these threats
• Specify the protective measures companies and staff must adopt against Money Laundering and Terrorist Financing risks
• Identify how organisations may become targets for Money Laundering and Terrorist Financing, and describe the 'red flags' used to detect, prevent, and report suspicious or confirmed criminal activity
• Gain insight into other prominent areas of Financial Crime

Finance / Management

This instructor-led live training (online or onsite) is designed for manufacturing managers and engineers seeking 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, construct complete CAPEX investment cases including cash flow projections and sensitivity analysis, utilise templates and Capex Cards to streamline the approval process, and prepare clear executive-level narratives to justify capital expenditure requests.

The Cost Center module encompasses the routines and best practices for managing overheads, calculating Bill of Materials (BOM) costs, and determining product-level costing across both manufacturing and service operations.

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

Upon 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.

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 tailored for financial institutions, blending regulatory, financial, operational, and ethical aspects of compliance. It aligns Common Reporting Standard (CRS) requirements with broader due diligence modules covering management, governance, technology, and business operations.

Delivered as an instructor-led live training session (available online or onsite), this programme targets intermediate-level professionals in compliance, risk, and operations who aim to implement a holistic due diligence programme 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 that encompass 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 a customized training for this course, please contact us to arrange.

This instructor-led live training in Malaysia (online or onsite) is designed for finance and legal professionals who wish to learn the principles and practices of extrajudicial and judicial collection, enabling them to effectively manage and resolve collection 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.

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

This instructor-led, live training (online or onsite) is aimed at 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 the CRS due diligence procedures (including indicia searches and self-certification handling) to identify reportable accounts accurately.
• 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 (online or onsite) is aimed at managers who wish to identify and minimise 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 instructor-led, live training in Malaysia (online or onsite) is aimed at financial professionals in US and non-US institutions who wish to understand the legal, compliance and enforcement aspects of FATCA so as to maintain compliance with US tax authorities (IRS).

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

• FATCA's impact on global tax compliance and financial transparency.
• FATCA's due diligence and reporting requirements.
• FATCA's most important legal aspects and how to ensure compliance.

This introductory course offers participants a comprehensive and practical understanding of key financial markets, including their objectives, functions, core activities, and regulatory frameworks. Designed as a blend of refresher, educational, and challenging content, it aims to maximize the value delivered to every delegate. Active feedback and discussion are encouraged throughout the interactive sessions, which go beyond mere facts to foster deeper engagement.

Upon completion, delegates will be significantly better equipped to address client needs, contextualize the services and markets in which they operate, and navigate their participation with greater confidence.

This guided, live training in Malaysia (available online or on-site) targets cloud administrators, architects, technology leaders, and financial analysts who aim to record, manage, monitor, and process organizational financial assets within the cloud.

By the conclusion of this training, participants will be capable of leveraging FinOps practices to forecast costs, optimize workflows, and conduct financial management operations in cloud environments.

This instructor-led, live training in Malaysia (online or onsite) targets intermediate-level finance professionals seeking comprehensive knowledge of FinOps principles and methodologies. Key areas include cloud financial management, optimisation strategies, and cross-functional collaboration among finance, engineering, and business teams.

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

• Grasp the FinOps framework, principles, and phases.
• Manage cloud costs efficiently via data analysis and governance.
• Collaborate across finance, engineering, and business units to harmonise cloud expenditure.
• Employ FinOps tools for cost allocation, forecasting, and optimisation.
• Prepare for the FinOps Certified FOCUS Analyst exam.

This instructor-led, live training in Malaysia (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.

Upon completion of this training, participants will be capable of:

• Gaining the advanced knowledge necessary for the FinOps Certified Professional exam.
• Understanding complex FinOps practices, encompassing cost optimization, budget management, and reporting.
• Developing practical skills in applying FinOps strategies to real-world scenarios.
• Preparing effectively to successfully complete the FinOps Certified Professional exam.

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

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

• Access real-time cashflow data.
• Link bank accounts to Xero for effective reconciliation.
• Prepare and validate VAT (Value Added Tax) returns in Xero.
• Create reports for distribution among team members.

This instructor-led, live training in Malaysia (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.