Pinterest Pixel

Excel Podcast #33: The Best Microsoft Excel Tips & Tricks in 2023

We have rounded up the best Microsoft Excel experts & MVPs from around the world to share... read more

John Michaloudis
Posted on

Overview

Excel Podcast #33: The Best Microsoft Excel Tips & Tricks in 2023 | MyExcelOnline

We have rounded up the best Microsoft Excel experts & MVPs from around the world to share their best Microsoft Excel tips & tricks in 2023!

These Microsoft Excel tips & tricks range from the GROUPBY function, Dynamic Arrays, XLOOKUP, Checkboxes, ChatGPT, 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…

Listen to the Best Microsoft Excel Tips & Tricks in 2023

Listen on Web Browser >>

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

 

See also  007: Data Cleansing & Analysis with Oz du Soleil

 

 

The Best Microsoft Excel Tips & Tricks in 2023

 

The Best Microsoft Excel Tips & Tricks in 2023

1. Bill Jelen from MrExcel

Best Excel Tip & Trick in 2023:

GROUPBY Function

The Best Microsoft Excel Tips & Tricks in 2023

2. Danielle Stein Fairhurst from PlumSolutions

Best Excel Tip & Trick in 2023:

Dynamic Arrays

The Best Microsoft Excel Tips & Tricks in 2023

3. Ken Puls from ExcelGuru

Best Excel Tip & Trick in 2023:

Copy and paste using the Office Clipboard

The Best Microsoft Excel Tips & Tricks in 2023

4. Oz Du Soleil from ExcelOnFire

Best Excel Tip & Trick in 2023:

Learn how to cultivate fake data

The Best Microsoft Excel Tips & Tricks in 2023

5. Jeff Lenning from Excel-University

Best Excel Tip & Trick in 2023:

Dynamic Array GROUPBY Function

The Best Microsoft Excel Tips & Tricks in 2023

6. Kat Norton from Miss Excel

Best Excel Tip & Trick in 2023:

Multiple consecutive columns of results using XLOOKUP

The Best Microsoft Excel Tips & Tricks in 2023

7. Jon Acampora from ExcelCampus.com

Best Excel Tip & Trick in 2023:

Checkboxes in Cells

The Best Microsoft Excel Tips & Tricks in 2023

8. Alan Murray from ComputerGaga.com

Best Excel Tip & Trick in 2023:

AI for Excel using ChatGPT and ExcelLabs Add-In

The Best Microsoft Excel Tips & Tricks in 2023
The Best Microsoft Excel Tips & Tricks in 2023

10. George Mount from StringfestAnalytics

Best Excel Tip & Trick in 2023:

UNPIVOT other columns using Power Query

The Best Microsoft Excel Tips & Tricks in 2023

11. Celia Alves from SolveAndExcel

Best Excel Tip & Trick in 2023:

Dynamic Arrays, CTRL+SHIFT+U & ExcelLabls Add-In

Excel Podcast #33: The Best Microsoft Excel Tips & Tricks in 2023 | MyExcelOnline

12. Georg Lasar from AlbertExcel

Best Excel Tip & Trick in 2023:

FILTER Function

The Best Microsoft Excel Tips & Tricks in 2023

13. Cristiano Galvao from ExcelTurbo

Best Excel Tip & Trick in 2023:

Follow all of the Excel experts & attend the online & in person events

The Best Microsoft Excel Tips & Tricks in 2023

14. Richard Nero from DevelopExLtd

Best Excel Tip & Trick in 2023:

Power Query

The Best Microsoft Excel Tips & Tricks in 2023

15. Andrew Moss from GlobalExcelSummit

Best Excel Tip & Trick in 2023:

Stay up to date with Microsoft Excel’s new features!

 

The Best Microsoft Excel Tips & Tricks in 2023

16. Yolanda Cuesta from Excelcontabilidadytic.com

Best Excel Tip & Trick in 2023:

Translate text into different languages

The Best Microsoft Excel Tips & Tricks in 2023
The Best Microsoft Excel Tips & Tricks in 2023

18. Bryan Hong from MyExcelOnline

Best Excel Tip & Trick in 2023:

ChatGPT

The Best Microsoft Excel Tips & Tricks in 2023

19. Frédéric LE GUEN from Excel Tutorial

Best Excel Tip & Trick in 2023:

Find a drop down list in a worksheet

 


Excel Podcast #33: The Best Microsoft Excel Tips & Tricks in 2023 | MyExcelOnline

RIP Ivett Szabados from Excelneked.hu

Listen to the MyExcelOnline Podcast on your favorite platform!

The Best Microsoft Excel Tips & Tricks in 2023

026: The Best Microsoft Excel Tips & Tricks in 2020

026: The Best Microsoft Excel Tips & Tricks in 2020

026: The Best Microsoft Excel Tips & Tricks in 2020

Excel Podcast #30: The Best Microsoft Excel Tips & Tricks in 2021!

Excel Podcast #30: The Best Microsoft Excel Tips & Tricks in 2021!

 

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!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

See also  029: 101 Best Excel Tips & Tricks Book Launch + My Top 10 Tips & Tricks
Excel Podcast #33: The Best Microsoft Excel Tips & Tricks in 2023 | MyExcelOnline
Founder & Chief Inspirational Officer at MyExcelOnline.com

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 Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!