These Microsoft Excel tips & tricks range from Microsoft Copilot, Formulas, Checkboxes, Python in Excel, Power Query plus many more! These Excel tips will save you time and make you a more efficient Excel user. Make sure to learn and apply at least 1 tip from today’s podcast show.
Click on the play button to listen to this Excel podcast show…
Table of Contents
Listen to the Best Microsoft Excel Tips & Tricks in 2024
You can subscribe to the show on iTunes to get automatic updates so you don’t miss out on these awesome interviews and Excel insights!
Guests in Order of Appearance with links
1. Oz Du Soleil from ExcelOnFire
[/two_third_last]
Best Excel Tip & Trick in 2024:
Use what you need for what you are trying to do…
2. Bill Jelen from MrExcel
Best Excel Tip & Trick in 2024:
LET function & Check Performance
6. Jeff Lenning from Excel University
Best Excel Tip & Trick in 2024:
Power Query (Percentage vs Grand Total)
9. David Fortin from Piggy Bank Accountant
Best Excel Tip & Trick in 2024:
Build your own library of reusable components (Chart Templates, Worksheet Templates, LAMBDA custom functions, Power Query custom functions, Office Scripts or VBA)
12. Melissa Compton from MelCompton
Best Excel Tip & Trick in 2024:
Create a Custom Tab on the Excel Ribbon & add your frequently used commands
15. Bernard Obeng Boateng from Finex Skills Hub
Best Excel Tip & Trick in 2024:
Turn US dates to non-US date format with Text to Columns
20. David Benaim from Learn Spreadsheets YouTube
Best Excel Tip & Trick in 2024:
GROUPBY & PIVOTBY functions
21. Yolanda Cuesta from Excel Contabilidad y TIC
Best Excel Tip & Trick in 2024:
23. Cristian Angyal from Romania Power BI and Modern Excel User Group
Best Excel Tip & Trick in 2024:
Power Query Merge Queries & Join Kinds (Left Semi Join & Right Semi Join)
24. Bryan Hong from MyExcelOnline
Best Excel Tip & Trick in 2024:
Find, by a formula, the address of a value in a rectangular range!
Listen to the MyExcelOnline Podcast on your favorite platform!
Thanks for Listening!
Thank you for joining me this week. If you have some feedback that you’d like to share, then please leave a note in the comment section below!
If you enjoyed this episode, please share it using the social media buttons you see at the bottom of the post.
Also, please leave an honest review for The MyExcelOnline Podcast on iTunes! Ratings and reviews are extremely helpful and greatly appreciated! They do matter in the rankings of the show, and I read each and every one of them.
Don’t forget to subscribe to the show on iTunes to get automatic updates so you don’t miss out on these awesome interviews and Excel insights!
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.
30 Days - Full Access 
