Stop rebuilding the same reports every month. This course teaches your team to use Power Query to connect, clean and combine data from multiple sources, then refresh it all with one click.
By the end of this course, your team will be able to:
Prerequisite:
Participants should have completed our Advanced Excel course or work at that level. No Power Query experience is needed.
This course suits teams that spend hours copying, pasting and cleaning data before they can report on it. It’s ideal for:
Participants should be confident Excel users at Advanced level. If your team isn’t there yet, start with our Advanced Excel course.
No. Power Query is built into Microsoft 365 and recent versions of Excel for Windows.
Yes. We can build examples around your team’s own data and reports.
Yes. We run this course live via Microsoft Teams, or onsite at your premises anywhere in Australia.
To keep sessions practical and give everyone time to ask questions, we train up to 15 participants per class from your organisation.
No. Participants should be confident Advanced Excel users; the course starts with the Power Query basics.
