Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Power Query in Excel: Automate Reports & Transform Data Fast

Name: Power Query in Excel: Automate Reports & Transform Data Fast
Rating: 4.7 (4 reviews)

Automate Excel data with Power Query in just 3 hours. Import, clean and combine data using real business examples.

Created byIT Whisperer

Last updated 5/2026

English

English [Auto],

What you'll learn

Import data from multiple sources such as Excel files, PDF documents and databases using Power Query
Clean and fix common data quality issues quickly and efficiently
Transform messy datasets into structured tables ready for analysis
Create calculated, conditional and custom columns
Combine data from multiple tables using Merge Queries
Reshape datasets using Pivot and Unpivot operations
Build automated data preparation workflows that refresh with one click
Prepare datasets for Pivot Tables, dashboards and reports
Work with parameters to create flexible and dynamic queries
Load and manage datasets in the Excel Data Model

Course content

11 sections • 39 lectures • 3h 11m total length

Start Here – How to Get the Most Out of This Course0:45
What is Power Query2:15
Discover how Power Query in Excel imports, transforms, and combines data from multiple sources, automates refreshes, and loads results into tables, data models, or pivot tables.
The Data Retrieval and Transformation Process in Power Query6:59
In this lecture you will learn about the typical data workflow in Power Query. You will see how data is retrieved from different sources, transformed and cleaned, and finally prepared for analysis. This lesson will help you understand the overall process of working with data in Power Query and why it is such a powerful tool for automating data preparation.

Power Query Data Sources + TXT Import Example3:28
In this lecture you will learn about the most common data sources available in Power Query. You will see what types of files and systems Power Query can connect to and how the data import process works. At the end of the lecture, we will also go through a practical example of importing data from an TXT file.
Get data from MS Excel1:31
Downloading data from the database (MS Access)1:41
In this lecture you will learn how to import data from a Microsoft Access database using Power Query. You will see how to connect to the database, select the appropriate table, and load the data into Excel for further analysis.
Importing Data from PDF Files1:48
In this lecture you will learn how to import data from PDF files using Power Query. You will see how to select tables detected in a PDF document and load them into Excel for further data analysis and transformation.

Managing Rows and Columns in Power Query12:00
In this lecture you will learn how to manage rows and columns in Power Query. You will see how to remove, filter and sort data, and how to prepare a dataset for further transformation and analysis.
Transforming Data and Correcting Incorrect Formats13:25
Transform data with power query by fixing dates, cleaning country and status fields, removing units, and converting to numbers, then load in excel for automatic refresh.
Fixing Errors in Numbers in Power Query4:04
Merging Columns in Power Query2:27
In this lecture you will learn how to merge multiple columns into a single column using Power Query. You will see how to select columns and apply different separators to create clear and well-structured data.
Transforming Table Structure in Power Query3:55

Creating Columns from Date Values2:54
Creating Columns from Text Values6:04
Learn how Power Query in Excel creates columns from text by extracting endings, after delimiters, and between slashes, and by adding prefixes or suffixes to each entry.
Creating Numeric Columns in Power Query3:51
In this lecture you will learn how to create new columns from numeric data in Power Query. You will see how to perform basic calculations and transformations to prepare your data for further analysis and reporting.
Calculated Columns in Power Query4:27
Conditional Columns in Power Query6:38
Creating New Columns by Splitting Columns2:43
Power Query shows how to split columns by delimiters, numeric transitions, and case changes, turning order numbers into multiple columns and then loading the results into Excel.
Creating Columns from Examples3:58

Automatically Combining Data from Multiple Files in a Folder7:49
In this lecture you will learn how to automatically import and combine data from multiple files stored in a folder using Power Query. You will see how to create a query that collects data from all files and combines them into a single table.
Importing Data from Multiple Sheets into Separate Queries and Combining Them4:49
In this lecture you will learn how to import data from multiple worksheets within a single Excel file and load each sheet into separate queries in Power Query. You will then see how to manually combine these queries into a single table using the Append feature.
Automatically Importing and Combining Data from Multiple Sheets6:15
In this lecture you will learn how to automatically import data from multiple worksheets in an Excel file using Power Query. You will see how to build a query that detects all sheets in the file and combines their data into a single table without manually creating separate queries.

Merging Queries Using a Single Column10:38
Merge queries in Power Query by joining orders and customers on a key to enrich data with customer details and contractual discounts, using a left outer join across sources.
Merging Queries Using Multiple Columns4:30
Learn to merge queries by matching two columns, like country and customer number, to relate orders to customers. Add missing clients and refresh to update results quickly.

