Power Query, or Get & Transform, is Excel’s data management tool, which is used to, among other things, import, process, and combine data. You will learn how to organise and analyse data, and manage large databases professionally, which will become a huge time saver at work.
Learn how to retrieve or “Get” data from the many different available sources, such as Excel files, other local files, or real-time data from the internet.
Working with formulas, combining queries, and making connections (“Joins”) to combine data is Power Query’s livelihood. Learn to do all this and much more!
Learn how to transform data to suit the way you display information and insights. After the course, you will be able to normalise and merge columns and queries to make your data more accessible.
“Joining” is used to combine data in many different ways, such as Inner Join, Left Join, and Full Outer Join!
Power Query, or “Get and Transform”, is Excel’s data management tool used, among other things, to import, process and combine data. Power Query gives us access to data from several different data sources. In this course we go through Power Query’s basic functions, and how we can apply them to different situations. After each lesson you’ll be asked to take a quiz to test your knowledge. Navigate further down to see which chapters and lessons are included in the course.
Prices excluding VAT
