This course teaches learners how to use Power Query in Microsoft Excel to import, clean, and transform external data efficiently. By the end of the course, students will be able to import data from various sources, manipulate data types, filter and split columns, create new columns, merge tables, and refresh queries. The teaching method involves practical demonstrations and step-by-step guidance. This course is designed for individuals familiar with Excel basics who want to enhance their data manipulation skills using Power Query.
Intermediate Microsoft Excel Tutorial - How to Use Power Query
Overview
Syllabus
Introduction to Power Query in Excel
What is Power Query?
Where do you find Power Query?
How to import data from the web with Power Query
How to import data from a range or table in Power Query
Power Query Editor layout
Make changes to your headers
Examining the applied steps
How to convert data types in the Power Query Editor
Remove unwanted rows filtering
How to split columns in Power Query
Create a new column
Create a new column to find a value
Rounding and moving column
How to merge queries and join tables in Power Query
Add new data, then refresh your query
Taught by
Teacher's Tech
