Power Query
Automate messy data preparation with repeatable, refreshable ETL workflows.
1 day (7 hours)
KES 15,500
per participant
About this course
Tired of cleaning the same spreadsheet every week? Power Query lets you record data preparation steps once and refresh them with a single click. This focused, one-day course teaches you how to import, clean and combine data from any source — files, folders, databases or the web.
Class goals
- Import data from files, folders, databases and the web
- Clean and transform data with repeatable steps
- Merge and append queries to combine datasets
- Parameterise queries and build reusable functions
- Set up reliable refresh strategies
Course outline
- 1Importing from files, folders & web
- 2Cleaning & transforming data
- 3Merging and appending queries
- 4Parameters & functions
- 5Refresh strategies
Delivery
Live online
Interactive virtual classroom from anywhere.
In person
At our venue, or at your office for corporate groups.
Frequently asked questions
Related courses
More Microsoft & data training delivered in Nairobi and live online across Kenya.
- Beginner
Microsoft Excel — Basic
Build a confident foundation: navigate workbooks, format data and write your first formulas.
1 day (7 hours)KES 10,000 - Intermediate
Microsoft Excel — Intermediate
Move beyond the basics with conditional logic, lookups, charts and pivot tables.
2 days (14 hours)KES 15,500 - Advanced
Excel Advanced — Power User
Power user techniques: dynamic arrays, LAMBDA, Solver, VBA automation and decision-ready dashboards.
2 days (16 hours)KES 22,500