Pinterest Pixel

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

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

John Michaloudis
Posted on

Overview

We have rounded up 18 of 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 in 2019 and beyond.

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!

Watch our free training video on The Best Microsoft Excel Tips & Tricks

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

See also  The Power of Right Click In Excel

Listen to MORE Excel Podcast Shows >>

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 2019 in Order of Appearance:

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

1. Jeff Lenning from Excel-University.com

Best Excel Tip & Trick in 2019:

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

2. Bill Jelen from MrExcel.com

Best Excel Tip & Trick in 2019:

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

4. Mynda Treacy from MyOnlineTrainingHub.com

Best Excel Tip & Trick in 2019:

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

5. Kasper Langmann from Spreadsheeto.com

Best Excel Tip & Trick in 2019:

Get a second monitor and in the ribbon menu select: View > New Window
026: The Best Microsoft Excel Tips & Tricks in 2019!

6. Alan Murray from Computergaga.com

Best Excel Tip & Trick in 2019:

The new FILTER function in Office 365
026: The Best Microsoft Excel Tips & Tricks in 2019!
026: The Best Microsoft Excel Tips & Tricks in 2019!

8. Danielle Stein Fairhurst from PlumSolutions.com.au

Best Excel Tip & Trick in 2019:

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

9. Bryan Hong from MyExcelOnline.com

Best Excel Tip & Trick in 2019:

XLOOKUP function in Office 365
026: The Best Microsoft Excel Tips & Tricks in 2019!

10. Oz Du Soleil from ExcelOnFire

Best Excel Tip & Trick in 2019:

Think beyond the TIPS!
026: The Best Microsoft Excel Tips & Tricks in 2019!

11. Ryan Wells from Wellsr.com

Best Excel Tip & Trick in 2019:

Custom Message Box Buttons
026: The Best Microsoft Excel Tips & Tricks in 2019!

12. Mark from ExcelOffTheGrid.com

Best Excel Tip & Trick in 2019:

F2 Keyboard Shortcut Key to edit your cell
026: The Best Microsoft Excel Tips & Tricks in 2019!

13. Sohail Anwat from EarnAndExcel.com

Best Excel Tip & Trick in 2019:

Automation with Macros & VBA
026: The Best Microsoft Excel Tips & Tricks in 2019!

14. Randy Austin from ExcelForFreelancers.com

Best Excel Tip & Trick in 2019:

Share and Sync your Macro Enabled Workbook
026: The Best Microsoft Excel Tips & Tricks in 2019!

15. Wyn Hopkins from AccessAnalytic.com.au

Best Excel Tip & Trick in 2019:

Excel User Voice + Excel Tech Community
026: The Best Microsoft Excel Tips & Tricks in 2019!

16. George Mount from GeorgeJMount.com

Best Excel Tip & Trick in 2019:

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

18. John Michaloudis

Best Excel Tip & Trick in 2019:

Global Excel Summit in London – April 21 & 22, 2020

 

Listen to the MyExcelOnline Podcast on your favorite platform!

The Best Microsoft Excel Tips & Tricks in 2019

026: The Best Microsoft Excel Tips & Tricks in 2019

026: The Best Microsoft Excel Tips & Tricks in 2019

026: The Best Microsoft Excel Tips & Tricks in 2019

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.

See also  Not using Quotation Marks for Text in Formulas

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!

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

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!