The Masterclass covers the essential skills of Power Query. During this course, you will create powerful queries that update reports with one click of a button (maybe even zero clicks).
You will learn the fundamentals of using Power Query and throughout the course you will learn to fine-tune your queries for efficiency and to be future proofed. We will also add some dynamism to the queries so that users can interact and change aspects of a query.
By the end of this Masterclass, 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).