Financial Analysis in Excel Training Course

Audience

All senior management requiring a working knowledge of AML and CTF prevention, along with an awareness of other relevant and current financial crime issues.

Course Format

A combination of:

• Facilitated discussions
• Slide presentations
• Case studies
• Practical examples

Course Objectives

By the end of this course, delegates will be able to:

• Explain how AML and CTF can be prevented
• Understand the key aspects of AML and CTF as they apply to their organisations, including national and international efforts to combat these crimes
• Define the measures companies and staff should adopt to protect themselves against the risks of money laundering and terrorist financing
• Detail how a company might become a target for money laundering and terrorist financing, and identify the "red flags" that help detect, prevent, and report any suspicious or actual criminal activity
• Understand some of the other emerging "hot spots" in financial crime

Finance / Management

This instructor-led, live training (online or on-site) 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 overheads, calculating BOM costs, and determining product-level costing across manufacturing and service operations.

This instructor-led, live training (online or on-site) 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 provides a thorough overview of institutional due diligence frameworks for financial institutions, combining regulatory, financial, operational, and ethical dimensions of compliance. It integrates Common Reporting Standard (CRS) requirements with broader due diligence modules covering management, governance, technology, and business operations.

This instructor-led, live training (delivered either online or on-site) is designed for intermediate-level compliance, risk, and operations professionals who wish to implement a holistic due diligence programme aligned with international best practices and jurisdictional standards.

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

• Understand and apply due diligence principles across institutional, financial, legal, and operational domains.
• Implement CRS and FATCA-aligned due diligence for tax-residency verification and reporting.
• Integrate governance, ESG, and business integrity measures into compliance systems.
• Develop risk-based due diligence frameworks that include 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 Customisation Options

• To request a customised training session for this course, please contact us to arrange.

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

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

• Understand the strengths and limitations of extrajudicial and judicial collection.
• Apply the key methods and techniques of extrajudicial and judicial collection.
• Evaluate the effectiveness and efficiency of extrajudicial and judicial collection.
• Address the legal and ethical issues associated with extrajudicial and judicial collection.
• Integrate extrajudicial and judicial collection in a comprehensive and coherent manner.

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 (delivered online or on-site) is aimed at intermediate-level compliance and operational professionals seeking to implement robust CRS-focused policies, conduct 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.

Course Format

• Interactive lectures and group discussions.
• Practical exercises and template-based labs (self-certification review, indicia assessment).
• Hands-on implementation examples for operationalising CRS within onboarding and reporting systems.

Course Customisation Options

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

This instructor-led, live training (delivered online or on-site) is designed for managers who wish to identify and reduce the risk of fraud faced by eCommerce businesses.

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

• Understand how eCommerce fraud occurs.
• Analyse vulnerabilities in their organisation's eCommerce platform and processes.
• Assess an organisation's 'readiness' for adopting new anti-fraud measures.
• Communicate and implement appropriate anti-fraud policies.

Course Format

• Interactive lecture and discussion.
• Abundant exercises and practice opportunities.
• Hands-on implementation within a live-lab environment.

Course Customisation Options

• To request a customised training session for this course, please contact us to arrange.

This instructor-led, live training in New Zealand (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:

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

This introductory course is designed to equip participants with first-class, detailed working knowledge of key financial markets, including their purpose, function, main activities, and regulatory frameworks. The programme blends refresher content, educational depth, and challenging insights to ensure all delegates derive maximum benefit. Active feedback and discussion are encouraged throughout, fostering an interactive rather than purely reactive and factual learning environment.

Upon completion, the primary aim is that all course delegates will be significantly better equipped to engage with clients and their evolving needs, while also placing the services and markets in which they operate and participate into a clear, practical context.

This instructor-led live training in New Zealand (online or onsite) is aimed at cloud administrators, cloud architects, technology heads, and financial analysts who wish to record, manage, monitor, and process financial assets of an organisation in the cloud.

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

This instructor-led, live training in New Zealand (online or on-site) is aimed at intermediate-level finance professionals who wish to gain comprehensive knowledge of FinOps principles and methodologies, including cloud financial management, optimisation 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 across finance, engineering, and business units to align cloud spend.
• Use FinOps tools for cost allocation, forecasting, and optimisation.
• Prepare for the FinOps Certified FOCUS Analyst exam.

This instructor-led, live training in New Zealand (delivered online or on-site) is designed for advanced-level cloud financial management professionals seeking to validate their expertise in financial operations (FinOps) related to cloud cost management.

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

• Acquire the advanced knowledge required to sit the FinOps Certified Professional exam.
• Understand complex FinOps practices, including cost optimisation, budget management, and reporting.
• Develop practical skills in applying FinOps strategies to real-world scenarios.
• Prepare effectively for successful completion of the FinOps Certified Professional exam.

This instructor-led, live training (onsite or remote) is aimed at 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 New Zealand (online or on-site) is designed for beginner-level non-finance professionals who wish to gain a foundational understanding of the financial and accounting principles essential for effective business decision-making.

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

• Understand core financial and accounting concepts critical to business decision-making.
• Interpret and analyse financial statements, including 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.