Skip to main content
AmigoFish

Power Query for Beginners: Automate Your Excel Work in 25 Mins

From Leila Gharani · · 27 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Learn Power Query in Excel: clean messy data, combine CSV files and reshape reports. ⬇️ Sample files: 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

🎓 500,000+ enrolled in our courses. New to Power Query? Start with Power Query Foundations 👉 https://courses.xelplus.com/p/power-query-foundations?utm_source=yt-video&utm_medium=vid-description&utm_campaign=pq-foundations&utm_content=learn-pq

Three real scenarios, built with clicks in the ribbon and no formulas. Power Query records every step, so the next time new data arrives, just refresh. Download the sample files and follow along.

1. Messy data: blank rows, empty cells and double headers, cleaned and loaded as a table or PivotTable. 2. Multiple files: CSV files in a folder combined into one data set. Works for TXT and Excel files too. 3. Reports: months across columns turned into a proper data set with Unpivot, ready for PivotTables.

Find Power Query on the Data tab, under Get & Transform Data.

00:00 Power Query for beginners: why use it 01:01 How to clean messy data in Excel 02:01 Where to find Power Query in Excel 03:09 How to connect to another Excel workbook 04:45 Power Query Editor and Applied Steps 06:42 How to remove top rows and promote headers 07:55 How to check data quality (Column Quality) 08:54 How to remove blank rows and fill down 10:13 How to replace values and change text case 11:59 How to add a calculated column 12:57 How to load and refresh Power Query data 15:50 How to combine multiple CSV files in Excel 19:12 How to filter files in a folder query 22:00 How to turn a report into a data set 24:06 How to unpivot columns in Power Query 25:22 PivotTable by quarter from Power Query

🎓 Full Power Query course: https://link.xelplus.com/yt-course-powerquery 🎬 How Power Query Will Change the Way You Use Excel: https://youtu.be/6lBqYInBldk 🎬 10 hidden features in Power Query: https://youtu.be/8hjgmJk5RiA

➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join ✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter

🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani

#excel #powerquery #exceltips

Back to Leila Gharani · Report a problem