Join our bestselling Power Query course ???? https://www.xelplus.com/course/excel-power-query/
???? Download the sample files and follow along: https://www.xelplus.com/learn-power-query/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-pq&utm_content=learn-pq#download-section
This video is the perfect Power Query beginner video. If you ever wanted to learn power query by following real-world examples, then this video is for you. If you don’t know what Power Query is but you’ve ever wasted hours copying and pasting data, fixing broken formulas, or messing around with messy spreadsheets, then this video is for you too. You see Power Query is the solution to many data problems in Excel. In fact it also replaces a part of VBA code. The part that is used to import and clean data.
We’ll walk through real-world Excel problems and solve them using Power Query. You’ll learn how to clean messy data, how to import data, how to combine multiple files, whether Excel, CSV, text, data files, and how to unpivot your data.
In this video, you’ll learn how to:
– Clean up messy Excel data (blanks, double headers, weird formatting)
– Combine multiple CSV files into one clean dataset
– Turn static reports into dynamic data models
– Automate your monthly reports with a single refresh
– Use Power Query to reshape your data without formulas
Whether you’re building pivot tables, prepping dashboards, or just want to work smarter in Excel—Power Query will save you hours.
00:00 Why you need Power Query to save time
01:02 Cleaning messy data: Removing blanks and double headers
02:02 Where to find Power Query in Excel (Get & Transform)
03:40 Connecting to external Excel workbooks
04:40 Navigating the Power Query Editor and Applied Steps
06:45 How to remove top rows and promote headers
08:24 Using the Column Quality tool for data auditing
08:55 Removing blank rows and filling down empty cells
10:14 Formatting data: Replacing values and changing case
12:01 Performing calculations within Power Query
12:58 Loading cleaned data back into Excel
14:10 How to automatically refresh your data
15:52 Combining multiple CSV files from a folder
18:55 Adding quarter numbers and extension filters
22:06 Unpivoting reports into proper data sets
25:25 Creating and refreshing Pivot Tables from queries
???? Subscribe to “Between the Sheets” newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter
➡️ Join this channel to get access to perks:
https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
???? LINKS to related videos:
How Power Query Will Change the Way You Use Excel: https://youtu.be/6lBqYInBldk
You WON’T BELIEVE These 10 HIDDEN Features in Excel Power Query: https://youtu.be/8hjgmJk5RiA
????☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
???? Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
???? RESOURCES I recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
????Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
