June 2020 Modern Excel Webinar: Advanced Power Query Tricks (aka Blame the Weather)

Showing how we can use Power Query and Power Pivot in Modern Excel to answer business questions. Covers building custom functions to scrape data from a website, build a dynamic calendar on the fly, as well as various tips and tricks related to both Power Query and Power Pivot.
For more information on Power Query recipe patterns mentioned in the video, go to skillwave.training/shop
For more information on the Monkey Tools addin mentioned in the video, go to xlguru.ca/monkeytools

[@rameshep2633]

Really helpful. Appreciate the methodology wherein various advanced were demonstrated using the user interface. Nice learning for me.

[@KenPulsXLGuru]

Glad it was helpful!

[@tokinabo]

awesome tutorial, Ken! clear steps, invaluable little tips, and a nice stady pace. thanks :-)

[@cristian.angyal]

Wanted to check the final part ... and I did ;). Thanks for the recording Ken! Super-useful tricks inside!

[@KenPulsXLGuru]

Glad you enjoyed it!

[@howtoexcel5900]

Thank you Ken for this tutorial, very clear and well explained

[@StefanoVerugi]

Great video, super audio quality, full of professional stuff. Many thanks for sharing it ps please consider zoom in to make it easier to watch it on smaller screen, cheers

[@reanalytics1863]

I have taken down notes, Thank you for the elaborate explanations

[@KenPulsXLGuru]

Glad it was helpful!

[@markusmarkovic1406]

Hello Ken, in 25:36 you select the parameter in the small selection menu (ABC). Unfortunately I don't have this menu. Do I have to change anything in my settings here? Thank you for your help!

[@KenPulsXLGuru]

Sorry, I missed this comment. On the View tab in Power Query you need to check the box to “Always allow parameters” (in dialogs). To be honest, it is absolutely ridiculous that this isn’t enabled by default.

[@chamanthawickramarathne2029]

It would be much better if you had shared the excel worksheets used in the video for our reference

[@KenPulsXLGuru]

Hi Chamantha, thanks for asking. This link should get you to both the slides and example files: 1drv.ms/u/s!AuhhLgCXSCKKgP8-0VJh9oabdLz3gA?e=o9gbDw

[@90s_HipHop]

@9:48 Stuff I wish I had know months ago!! @11:30 Just that piece of info is gold dust. That's coming from a avid user of named formulas.

[@dhaval1489]

Have you coverd same data set in Data Scince / Python Conference and solution implemented in Pandas?

[@KenPulsXLGuru]

No, sorry. I’m an Excel expert. My exposure to python is very limited and I’ve never touched pandas.