Udemy - Power Query Essentials - Import, Filter, and Clean Data

Power Query Essentials: Import, Filter, and Clean Data

https://WebToolTip.com

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.