Master Excel Power Query essentials

The Masterclass covers the essential skills of Power Query. During the session, you'll create powerful queries that update reports with one click of a button (maybe even zero clicks).

You'll learn the fundamentals of using Power Query and develop through the session to fine-tuning your queries for efficiency and to be future proofed. We will add also add some dynamism to the queries so that users can interact and change aspects of a query.

By the end of the session, you will be confident in using Power Query and excited about applying it to your work and taking the next step in your Power Query journey.

The Masterclass will be very practical including all files to work along. It will also include some homework exercises and a challenge to complete after the training to help re-enforce the skills learned.

Who is this for?

For people new or inexperienced with Power Query.

Prerequisites

Excel for Microsoft 365 or a standalone copy installed (preferably Excel 2016 or above).