028: The Best Microsoft Excel Tips & Tricks in 2020!
Description
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:
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:

1. Bill Jelen from MrExcel.com
Best Excel Tip & Trick in 2020:
Lambda Function
More on the NEW Lambda Function

2. Jeff Lenning from Excel-University.com
Best Excel Tip & Trick in 2020:
FILTER Function
More on the FILTER Function


4. Leila Gharani from Xelplus.com
Best Excel Tip & Trick in 2020:
Import from PDF in PQ
More on PDF to Excel


6. Jon Acampora from ExcelCampus.com
Best Excel Tip & Trick in 2020:
Learn Power Query Webinar
More on Power Query

7. Alan Murray from Computergaga.com
Best Excel Tip & Trick in 2020:
Dynamic Arrays: SORT & SORTBY Fucntions
More on Dynamic Arrays

