Skip to content

Advanced Data Analytics Course

About This Class

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

Book my seat

Share

Download Brochure

Day 1

01 Cleaning of data
02 Solver, Goal Seek
03 Scenario Planning
04 Information functions and Text functions

Day 2

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

Day 3

01 Maths functions (including SUMIF and SUBTOTAL)
02 Date and time functions
03 Useful tools and shortcuts
04 Formula auditing and evaluating formulas

Who should attend

This 3-day training course is specifically designed for:

Expert Trainer

The trainer for this course is a Chartered Accountant (SA), Associate Chartered Management Accountant, Chartered Global Management Accountant, with strong academic and industry experience. She holds a Master’s degree in Management Accounting and has more than nine years of lecturing experience at the University of Pretoria and North-West University respectively, for which she has received distinctive teaching awards.

As a lecturer, she specialised in Management Accounting, Costing, Financial Management and Business Strategy to students of various levels. This is besides providing business simulations, supervising research projects and external moderation and reviewing of other universities’ exam papers and study guides.

She has been delivering training to both government institutions and private sector companies in similar subject areas, including Microsoft Excel, financial and business skills training, as well as consultation in fields related to financial modelling in Excel, optimising power tools in Excel and Power BI. 

Recommended Courses

Mini-MBA in Management Accounting

10 – 12 June 2024

Live Online Training

Data Visualization Masterclass

10 – 12 April

Live Online Training

Financial Analysis & Forecasting

22 – 24 May

Live Online Training