Magic of Lists in Power Query - 11th June 2020

In this Excel meetup, we heard from Gašper Kamenšek and the 'Magic of Lists in Power Query'.

Gašper Kamenšek is a BI Professional and an MVP for Excel from Slovenia. He provides training and speaks at conferences all over the world.

Gašper is also the organiser of the Excel Olympics Excel conference in Slovenia.

I am delighted to welcome Gašper to the London Excel Meetup where we can all learn some awesome tips.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[deexcelguy]

I really enjoyed the session and the discussion after the presentation.
Thank @ Andy!!!

[johnhackwood]

This is just so brilliantly good Gasper thank you so much and thank you Alan for putting this on and making it available. This is another one I had put aside until now and thankfully I have finally watched it and wow, it's just eye popping!

[wayneedmondson]

Brilliant training and presentation Gasper and Alan. Glad for the replay.. to work through examples at a slower pace. Thanks a million. Thumbs up!!
PS - I see over at Excel Unplugged you've got the 3-part list series with sample data files for each part.. excellent.. thanks!!

[Mohamed.GadAllah]

@08:30 ... If any application does not support zoom in like Power Query Editor, then you can use windows magnifier to zoom any part of your screen, just pin it to the windows taskbar and fire it on when you need it.

[darwisyb]

34:50 is it possible to "merge" table in 1 query?

[riquelversaavedra]

como agregar en rango unico las pociciones de cada umero que salieron y agregar los numeros que salen durante la semana

[romulusmilea]

Hi there,
Please share on this page all 3 files presented during yesterday evening training. Thank you.

[willp]

How can I add the checker that you have in power query above each column. Valid, error, and blank? Thank you