Power Query Masterclass on Lists with Oz du Soleil @OzduSoleilDATA

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 @OzduSoleilDATA, where we simplify the intricacies of the M language, empowering you to work smarter in Power Query.

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step-by-Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== 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

[romulusmilea]

A Power Query titan teaches another Power Query master ! This is a dream that came true ! These are true professionals, who still want to learn from others, even if they are really valuable experts themselves. I have a dream for Chandeep, to become a Microsoft MVP as soon as possible, he deserves it a lot ! Oz, I really hope that you will endorse Chandeep in becoming a MVP !

[baskis]

Fantastic masterclass! I love the way you explain it! .... thanks for sharing

[Ypurenete]

Amazing video!!! When You have somebody to chat with during your presentation.

[jimgleason]

Chandeep. You are absolutely Fantastic as Always. You and Oz are a really great pair.

[Imwolfies]

List's demystified, in easy to understand steps of the "how" and "why" along with the utilization of the possibilities in "M" code. Especially for those of us that are new to "M" code and cannot do with what is needed in the PQ user interface. Absolutely excellent.

[shirleymoreman]

2 of my favourite experts in one video! This is brilliant and so well explained.

[LakeSightSolutions]

Humility at its best!!!
One expert learning / teaching another

[RobertLJ]

Great Video! Loved it! I love to see the Teacher as the student. Everyone who is dedicating time to teach also should have time to be a student. Thank you for all of you videos! 😊

[Bhavik_Khatri]

An insightful video that imparted valuable knowledge on enhancing the dynamism of my coding practices.

[alterchannel]

Chandeep is the BEST teacher ever. I really mean it. Nobody explains and makes things so easy like him.

[marcusdrees]

Hi Chandeep, I have just watched your video and once again I would like to express how thankful I am for your input you have unknowingly given me in the past. Not only have I become a member of your channel in the meantime, I have also enrolled to your M course earlier. As shown you have enligthened 400+ people other than me to take your course and I can tell all others that are still interested: It was worth every penny!!! Good for you!!!!
I have watched quite a few of Oz's videos as well and I would like to ask you to do more videos like this because some things became so much clearer again (having taken the course) only because of the fact that you had Oz ask immediate questions, which helps a lot in the sense that rather that talking about a huge topic (Power Query) reduced to a specific case study in many videos it was easier for me having received answers to questions I would have asked myself which Oz did for me instead. I think with a certain amount of background and experience would bring other user's skills to another level.

Thank you very much again!

Marcus

[GrainneDuggan_Excel]

Wow! Wonderful video on so many levels! Thanks Oz and Chandeep. Chandeep, you deserve a medal if you can get Oz to do a video manipulating M code! Can't wait for the next Chandeep and Oz video!❤❤❤

[ismaelkourouma]

I really loved this video, seeing Oz like a young man learning something new. I know Oz since 4 years and I know he's a master. I can see in this video how he's humble and that is fundamental when you're learning something new even if you're an Excel MVP. Thank you guys for this phenomenal video. Really loved.

[philipplanchenault]

Mindblowing ... the explained concepts ... but also the way Chandeep explained ...

[zhihaowu]

This was an amazing POwer Query a day video! thank you.

[allabout]

I liked to see that even Oz have things to learn. No meter how many Years we are on excel there is always what to explore new, optimize and get understand new concepts. Its not only about knowing tools and functionality but its more about how we use it and combining together on our daily problem solving challenges.

[stevenflax]

Usually love Chandeep's presentations. But having Oz asking questions and interacting was different level. Thanks both !!

[Nalaka-Wanniarachchi]

oh.This is huge ..PQ masters in action ...

[michaeloloishuro]

Great. This was one of the best chances for learning by some of us. The trust element is more because I am aware Chandeep is presenting to another Guru.
Thank you!

[EricHartwigExcelConsulting]

Fantastic video! I really like the break down in the steps you were taking in each example.