Chandeep v/s Mark | Who will win? Power Query Tricks Battle ⚔ | @ExcelOffTheGrid

Join us for an epic Power Query tricks battle between Me and Mark Proctor! In this video, Mark and I will each share seven powerful tricks to up your Excel game. As we showcase our expertise, you get to decide who wins each round by scoring our tricks. Who will win this battle? Watch till the end to vote and see who comes out on top! Don’t forget to subscribe to Mark’s channel - @ExcelOffTheGrid ===== ONLINE COURSES ===== ✔️ Master ’M’ in Power Query - ✔️ Mastering DAX in Power BI - ✔️ Power Query Course - ===== LINKS 🔗 ===== Blog 📰 - Corporate Training 👨‍🏫 - Need my help on a Project 💻- Download File ⬇️ - ===== CHAPTERS ===== 00:00 Intro 04:18 Mark Trick 1 - Dynamic File Path 08:24 Chandeep Trick 1 - Promote Headers Trick 10:54 Mark Trick 2 - Fetching Date Column Trick 14:50 Chandeep Trick 2 - Adding Multiple Columns using Records 18:10 Mark Trick 3 - Flatten Header Rows 21:16 Chandeep Trick 3 - Adding Totals using Grouping 26:10 Mark Trick 4 - Removing Null Columns 29:28 Chandeep Trick 4 - is keyword 31:02 Mark Trick 5 - Dynamic Column Names 32:56 Chandeep Trick 5 - Projections 35:43 Mark Trick 6 - Use Merge to Filter Multiple Values 39:32 Chandeep Trick 6 - Trick 41:21 Mark Trick 7 - Cleaning Multiple Tables at Once 47:36 Chandeep Trick 7 - Local Grouping ===== CONTACT 🌐 ===== Twitter - LinkedIn - Email - @ ===== 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!