Skip to content

Excel Power Query and Data Cleaning for Analysts

Analysts across African organisations still spend hours manually reshaping messy spreadsheets before any analysis can begin. This course teaches repeatable data cleaning and transformation using Power Query and advanced Excel features. Participants learn to turn inconsistent source files into reliable, refreshable datasets ready for reporting.

Ready to book? Secure your place on this programme.

Register for this course

What you will be able to do

  • Connect Power Query to files, folders and databases as data sources.
  • Clean and reshape messy data through repeatable transformation steps.
  • Combine data from multiple sources using merges and appends.
  • Build refreshable queries that update when source data changes.
  • Apply data modelling techniques to support flexible analysis.
  • Document transformations so others can maintain and trust the work.

Course outline

  1. 01Data Cleaning Challenges
  2. 02Connecting to Data Sources
  3. 03Transforming and Reshaping Data
  4. 04Merging and Appending Sources
  5. 05Building Refreshable Queries
  6. 06Data Modelling in Excel
  7. 07Documentation and Maintenance
  8. 08From Clean Data to Reporting

Who should attend

Analysts, finance staff, administrators and managers who prepare and report on data using Excel.

Dates, venues and fees

DatesVenueDaysFeeCalendarRegister
28 to 29 Sep 2026Mauritius2US$1,100Closed
29 to 30 Sep 2026Dubai2US$1,100Register
30 Sep to 1 Oct 2026Online2US$900Register
11 to 12 Nov 2026Johannesburg2R10,000Register
12 to 13 Nov 2026Cape Town2R10,000Register
16 to 17 Nov 2026Durban2R10,000Register
17 to 18 Nov 2026Pretoria2R10,000Register
18 to 19 Nov 2026Windhoek2US$1,100Register
19 to 20 Nov 2026Gaborone2US$1,100Register
23 to 24 Nov 2026Maseru2US$1,100Register
24 to 25 Nov 2026Mbabane2US$1,100Register
25 to 26 Nov 2026Lusaka2US$1,100Register
26 to 27 Nov 2026Harare2US$1,100Register
30 Nov to 1 Dec 2026Lilongwe2US$1,100Register
1 to 2 Dec 2026Blantyre2US$1,100Register
2 to 3 Dec 2026Mozambique2US$1,100Register
3 to 4 Dec 2026Nairobi2US$1,100Register
7 to 8 Dec 2026Dar es Salaam2US$1,100Register
8 to 9 Dec 2026Kigali2US$1,100Register
9 to 10 Dec 2026Kampala2US$1,100Register
10 to 11 Dec 2026Accra2US$1,100Register
14 to 15 Dec 2026Lagos2US$1,100Register
17 to 18 Dec 2026Cairo2US$1,100Register

Fees are per delegate. South African venues are priced in rand; other locations and online in US dollars. Fees exclude 15% VAT where applicable. Group bookings of three or more delegates from the same organisation qualify for a reduced rate; contact us for a quotation.

Related courses in Data, Digital and Cyber Security

Data, Digital and Cyber Security

Cyber Security Fundamentals for Business Teams

Most breaches begin with an ordinary employee making a reasonable decision on incomplete information.

Next session
29 Sep to 1 Oct 2026
Venue
Mbabane
3 day programme
FromR13,000
Data, Digital and Cyber SecurityNew

Artificial Intelligence for Business Managers

Artificial intelligence has moved from novelty to something managers are expected to have an opinion on.

Next session
29 Sep to 1 Oct 2026
Venue
Maseru
3 day programme
FromR13,000
See all Data, Digital and Cyber Security courses