KapitalBiz Consulting Course
Advanced Data Analytics Course
- Date 19 – 21 June
- Format Live Online Training
- 12 Lessons
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.
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

Predictive Maintenance & Reliability Course
12 – 14 June
Live Online Training
Share

Finance for Engineers & Technical Managers
24 – 26 April
Live Online Training
Share