Dive into a comprehensive tutorial on Power Query in Excel, designed for intermediate to advanced Excel users new to Power Query. Learn to navigate the Power Query Editor, import data from multiple sources, perform common transformations, merge and append queries, group and aggregate data, and create conditional columns. Follow along with downloadable demo files to master essential Power Query techniques that will enhance your data analysis capabilities in Excel.
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
