Uploaded August 2026 | Updated September 2026, 2 weeks ago
📥 Download the practice files with Source Data + PDF notes - https://forms.gle/vVeBiqkyW5e3ZKbR7
Learn Power Query in Excel from scratch in this complete Power Query Full Course for beginners. This practical Power Query tutorial starts with the basics of what Power Query is and how it works in both Excel and Power BI, and then moves into real data-cleaning problems you are likely to face at work.
You’ll see how to use Power Query to combine multiple Excel files, automate recurring data-cleaning tasks, work with files that have different structures, remove junk rows, understand helper queries, group and summarise large datasets, and fix badly structured data using Unpivot. We’ll also build a custom function in Power Query and use the Advanced Editor to apply the same cleaning logic across multiple sheets.
Power Query is also known as Get & Transform Data in Excel, and it is one of the most useful tools for cleaning, transforming and automating data before analysis. The same Power Query concepts also apply inside Power BI, so everything you learn here can be used in both tools.
===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book
✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?
✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi
✔️ Power Query Course -
products.goodly.co.in/learn-power-query
✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
===== CHAPTERS =====
00:00 Introduction
01:01 What is Power Query?
04:42 Power Query in Excel vs Power BI
06:23 Combine multiple Excel files
15:36 Different file structures & helper queries
24:33 Group and summarise large datasets
31:03 Unpivot messy data
38:04 Build custom functions in Power Query
46:28 Where to go next
===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
📥 Download the practice files with Source Data + PDF notes - https://forms.gle/vVeBiqkyW5e3ZKbR7
Learn Power Query in Excel from scratch in this complete Power Query Full Course for beginners. This practical Power Query tutorial starts with the basics of what Power Query is and how it works in both Excel and Power BI, and then moves into real data-cleaning problems you are likely to face at work.
You’ll see how to use Power Query to combine multiple Excel files, automate recurring data-cleaning tasks, work with files that have different structures, remove junk rows, understand helper queries, group and summarise large datasets, and fix badly structured data using Unpivot. We’ll also build a custom function in Power Query and use the Advanced Editor to apply the same cleaning logic across multiple sheets.
Power Query is also known as Get & Transform Data in Excel, and it is one of the most useful tools for cleaning, transforming and automating data before analysis. The same Power Query concepts also apply inside Power BI, so everything you learn here can be used in both tools.
===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book
✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?
✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi
✔️ Power Query Course -
products.goodly.co.in/learn-power-query
✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
===== CHAPTERS =====
00:00 Introduction
01:01 What is Power Query?
04:42 Power Query in Excel vs Power BI
06:23 Combine multiple Excel files
15:36 Different file structures & helper queries
24:33 Group and summarise large datasets
31:03 Unpivot messy data
38:04 Build custom functions in Power Query
46:28 Where to go next
===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
