Power Query Essentials Import, Filter, and Clean Data
Published 9/2026
Created by Simon Sez IT
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Beginner | Genre: eLearning | Language: English | Duration: 17 Lectures ( 1h 12m ) | Size: 801.7 MB
Save hours every week by automating your messy spreadsheet data.
What you'll learn
Connect Power Query to CSV files, PDFs, and workbooks. Filter rows and columns down to what a report needs. Remove blank rows, duplicate records, and inconsistent headers. Standardise mismatched text entries such as region names. Use Fill Down to complete missing values automatically. Replace incorrect or inconsistent values across an entire column. Rename and reorder steps in the Applied Steps pane. Split a combined name column into separate fields. Merge two columns into a single custom column. Adjust data types so numbers and dates calculate correctly. Build a Column from Examples using sample patterns. Load a finished query into Excel, a PivotTable, or Power BI.Requirements
Basic knowledge of Microsoft Excel, including working with worksheets and tables. Microsoft Excel with Power Query (Excel 2016 or later, or Microsoft 365) or Power BI Desktop installed. Familiarity with common spreadsheet data such as lists, dates, and numbers. No previous Power Query experience is required. This course teaches every step from the beginning.Description
This course includes downloadable course instructor files and exercise files to work with and follow along.
Power Query Essentials: Import, Filter, and Clean Data teaches you how to prepare raw data for Excel and Power BI without writing formulas. You will gain a clear, repeatable process for turning messy files into datasets you can trust. Many spreadsheets arrive with inconsistent headers, blank rows, duplicate entries, or numbers stored as text. Fixing these by hand takes time and invites mistakes, especially when a report needs to be updated each month. The course starts here, showing why a structured cleaning process matters before analysis begins.
You learn how to connect to sources such as CSV files, PDFs, and Excel workbooks, then filter rows and columns down to what matters. The Applied Steps pane records every change, so you can rename, reorder, or remove a step without having to redo the query. You also set data types, split and merge columns, and fix inconsistent entries with tools like Fill Down and Replace Values. Picture a monthly sales file with mismatched region names and missing dates. You learn how to fill the gaps, standardise the text, and split a combined name column into first and last names. Learn how to pull a PDF report into a clean table, ready to merge with other sources. Each scenario mirrors a fix you meet in a real job.
By the end, you will have been taught the skills to import data from almost any source, clean it with confidence, and load it into Excel or Power BI as a finished table. This course suits analysts, report builders, and anyone who spends too much time wrestling with spreadsheets before real work starts.
What you'll learn
Connect Power Query to CSV files, PDFs, and workbooks. Filter rows and columns down to what a report needs. Remove blank rows, duplicate records, and inconsistent headers. Standardise mismatched text entries such as region names. Use Fill Down to complete missing values automatically. Replace incorrect or inconsistent values across an entire column. Rename and reorder steps in the Applied Steps pane. Split a combined name column into separate fields. Merge two columns into a single custom column. Adjust data types so numbers and dates calculate correctly. Build a Column from Examples using sample patterns. Load a finished query into Excel, a PivotTable, or Power BI.This course includes
72 minutesof video tutorials14 individual video lecturesCourse and Exercise Files to follow alongCertificate of completionWho this course is for
Excel users who want to automate data cleaning tasks. Beginners who are new to Power Query and data preparation. Data analysts who regularly clean and prepare datasets. Power BI users who want cleaner, more reliable source data. Business professionals who work with CSV, Excel, or PDF files. Anyone who wants to spend less time fixing spreadsheets manually.Homepage
Code:
https://www.udemy.com/course/power-query-essentials-import-filter-and-clean-dataRecommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Rapidgator
wbzgh.Power.Query.Essentials.Import.Filter.and.Clean.Data.rar.html
AlfaFile
wbzgh.Power.Query.Essentials.Import.Filter.and.Clean.Data.rar
No Password - Links are Interchangeable
