Financial Analysis in Excel Training Course

Target Audience

Senior management personnel who require a practical understanding of AML/CTF principles, their prevention, and awareness of current relevant Financial Crime issues;

Course Format

The course comprises a mix of the following elements:

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

Course Objectives

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

• Explain methods for preventing AML and CTF activities
• Comprehend the key aspects of AML and CTF as they pertain to their organisations, as well as national and international efforts to combat these crimes
• Define how an organisation and its employees should safeguard against the risks associated with Money Laundering and Terrorist Financing
• Detail how an organisation may become a target for Money Laundering and Terrorist Financing, and explain which 'red flags' can assist in identifying, preventing, and reporting any (suspicious or confirmed) criminal activity
• Understand certain other 'hotspots' within Financial Crime

The course 'Fundamentals of Financial Markets: A Banking Overview' enables an understanding of the structure of financial markets, retail banking, and investment banking. Participants will gain basic theoretical knowledge useful for projects related to this area. The course covers key terminology, the functions of financial markets, various types of banks, and financial instruments.

Finance / Management

This instructor-led, live training (online or onsite) is geared towards manufacturing managers and engineers who wish to enhance their capacity to evaluate investments, develop 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, utilise templates and Capex Cards to streamline the approval process, and prepare clear executive-level narratives to justify capital expenditure requests.

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

This instructor-led, live training (available online or onsite) is designed for 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 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 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 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 an exhaustive examination of institutional due diligence frameworks tailored for financial institutions, seamlessly blending regulatory, financial, operational, and ethical compliance aspects. It harmonises Common Reporting Standard (CRS) requirements with extensive due diligence modules covering management, governance, technology, and business operations.

This instructor-led, live training (available online or onsite) 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:

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

Customisation Options

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

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

The CRS is an OECD standard facilitating the automatic exchange of financial account information between jurisdictions. It aims to curb 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 designed for intermediate-level compliance and operational professionals who wish to implement robust CRS-focused policies, conduct accurate tax-residency due diligence, and align internal processes with reporting requirements similar to FATCA.

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 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 (available online or onsite) 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.

This introductory course offers participants a comprehensive and practical understanding of essential financial markets, including their objectives, functions, key activities, and regulatory frameworks. Designed to serve as both a refresher and an educational challenge, the programme ensures that all delegates gain maximum value. Interactive feedback and discussion are actively encouraged throughout the sessions, which are structured to be engaging and dynamic rather than merely factual or reactive.

Upon completion, all course delegates will be significantly better equipped to address client needs and contextualise the services and markets in which they operate and invest.

This instructor-led live training in Botswana (online or onsite) is tailored for cloud administrators, cloud architects, technology heads, and financial analysts who wish to record, manage, monitor, and process an organization's financial assets in the cloud.

By the end of this training, participants will be able to utilise FinOps practices within an organization to forecast costs, optimise processes, and carry out financial management operations in the cloud.

This instructor-led, live training in Botswana (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 Botswana (online or on-site) is designed for advanced-level cloud financial management professionals who wish to validate their expertise in financial operations (FinOps) relating to cloud cost management.

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

• Acquire the advanced knowledge necessary for the FinOps Certified Professional exam.
• Comprehend complex FinOps practices, including cost optimisation, budget management, and reporting.
• Develop practical skills in applying FinOps strategies to real-world scenarios.
• Prepare 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 Botswana (online or onsite) is designed for beginner-level non-finance professionals who seek a foundational grasp of the financial and accounting principles necessary for effective business decision-making.

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

• Comprehend the basic financial and accounting concepts vital for business decision-making.
• Interpret and analyse financial statements, including income statements, balance sheets, and cash flow statements.
• Apply key financial ratios to evaluate the financial health of a business.
• Develop and manage budgets, and perform variance analysis to monitor business performance.
• Utilise break-even analysis to support operational and strategic decisions.