Intermediate Microsoft Excel Tutorial - How to Use Power Query

Learn how to use Power Query in Microsoft Excel with this intermediate-level tutorial. Discover how to import and connect to external data, transform it efficiently, and perform various operations like adding or removing columns, changing data types, merging tables, and building formulas. Explore the user-friendly interface of Power Query and master techniques for importing, cleaning, and consolidating data. Follow along as the instructor guides you through importing data from the web and Excel ranges, navigating the Power Query Editor, manipulating headers, applying data type conversions, filtering rows, splitting columns, creating new columns with calculations, rounding values, merging queries, and refreshing your data. By the end of this comprehensive guide, you'll have the skills to streamline your data processing tasks and enhance your Excel workflow using Power Query.

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