Creating and Using Parameters in Power Query5:13
In this lecture you will learn the basics of working with parameters in Power Query. You will see how to create parameters and use them in queries to build more flexible and dynamic data transformation processes.
Parameters from a List of Values2:30
In this lecture you will learn how to create parameters based on a list of predefined values in Power Query. You will see how to restrict parameter choices to specific options and use them within your queries.
Parameters from an Excel Cell5:07
In this lecture you will learn how to create Power Query parameters based on values stored in Excel cells. You will see how to control queries and data transformations directly from the Excel worksheet.
Using Parameters in a Conditional Column3:13
In this lecture you will learn how to use parameters inside conditional columns in Power Query. You will see how parameters can control logical conditions and make your data transformations more flexible and dynamic.

Data Model Concept and Loading Data5:16
In this lecture you will learn the basic concept of the Excel Data Model. You will see what the data model is and how data from Power Query can be loaded into it to store and analyze datasets.
Parameters and additional datasets in the Data Model5:29
In this lecture you will see how the Excel Data Model can be used as a place to store data imported from Power Query. You will learn how to manage additional datasets and prepare them for further analysis.
Keeping Multiple Data Sources in the Data Model8:03
In this lecture you will see how the Excel Data Model allows you to store data coming from multiple sources. You will learn how to organize and manage these datasets in one place to support further analysis.
Data Model Working with datasets beyond Excel’s row limit7:13
In this lecture you will learn how to use the Excel Data Model to work with very large datasets. You will see how to store and analyze data that exceeds the worksheet row limit.

Requirements

Basic knowledge of Microsoft Excel (working with tables, columns and simple formulas)
Microsoft Excel 2016 or newer, or Microsoft 365
No prior experience with Power Query is required — everything is explained step by step

Description

Stop wasting hours cleaning Excel data manually.

Learn how to automate everything with Power Query in just 3 hours.

Work with real business examples.

This course has been designed based on over 20 years of my professional training experience, working directly with business users in real classroom environments.

To further enhance the learning experience, selected elements of artificial intelligence were used during the course creation process — mainly to support translations and refine the structure and clarity of the content.

All course content, explanations, examples, and recordings are 100% created by me. AI was used only as a supporting tool, not as a replacement for expertise.

Thanks to this combination of real-world experience and modern tools, this course is a complete and practical guide that allows you to learn Power Query efficiently.

In just a little over 3 hours, you will gain hands-on skills that you can immediately apply in business scenarios and everyday Excel work.

Power Query is one of the most powerful tools in Microsoft Excel for working with data. It allows you to automate tasks that would normally take hours of manual work.

In this course, you will learn how to use Power Query in a practical and business-focused way. Everything is explained step by step using real business scenarios, so you can immediately apply the techniques in your daily work.

This is not a theoretical course.

You will learn by working with practical examples and real datasets.

In around 3 hours, you will gain a strong understanding of Power Query and learn how to:

import data from different sources (Excel, Access, PDF, folders)
clean and prepare messy datasets
combine data from multiple files and tables
automate repetitive reporting tasks
create new columns using dates, text, numbers and formulas
use parameters to build dynamic queries
prepare data for Pivot Tables and charts
work with larger datasets using the Excel Data Model

You will also learn many useful Power Query techniques, including:

Fill Down
Unpivot
Merge queries
Append queries
Combining files from folders
Importing data from multiple worksheets
Grouping and restructuring data

By the end of this course, you will understand the full data workflow in Excel:

Import → Transform → Automate → Analyze

Who this course is for:

Excel users who work with data and want to automate data preparation
Analysts and reporting specialists who need to clean and transform datasets efficiently
Accountants, controllers and finance professionals working with Excel reports
Business professionals who regularly prepare reports and want to save time
Anyone who wants to learn Power Query in Excel from beginner to practical business use

Power Query in Excel: Automate Reports & Transform Data Fast

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 10min

Data Sources in Power Query4 lectures • 8min

Power Query Editor and Data Quality2 lectures • 15min

Transforming and Cleaning Data5 lectures • 36min

Creating New Columns in Power Query7 lectures • 31min

Importing Data from Multiple Files and Sheets3 lectures • 19min

Merging and Combining Queries in Power Query2 lectures • 15min

Parameters in Power Query4 lectures • 16min

Using Power Query Data in Reports2 lectures • 6min

The Data Model in Excel4 lectures • 26min

Requirements

Description

Who this course is for: