This course has been designed to take you from a beginner Power Query user to an advanced user in no time. Power Up on your Power Query Skills today.
In this course, we will first give you Your first look at Power Query and connecting to data sources. From there we will move into combining data and simple transformations, such a merge and append. We will look in detail at row and column transformations and then we will deep dive into table transformations.
After this, we will move on to more advanced power query. We will learn how to use Power Query to add new columns to our data and we will then Connect and Transform More Complex Data Structures. Finally, we will then introduce you to the powerful M code that runs power query and you will learn how to use parameters and create custom functions
- Learn how to transform and clean data using Excels Power Query
- Learn how to navigate Power Query and Connect to data sources
- Learn how to work with column, row and table transformations
- Get an introduction to M
- Learn how to use parameters and custom functions
So if you are interested in learning more, why don’t you hop into the preview section and take a look.
This course is a hands-on practical course with workbooks to download and activities to complete