026: The Best Microsoft Excel Tips & Tricks in 2019!

026: The Best Microsoft Excel Tips & Tricks in 2019!

Author: John Michaloudis interviews Microsoft Excel experts and MVPs about their fa December 19, 2019 Duration: 30:52

In this Christmas Special podcast episode, we round up the best Microsoft Excel experts & MVPs from around the world  to share their best Microsoft Excel tips & tricks in 2019!

These Microsoft Excel tips & tricks are the best that we have received to date and will make you a better and more efficient Excel user.

What is your best Excel tip & trick in 2019? You can share it with us at the bottom of this page in the comments area, we would love to hear it!

Get all the links to these Excel tips by clicking in the show notes here!

 


If you've ever felt stuck in a spreadsheet, staring at rows of data and wondering how to make it work for you, you're in the right place. Learn Microsoft Excel with MyExcelOnline is a conversation with the people who live and breathe this software. Host John Michaloudis sits down with Microsoft Excel MVPs and seasoned experts, pulling back the curtain on the practical skills that transform daily tasks. The discussions move beyond dry theory, focusing instead on the immediate application of tools like Pivot Tables for summarization, Power BI for visualization, and VBA for automation. Each episode unpacks a specific topic-whether it's constructing complex formulas, designing interactive dashboards, or mastering time-saving keyboard shortcuts-with clarity and depth. You'll hear firsthand accounts of problem-solving approaches and clever techniques that these professionals use in their own work. This podcast is built for those who have a foundation in Excel but are eager to push their abilities further, translating raw data into clear insights and streamlined processes. It’s about learning the methods that can turn a beginner or intermediate user into a confident, advanced practitioner, all through the shared experiences of global experts. The tone is accessible and detailed, ensuring every listener can find a tangible takeaway to implement immediately.
Author: Language: English Episodes: 35

Learn Microsoft Excel with MyExcelOnline
Podcast Episodes
003: Xtreme Pivot Table Online Excel Course [not-audio_url] [/not-audio_url]

Duration: 11:30
The Xtreme Pivot Table online course is my flagship Excel course which has 14 different chapters, over 200 short video tutorials and around 10 hours of content. I discuss the different topics that are covered in this cou…
002: Power Query with Ken Puls [not-audio_url] [/not-audio_url]

Duration: 57:44
Ken Puls is an Excel MVP who is the founder of long standing Excel website & forum called ExcelGuru.ca He is an expert in Power Query and has co-authored the book M is for (Data) Monkey: A Guide to the M Language in Exce…
001: VBA & Excel Add-Ins with Chris Newman [not-audio_url] [/not-audio_url]

Duration: 40:13
Chris Newman (aka Chris Macro) is the founder of one of the best looking Excel websites around called TheSpreadhseetGuru.com He is a VBA expert and has created various time saving Excel Add-Ins that have helped thousands…
000: My Excel Story - MyExcelOnline Podcast [not-audio_url] [/not-audio_url]

Duration: 10:33
In this introductory podcast I share with you my story into becoming an Excel expert and tell you about the show´s format and what to expect from this Excel podcast! 👉 Join Our Academy Online Excel Course 👉 Show Notes: h…