028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

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

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 in 2020 and beyond.

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

Click the play button below to listen to this podcast show and feel free to share it with your friends & colleagues:

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!

Here are the Best Microsoft Excel Tips & Tricks in 2020 in Order of Appearance:

The Best Microsoft Excel Tips & Tricks in 2020

1. Bill Jelen from MrExcel.com

Best Excel Tip & Trick in 2020:

Lambda Function
More on the NEW Lambda Function

The Best Microsoft Excel Tips & Tricks in 2020

2. Jeff Lenning from Excel-University.com

Best Excel Tip & Trick in 2020:

FILTER Function
More on the FILTER Function

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

3. Jon Peltier from PeltierTech.com

Best Excel Tip & Trick in 2020:

Source data on Charts

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

4. Leila Gharani from Xelplus.com

Best Excel Tip & Trick in 2020:

Import from PDF in PQ
More on PDF to Excel

The Best Microsoft Excel Tips & Tricks in 2020

5. Oz Du Soleil from OzDuSoleil.com

Best Excel Tip & Trick in 2020:

Check data on AI Tools

The Best Microsoft Excel Tips & Tricks in 2020

6. Jon Acampora from ExcelCampus.com

Best Excel Tip & Trick in 2020:

Learn Power Query Webinar
More on Power Query

The Best Microsoft Excel Tips & Tricks in 2020

7. Alan Murray from Computergaga.com

Best Excel Tip & Trick in 2020:

Dynamic Arrays: SORT & SORTBY Fucntions
More on Dynamic Arrays

The Best Microsoft Excel Tips & Tricks in 2020

8. Chandoo from Chandoo.org

Best Excel Tip & Trick in 2020:

Update Charts in PowerPoint

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

9. Celia from Solve and Excel

Best Excel Tip & Trick in 2020:

Copy PQ query to another workbook

The Best Microsoft Excel Tips & Tricks in 2020

10. Bryan Hong from MyExcelOnline.com

Best Excel Tip & Trick in 2020:

Never stop learning Excel

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

11. Chris Newman from The Spreadsheet Guru

Best Excel Tip & Trick in 2020:

Countif errors + conditional formatting
More on COUNTIF errors

The Best Microsoft Excel Tips & Tricks in 2020

12. Wyn Hopkins from AccessAnalytic.com.au

Best Excel Tip & Trick in 2020:

Excel 365

The Best Microsoft Excel Tips & Tricks in 2020

13. Ryan Wells from Wellsr.com

Best Excel Tip & Trick in 2020:

Use VBA to send emails via Gmail

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

14. Yolanda Cuesta from Excelcontabilidadytic.com/

Best Excel Tip & Trick in 2020:

Ideas

The Best Microsoft Excel Tips & Tricks in 2020

15. Sohail Anwat from EarnAndExcel.com

Best Excel Tip & Trick in 2020:

Don’t be an Excel expert

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

16. Sumit Bansal from TrumpExcel.com

Best Excel Tip & Trick in 2020:

Automate work by saving Templates & Macros
More on saving Templates & Macros

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

17. Kat Norton from Miss Excel

Best Excel Tip & Trick in 2020:

Filter function

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

18. Boris Hristov from 365labs.com

Best Excel Tip & Trick in 2020:

Line Charts tip

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

19. Cristiano Galvao from Genecsis.com

Best Excel Tip & Trick in 2020:

UNIQUE Function

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

20. Ivett Szabados from Excelneked.hu

Best Excel Tip & Trick in 2020:

F9 formula evaluation

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

21. Georg Lazar from Albertexcel.com

Best Excel Tip & Trick in 2020:

Problem solving in Excel

The Best Microsoft Excel Tips & Tricks in 2020

22. George Mount from GeorgeJMount.com

Best Excel Tip & Trick in 2020:

Power Query: Data Preview Feature

The Best Microsoft Excel Tips & Tricks in 2020

23. Jordan Goldmeier

Best Excel Tip & Trick in 2020:

Use Instagram

The Best Microsoft Excel Tips & Tricks in 2020

24. Kasper Langmann from Spreadsheeto.com

Best Excel Tip & Trick in 2020:

Go to Special

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

25. Paula from Theexcelclub.com

Best Excel Tip & Trick in 2020:

Excel 365

The Best Microsoft Excel Tips & Tricks in 2020

26. Danielle Stein Fairhurst from PlumSolutions.com.au

Best Excel Tip & Trick in 2020:

Keep learning! 

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

27. Avi Singh from Avising.com

Best Excel Tip & Trick in 2020:

Learn to Change the Game

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

28. Greg Wittmeier  from MyExcelOnline.com

Best Excel Tip & Trick in 2020:

Debugging VBA Code

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

29. John MacDougall from Howtoexcel.org

Best Excel Tip & Trick in 2020:

Lambda Function

The Best Microsoft Excel Tips & Tricks in 2020

30. Mark from ExcelOffTheGrid.com

Best Excel Tip & Trick in 2020:

View > New Window

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

31. John Michaloudis from MyExcelOnline.com

Best Excel Tip & Trick in 2020:

4-Step Framework to Advance Excel Level in 30 days!

028: The Best Microsoft Excel Tips & Tricks in 2020! | MyExcelOnline

Listen to the MyExcelOnline Podcast on your favorite platform!

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

026: The Best Microsoft Excel Tips & Tricks in 2020

Free Resources!

Excel Tutorial Blog:

Learn all the essential tips to get you up and running and using Excel to its full potential.  Choose from Formulas, Pivot Tables, Charts, Analysis, Shortcuts, Macros plus more

>> CLICK HERE TO VIEW

Free Excel Webinars:

Learn the power of Formulas, Macros & VBA and Pivot Tables with our free webinars!

>> CLICK HERE TO VIEW NOW

 

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.

If you have any questions you can send me an email to [email protected]

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!

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

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