Pinterest Pixel

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

John Michaloudis
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

 

 

 

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

9. Paul Barnhurst from TheFP&AGuy

Best Excel Tip & Trick in 2023:

Dynamic Arrays

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

17. Bob Umlas from Excel Trainer & Consultant

Best Excel Tip & Trick in 2023:

Zoom Slider at 39%

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 it


Founder & Chief Inspirational Officer

at

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.

See also  023: Top Microsoft Excel Tips & Tricks of 2018!

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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!

Share to...