Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Power Query - Power Query Tutorial for Beginners

Simon Sez IT via YouTube

Start learning Write review
DataCamp Ad

AI Engineer - Learn how to integrate AI into software applications

Learn More → Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course introduces Excel Power Query for importing data from files and other sources, transforming and reshaping it, and combining multiple tables for analysis. It assumes intermediate to advanced Excel experience but no prior Power Query knowledge.

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

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Excel Power Query - Power Query Tutorial for Beginners

  • Profile image for Mohamed Kassem
    Mohamed Kassem
    Very simple for beginners with a clear explanation from the instructor of the main topics, just didn't find the exercise files
Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.