Skip to content
info@afriskora.co.za
Afriskora Training Solutions
Data, AI & Digital Skills

Advanced Excel for Analysts

Master formulas, PivotTables, Power Query and dashboards to analyse data faster and with fewer errors.

  • 3 days
  • Classroom · Live virtual · In-house
  • Afriskora Certificate of Completion

Course overview

Excel remains the everyday analysis tool in most African organisations. This course takes confident users to an advanced level: dynamic formulas, PivotTables, Power Query for cleaning data and interactive dashboards. Participants work on realistic finance, HR and operations datasets and leave with templates they can reuse.

Who should attend

  • Finance, HR and operations staff
  • Analysts and report writers
  • Administrators who manage data
  • Anyone who uses Excel daily

What you will be able to do

  • Use lookup, logical and dynamic array formulas
  • Summarise data with PivotTables and PivotCharts
  • Clean and combine data with Power Query
  • Build interactive dashboards
  • Reduce errors with validation and checks

Course outline

  1. Module 1Formulas that do the work

    • • XLOOKUP and INDEX/MATCH
    • • IF, IFS and nested logic
    • • Dynamic arrays and FILTER
    • • Named ranges and tables

  2. Module 2Analysis tools

    • • PivotTables and slicers
    • • Power Query for data cleaning
    • • Combining multiple files
    • • What-if analysis

  3. Module 3Dashboards and controls

    • • Dashboard design
    • • Conditional formatting
    • • Data validation and protection
    • • Dashboard project

Frequently asked questions

How long is the Advanced Excel for Analysts course?

The course runs for 3 days. Daily start and finish times are confirmed in your joining instructions. Live virtual sessions cover the same programme.

Do I receive a certificate?

Yes. Every participant who completes the course receives an Afriskora Certificate of Completion with a unique code that employers can verify online.

Can this course be delivered in-house for our team?

Yes. We can run it at your premises or online for your team, on dates that suit you, and adapt examples and case studies to your sector.

How do I book and pay?

Request dates and we'll send available sessions and a quote. Bookings are confirmed by invoice and paid by EFT. South African clients can include the course in their Workplace Skills Plan.

Related courses