Power Query Excel 365

Get, Clean and Transform Data like a Pro in Excel Power Query

Course Summary

 Are you ready to take your data analysis skills in excel to the next level? Do you want to learn how to connect to and transform data like a pro?

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.

This course is a hands-on practical course with workbooks to download and activities to complete

Course Curriculum

Paula Guilfoyle

After over 10 years in Accounting and Operations Paula turned her career to subject matter expert, consultant, content creation and online education. In 2010 Paula began teaching online and can now boast over 250K students in 186 different countries. In 2016 Paula began her learning journey around Blockchain and Cryptocurrency. By 2022 Paula pivoted her consultancy, content creation and online education to focus on Blockchain, Web3 and Digital Assets.

John Smith

Developer

Highly Recommended Course. Easy to Understand, Informative, Very Well Organized. The Course is Full of Practical and Valuable for Anyone who wants to Enhance their Skills. Really Enjoyed it. Thank you!!

Course Pricing

  • Power Query
  • 149

    12 Months access to Power Query Excel 365

    Buy Now