14 Power Query Hacks that Feel Illegal to Know

In this video I'm going to show you Power Query transformation hacks that will help you up your Power Query game.
Download the practice file here: docs.google.com/spreadsheets/...
00:00 Hack 1
01:07 Hack 2
01:40 Hack 3
02:15 Hack 4
02:46 Hack 5
03:42 Hack 6
04:21 Hack 7
04:44 Hack 8
05:57 Hack 9
09:01 Hack 10
09:22 Hack 11
11:26 Hack 12
13:10 Hack 13
15:47 Hack 14
✅ Please see link to videos mentioned in this video:
🎦 How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet - • How to Combine Multipl...
🎦 Power Query Custom Functions - • Power Query Custom Fun...
🎦 Power Query Advanced Editor - What Is It and How to Use It? - • Getting Started with t...
✅ If you would like to connect on LinkedIn:
🤝 / missmicrosoft
✅ If you would like to support the channel by buying me a coffee, (it's really quick and easy), please use this link:
☕www.buymeacoffee.com/missmicr...
✅ For more videos please subscribe:
🔔 / @missmicrosoft

[@EricaDyson]

Wonderful. I love your videos. They are so clear, relevant and easy to follow.

[@MissMicrosoft]

Thank you so much Erica, that means a lot to me. I’m so glad I’m helping!

[@phillipkadaoui9649]

This is game changing stuff! I've used power query for about 2 years and these are solid gold!

[@MissMicrosoft]

You're most welcome Phillip, I'm so glad the video was helpful! Thank you so much for the coffee!!!

[@kebincui]

Excellent video as your previous ones.Thank you so much. 🌹👍

[@MissMicrosoft]

It’s a pleasure Kebin 😊

[@djl8710]

Nice densely packed video! And a download too I'm in heaven!

[@MissMicrosoft]

Glad you enjoyed the video!

[@zahoorsarbandi2982]

Thank you very much for sharing such an informative & useful videos as always...👌👍

[@MissMicrosoft]

You’re most welcome Zahoor!

[@norbertschmidt6532]

Super. Thank you for the excellent video.

[@MissMicrosoft]

Thank you for your kind words, it’s much appreciated 😊🙏

[@alterchannel2501]

I love your voice, love your accent and love your channel 🥰

[@MissMicrosoft]

Thank you so much for your kind words 😊🙏

[@MrDhunpagla]

Your are magical😊

[@MissMicrosoft]

Ahhh thank you 😊

[@tahm76]

That’s very clear. Thank you

[@MissMicrosoft]

You’re most welcome

[@tahm76]

If you’re doing any online training please let me know

[@MissMicrosoft]

I will do so

[@tahm76]

@@MissMicrosoft please send the details

[@MissMicrosoft]

@@tahm76 please email me at [e-mail] thanks.

[@thamilanban]

Thank you

[@MissMicrosoft]

You’re most welcome 🙏

[@muzniahamed5887]

Good 😍
I am from Sri Lanka🇱🇰🇱🇰🇱🇰

[@MissMicrosoft]

Thank you for watching all the way from Sri Lanka 🇱🇰 😊

[@RahulChauhan-ll9pu]

Please share excel sheet link

[@MissMicrosoft]

Hi Rahul, it's in the description of the video, this is the link: docs.google.com/spreadsheets/d/1anNRaxqKLS59cJwQlZR6GrOoj1uuKygc/edit?usp=sharing&ouid=108573460979392589182&rtpof=true&sd=true: