# Advanced Excel for Analysts

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

- **Provider:** Afriskora Training Solutions
- **Category:** Data, AI & Digital Skills
- **Duration:** 3 days
- **Formats:** classroom (cities across Africa), live virtual (Zoom/Teams), in-house for teams
- **Certificate:** Afriskora Certificate of Completion, verifiable online
- **Booking:** request dates and a quote; invoice and EFT payment
- **Web page:** https://afriskora.co.za/courses/data-ai-digital/advanced-excel-for-analysts
- **Request dates:** https://afriskora.co.za/request-training?course=advanced-excel-for-analysts

## 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

## Learning outcomes

- 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

### Module 1: Formulas that do the work

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

### Module 2: Analysis tools

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

### Module 3: Dashboards and controls

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