Financial Analysis in Excel Training Course

Target Audience

This course is designed for all senior management personnel who require a practical understanding of AML/CTF frameworks and their prevention methods, as well as awareness of current and relevant financial crime issues.

Course Format

The learning experience combines the following elements:

• Facilitated Discussions
• Slide Presentations
• Case Studies
• Real-world Examples

Learning Objectives

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

• Explaining methods for preventing AML and CTF activities.
• Gaining insight into the key components of AML and CTF relevant to their organizations, as well as national and international efforts to combat these crimes.
• Defining the protective measures companies and their staff should adopt against the risks of money laundering and terrorist financing.
• Identifying how companies may become targets for money laundering and terrorist financing, and explaining which 'red flags' can assist in identifying, preventing, and reporting any suspicious or confirmed criminal activity.
• Understanding key areas of concern within financial crime.

Finance / Management

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

The Cost Center module provides essential routines and best practices for managing overhead, calculating Bills of Materials (BOM) costs, and determining product-level expenses across manufacturing and service sectors.

This instructor-led, live training (available online or onsite) is designed for intermediate-level practitioners looking 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 delivers a comprehensive examination of institutional due diligence frameworks tailored for financial organizations, blending regulatory, financial, operational, and ethical aspects of compliance. It links Common Reporting Standard (CRS) mandates with extensive due diligence components 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 establish a unified due diligence program that aligns with international best practices and local regulatory standards.

After completing this training, participants will be equipped to:

• Grasp and apply due diligence principles across institutional, financial, legal, and operational areas.
• Execute due diligence processes aligned with CRS and FATCA for tax-residency verification and reporting.
• Incorporate governance, ESG, and business integrity measures into compliance systems.
• Build risk-based due diligence frameworks encompassing management, marketing, and IT functions.
• Readiness 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.

Course Customization Options

• For customized training requests, please contact us to arrange.

This instructor-led live training in South Korea (online or onsite) targets finance and legal professionals eager to learn the principles and practices of non-judicial and judicial collection, equipping them to effectively manage and resolve debt issues.

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

• Understand the advantages and disadvantages of non-judicial and judicial collection.
• Apply the core methods and techniques of both collection types.
• Evaluate the effectiveness and efficiency of each approach.
• Address the legal and ethical issues inherent in non-judicial and judicial collection.
• Integrate non-judicial and judicial collection into a comprehensive and coherent strategy.

The Common Reporting Standard (CRS) is the OECD's framework for the automatic exchange of financial account information across jurisdictions. It aims 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 both online and onsite—is designed for intermediate-level compliance and operations professionals. Participants will learn to implement robust CRS-focused policies, conduct accurate tax-residency due diligence, and align their internal processes with reporting requirements similar to those of FATCA.

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

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

Course Format

• Interactive lectures and discussions.
• Practical exercises and template-based labs, including self-certification reviews and indicia assessments.
• Hands-on implementation examples for integrating CRS into onboarding and reporting systems.

Customization Options

• For a customized version of this course (covering jurisdiction-specific rules, system integration, or deeper FATCA comparisons), please contact us to arrange.

This instructor-led, live training (online or onsite) is aimed at 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.

This instructor-led, live training in South Korea (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, first-class working knowledge of essential financial markets, including their purposes, functions, primary activities, and regulatory frameworks. Designed as a blend of refresher, educational, and challenging content, it aims to maximize the value for all attendees. Interactive feedback and discussion are actively encouraged throughout the sessions, which are designed to be engaging and dynamic rather than purely reactive or factual.

The primary objective is to ensure that upon completion, all delegates are significantly better equipped to address client needs and contextually understand the services and markets in which they operate and participate.

This instructor-led live training in South Korea (online or onsite) targets cloud administrators, cloud architects, technology leaders, and financial analysts who want to record, manage, monitor, and process their organization’s financial assets in the cloud.

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

This instructor-led, live training in South Korea (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 South Korea (online or on-site) is designed for advanced-level 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 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, available on-site or remotely, is tailored for accountants and bookkeepers seeking to utilize Xero for bookkeeping purposes.

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

• Obtain a real-time perspective on 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 South Korea (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.