The One with Mynda Treacy

Power Query Magic

Jul 10, 2021•1 hr 2 min•Season 1Ep. 6

--:--

Listen in podcast apps:

Apple Podcasts

Spotify

Download

Listen to this episode in Metacast mobile app

Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episode description

"I can't think of anyone that uses Excel that wouldn't benefit from using Power Query" - Mynda Treacy

How do you go from art studies in a beachside suburb school, to accountant at two London investment banks to a YouTube following of 326,000!?

Mynda and I cover lots of ground in this conversation. We have had similar journeys working overseas, working for banks, becoming accountants, getting hooked on Excel.

Mynda has a huge following on YouTube and her online training business MyOnlineTrainingHub

I ask the longest and probably oddest "Mpossible" question regarding the treatment of 01/01/1900 date.

We both learn a Power Query feature thanks to Miguel Escobar.

Links:

Power Query Automates Boring Tasks: https://youtu.be/L4BuUzccLpo

Interactive Excel Dashboards with Power Query and Power Pivot: https://youtu.be/TK0CJBaqvnY

For the best experience, listen in Metacast app for iOS or Android