Home / Masterclasses / Data Science & Analytics / B5

Stream B · Data Science & Analytics · 5 days · QCTO-aligned

Applied Data Analytics Using Spreadsheets & Visual Tools

For professionals who work with data daily: pivot tables, VLOOKUP, conditional formatting, basic statistics in Excel and an introduction to Power BI concepts — using a real dataset from your sector.

Who it is for

Administrators, finance clerks, HR officers, supply-chain and operations staff who live in Excel and want to get far more from it.

By Monday morning you will be able to

  • Use pivot tables, lookups and conditional formatting to analyse thousands of rows in minutes
  • Apply basic statistics in Excel to spot trends, variances and exceptions
  • Connect a dataset to Power BI and build a first interactive report
  • Automate a recurring monthly report you currently rebuild by hand

At a glance

Duration
5 days — live sessions Tuesday to Thursday, guided remote work on the other days

Delivery
In-person in Sandton, at your site anywhere in South Africa, or live online across the SADC region. Blended programmes for teams.

Next open intake
Second Tuesday of every month

Investment
Quoted on request. Individual and group cohort (6–50) quotes within 48 hours. SETA discretionary-grant claimable for South African employers.

Accreditation
Mapped to modules of the Data Science Practitioner (SAQA 118708) qualification. QCTO Accreditation No. 03-QCTO/SDP 180124083634.

Certificate
IALE Institute Certificate of Completion

Book your seat →

Built for Southern Africa

Cases from the sectors you work in

Sector-neutral, region-specific

Every exercise draws on mining, financial services, manufacturing, healthcare, education, retail and public administration cases from South Africa and the wider SADC region.

Your data, your problems

Group cohorts bring their own datasets, processes and policies. You leave with work done, not a workbook.

Regulation built in

POPIA, the Cybercrimes Act, PFMA/MFMA and sector rules are handled inside the content, not as an afterthought.

Facilitators who have shipped

Led by practitioners who have designed and rolled out digital and AI projects for government, mining and financial-services clients for over a decade.

Frequently asked

Questions about Applied Data Analytics Using Spreadsheets & Visual Tools

How long is the Applied Data Analytics Using Spreadsheets & Visual Tools masterclass?

5 days. Live workshop sessions run Tuesday to Thursday; the remaining days are guided remote work applied to your own organisation.

Is it accredited?

IALE Institute is a QCTO-accredited skills development provider (Accreditation No. 03-QCTO/SDP 180124083634). This masterclass maps to modules of the Data Science Practitioner (SAQA 118708) qualification and carries an IALE Certificate of Completion.

Can it be delivered outside South Africa?

Yes. It is delivered live online to teams anywhere in the SADC region — Botswana, Namibia, Zambia, Zimbabwe, Mozambique, Malawi, Lesotho, Eswatini and beyond — and in-person at your site on request.

What does it cost?

Fees are quoted on request. Individual and group cohort (six to fifty) quotes are issued within 48 hours, and SETA discretionary-grant funding applies for South African employers.

When is the next intake?

Open intakes start on the second Tuesday of every month. Corporate cohorts are scheduled to suit the client.

Related

Other masterclasses in Data Science & Analytics

See all 31 masterclasses →   AI training by country