Skip to content

KapitalBiz Consulting Course

Advanced Data Analytics Course

Share
In today’s data-driven world, managers need to be able to effectively use data to make informed decisions and drive innovation. This Advanced Data Analytics & Modelling in Excel is a comprehensive and industryrelevant training course that equips managers with the skills and knowledge they need to succeed in this new era of business. Drive data-driven decision-making and transform your business with advanced data analytics skill.

The course consists of a solid principle-based grounding, followed by a wealth of practical examples, case studies and exercises. The exercises can either be done on Excel or manually, and will form a portfolio of examples to which delegates can refer back to.

The focus is on time-savers and other techniques which will improve the quality of your financial models.

Local Fee R 17,999

International Fee $ 1,300

What it’s all about

Why you should attend

▪ Cleaning of data
▪ Solver, Goal Seek
▪ Scenario Planning
▪ Information functions and Text functions

▪ Financial functions (IPMT, PPMT, NPV, IRR XNPV, XIRR)
▪ Data validation and protection
▪ Statistical analysis and sample tools
▪ Logical functions (including nested IF statements)

▪ Maths functions (including SUMIF and SUBTOTAL)
▪ Date and time functions
▪ Useful tools and shortcuts
▪ Formula auditing and evaluating formulas

Ideal Participants for This Program

Who should attend

This 3-day training course is specifically designed for:

  • CFOs, Finance Directors, Financial Controllers
  • Finance Managers, Financial Analysts, Data Analysts
  • Supply Chain Managers, Procurement & Logistics Managers
  • Corporate Bankers, Business Development Analysts, HR, Marketing
  • Any general users of Excel for financial applications & finance function

Book Your Spot

Advanced Data Analytics Course

Recommended Courses

Project Portfolio Management

3 – 6 June

NH Hotel Sandton / Live Online

Predictive Maintenance & Reliability Course

12 – 14 June

Live Online Training

Finance for Engineers & Technical Managers

24 – 26 April

Live Online Training