Check out the M Language course and learn to push beyond the UI - https://goodly.co.in/learn-m-powerquery/ https://www.youtube.com/watch?v=Pk5lPbeczAI In this video, we dive deep into Power Query and explore the fascinating world of the M language, specifically focusing on the concept of lists to make it easier for you to navigate and leverage its power in Excel. Don't miss out on this insightful session with https://www.youtube.com/channel/UCZgOVykPoRbSZQfY9YysiRQ, where we simplify the intricacies of the M language, empowering you to work smarter in Power Query. Also, don't forget to check out Oz's Channel - null ===== ONLINE COURSES ===== ✔️ Mastering DAX in Power BI - https://goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Course- https://goodly.co.in/learn-power-query/ ✔️ Master Excel Step-by-Step- https://goodly.co.in/learn-excel/ ✔️ Business Intelligence Dashboards- https://goodly.co.in/learn-excel-dashboards/ ===== LINKS 🔗 ===== Blog 📰 - https://www.goodly.co.in/blog/ Corporate Training 👨‍🏫 - https://www.goodly.co.in/training/ Need my help on a Project 💻- https://www.goodly.co.in/consulting/ ===== CONTACT 🌐 ===== Twitter - https://twitter.com/chandeep2786 LinkedIn - https://www.linkedin.com/in/chandeepchhabra/ Email - goodly.wordpress@gmail.com ===== CHAPTERS ===== 00:00 Intro 04:44 About Global Excel Summit 08:08 What is a List? 10:09 Extracting Values as a List 16:41 Dynamic Expansion 32:40 Dynamic Unpivoting 43:29 Dynamic Splitting 50:30 The Advantages of Mastering M for UI-Oriented Users ===== 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! #powerquery #mlanguage #excel