Learn how to use Power Query in Excel to import multiple files and data sources, combine data, merge queries, and more. This course is designed for intermediate to advanced Excel users who are new to Power Query. The teaching method includes video tutorials covering various Power Query functions and features. The intended audience for this course is Excel users looking to enhance their data analysis skills using Power Query.
Overview
Syllabus
- Welcome and Overview
- What is Power Query
- What is Power Pivot
- Exploring the Power Query Editor
- Common Power Query Transformations
- Editing an Existing Query
- Import Multiple Files from a Folder
- Connect to Data in Another Excel Workbook
- Checking the Location of your Query's Source
- Unpivoting Columns
- Combine Data from Multiple Tables with Merge Queries
- Use Merge Queries to Compare Two Tables
- Stack Data into One Table with Append Queries
- Duplicating and Referencing Queries
- Grouping and Aggregating Data
- Conditional Columns in Power Query
Taught by
Simon Sez IT
