A Power Query course on genuinely messy data

Try a free Power Query lessonSee all three courses

The free lesson is a real question in the room the course teaches in. No sign-up.

What you learn

• Connecting to files, folders and tables
• Cleaning and shaping data that arrives wrong
• Splitting, merging and appending queries
• Custom columns and the M language
• Error handling and managing a query
• Refreshable, reusable processes — and AI with Power Query

The course, chapter by chapter

35 lessons, each ending in practice you do yourself — easy, medium, then hard.

• Power Query basics3 lessons
• Cleaning data8 lessons
• Text transformations3 lessons
• Dates & calculations6 lessons
• Append1 lesson
• Merge3 lessons
• Folder combining3 lessons
• Error handling & query management3 lessons
• Automation & refresh3 lessons
• Final project2 lessons

How a lesson works

• The question comes first. Every lesson opens with something a manager would actually ask, not a formula to memorise.
• One slow demonstration. The answer built in front of you, step by step, with the reason for each step.
• Then you do it. On a real query editor in your browser — nothing to install — with the answer checked as you work.
• Guidance at the mistake. A wrong answer is met with the reason it is wrong, never with the answer.

Exam and certificate

The course ends with a practical examination: 20 questions drawn from a larger bank, 15 to pass. Pass it and the certificate carries a QR code anybody can scan to verify it — an employer, a placement cell, a recruiter. Students who join through an institution can have the certificate issued in association with it.

What it costs

Taking more than one course together costs less, and educational institutions are quoted their own rate — ask us.

Questions people ask

Do I need Power Query installed?

No. The practice runs in the browser, on a phone or a laptop, with nothing to download.

Who is it for?

Anybody who rebuilds the same report by hand every month, and every student who will be handed an export and asked to make sense of it.

How long does it take?

It is self-paced and always open — most learners take an hour a lesson, and there is no batch to wait for.

Is the certificate verifiable?

Yes. Every certificate carries a number and a QR code that resolves to a page on this site showing who earned it, in which course, and when.