Power Query Essential: Clean, Transform & Automate Your Data

Name: Power Query Essential: Clean, Transform & Automate Your Data
Rating: 4.6 (102 reviews)

Learn to clean, combine, and automate data using Power Query in Excel & Power BI – no coding required!

Created byMohammad Shabbir Taibani, Data Skill Hub .

Last updated 7/2025

English

What you'll learn

Clean and transform messy data using Power Query without writing any code.
Combine multiple files and tables easily using append and merge techniques.
Automate repetitive data tasks like removing blanks, splitting columns, and formatting.
Build a strong foundation in ETL (Extract, Transform, Load) to prepare data for reporting and dashboards.

Course content

5 sections • 17 lectures • 1h 1m total length

Introduction2:40
Learn to clean, shape, and transform messy data with Power Query, automating repetitive tasks without coding and connecting multiple sources in Excel or Power BI.
Exercise File0:01

Session Overview & Agenda1:00
Explore Power Query basics, load data into Power Query, and automate tasks like removing duplicates, fixing date formats, and merging columns, then view results in Excel tables.
Introduction to Power Query, Excel Compatibility & Interface Navigation1:18
Explore Power Query in Excel and Power BI, learn its compatibility from 2016 onward, and navigate the editor interface to perform ETL data cleaning.
Understanding the Data Problem & Defining the Expected Outcome2:08
Automate data cleaning with Power Query to fix date formats, combine line and machine IDs, and remove duplicates for a dynamic, refreshable dataset.
Converting Raw Data into a Table & Naming Best Practices3:16
Learn to convert raw data into a formatted table in Excel with Power Query, using Ctrl T, for in-sheet outputs or cross-source data, and apply naming rules.
Loading Tables into Power Query & Exploring the User Interface3:38
Load a table into Power Query and explore the Power Query Editor to manage data cleaning steps, view applied steps, and modify, rename, and reorder queries.
Understanding Data Types, Fixing Dates & Removing Duplicates6:08
Explore Power Query basics to fix date data types, merge two columns with a custom separator, and remove duplicates to create an automation template that outputs clean data to Excel.
Loading Results into Excel as a Table & Refreshing Data5:50
Learn to load data into Excel with Power Query, choosing between a table for up to 1 million rows and a pivot table for larger data, use close and load.
Modifying Existing Queries & Key Things to Remember2:25
Modify existing queries by using the data tab, then queries and connections, and edit in the Power Query editor; close to load updates, note case sensitive behavior and steps.

Understanding the Data Set & Defining the Expected Outcome2:18
Learn to clean, transform, and automate data by appending monthly production files with Power Query, creating a master table for pivot-table analysis.
What is Append Use Cases & Real-World Scenarios2:34
Learn how to apply append in Power Query to combine tables with matching or differing headers, creating a master table for production data and practical scenarios.
Combine Multiple Files from a Folder in Power Query12:57
Connect to a folder, combine and transform multiple files in Power Query, clean file names, ensure headers and sheet names match, and load as a pivot with auto refresh.

What is Merge Definition & Problem Statement3:40
Explore merge in Power Query by combining a CSV with the master production table using a three-column match, replacing Vlookup with a robust multi-column join.
Merge Data Using a 3-Column Combination5:36
Merge production data with a QC report using a three-column combination in Power Query, performing a left outer join on date, plant, and model, then expand results.
Expand the Merged Table, Select Required Columns & Load as Connection Only4:40
Expand the merged table, select only the required columns, load as a connection, and then merge, append, unpivot, and pivot to build a lean master view in Power Query Essential.

Requirements

Basic knowledge of Microsoft Excel (working with tables and columns).

Description

Do you often spend hours cleaning up messy data in Excel?
What if you could automate all that work – and save hours every week?

Power Query Essential is your beginner-friendly guide to mastering Power Query — the powerful data transformation tool inside Excel and Power BI. You’ll learn how to clean, shape, format and prepare your data like a pro — all without writing a single line of code.

In this course, you’ll learn how to:

Remove errors, blanks, and duplicate values from your data
Split and merge columns effortlessly
Append and merge tables from multiple sources
Automate routine data-cleaning tasks in a few clicks
Build a strong foundation in the ETL process (Extract, Transform, Load)

What makes this course special:

Hands-on practice with real-world examples
Simple explanations — even if you’re completely new
Learn Power Query in both Excel and Power BI

This course is perfect for:

Excel users who want to automate their data work
Students and professionals working with reports or dashboards
Anyone getting started with data analytics

By the end of this course, you’ll be able to clean and transform data confidently and prepare it for better insights — faster and easier than ever before.

See you in the course!

Who this course is for:

Anyone who works with Excel or data and wants to save time and reduce manual work.
Beginners who want to start learning data transformation and automation using Power Query.
Students, analysts, and professionals who want to prepare data faster for reporting or analysis.

Power Query Essential: Clean, Transform & Automate Your Data

What you'll learn

Explore related topics

Course content

Kickstart - Getting the Most Out of Your Learning Journey2 lectures • 3min

Power Query Essentials: Data Cleaning & Automation in Excel8 lectures • 26min

Power Query: Combining & Appending Files in Excel3 lectures • 18min

Power Query: Merge Excel and Csv file3 lectures • 14min

What's Next1 lecture • 2min

Requirements

Description

Who this course is for: