Excel Power Query: Clean & Transform Data Like A Pro

Learn to clean, combine, and transform messy data using Excel Power Query, no formulas or coding required.

What you'll learn

Import and connect data from multiple sources

Clean and transform raw data with clicks, not formulas

Combine multiple tables with merge and append

Automate repetitive data prep tasks

Create reusable data workflows in Excel

Load cleaned data into Excel for analysis and dashboards

Requirements

No prior experience with Power Query or coding needed

Basic understanding of Excel (no advanced knowledge required)

Excel 2016 or later (Power Query comes built-in)

Description

Are you tired of manually cleaning and preparing messy Excel data every time? Then it's time to master Power Query Excel’s most powerful, time saving data tool.This hands-on course is designed for beginners and Excel users who want to automate their data transformation process without using formulas or VBA. Power Query allows you to connect, combine, clean, and reshape data from different sources in just a few clicks.Whether you're dealing with CSVs, Excel files, or web data, you’ll learn how to import, transform, and load data in a clean format ready for analysis. We’ll cover how to remove duplicates, split columns, unpivot data, filter records, and handle nulls all using Power Query’s visual, step-by-step interface.You’ll also discover how to merge and append multiple tables, automate recurring tasks, and build reusable data prep workflows that save you hours every month. Finally, we’ll show how to load your transformed data directly into Excel and integrate it with PivotTables or dashboards.This course is practical, project-based, and requires no coding knowledge. It’s perfect for business analysts, data professionals, or anyone working with Excel who wants to work smarter, not harder.By the end, you’ll be fully equipped to use Excel Power Query like a pro turning chaotic spreadsheets into clean, analysis-ready data in minutes.

Overview

Section 1: 01 Welcome to Power Query

Lecture 1 Introduction to Power Query

Lecture 2 What is Power Query?

Lecture 3 How to access the Power Query Editor in Excel

Lecture 4 Download the Resource Files

Lecture 5 Resource Files

Section 2: 02 Importing Data from multiple sources

Lecture 6 Primary Data Sources

Lecture 7 Secondary Data Sources

Section 3: 03 Navigating the Power Query Editor

Lecture 8 Understanding Power Query Editor Interface

Section 4: 04 Cleaning and Transforming Data with Power Query

Lecture 9 Filtering and Removing blank spaces

Lecture 10 Splitting Columns, Removing Columns and Extract

Lecture 11 Changing Data types and Column names

Lecture 12 Trimming and Cleaning Text Fields

Lecture 13 Replace Values

Lecture 14 Text Formatting

Lecture 15 Merging and Re-arranging Columns

Lecture 16 Adding new calculated Columns

Lecture 17 Data Formatting

Section 5: 05 Combining/Merging Data Tables

Lecture 18 Merging Data Tables

Lecture 19 Loading Data into Excel

Section 6: 06 Adding new Sales Report and Refreshing

Lecture 20 Adding the 'May" Sales Report

Excel users who want to automate data cleaning,Data analysts, accountants, and business professionals,Anyone working with large or messy datasets,Students or job seekers preparing for roles in data analysis,Beginners who want to level up their Excel data skills