#excel2020

[thelearningzone]

New Excel Linked Data Types!

Excel Tips and Tricks A number of new Linked Data Types are available in Excel. Data Types are external data sources that you can link to your Excel spreadsheet. Data is then updated automatically when the spreadsheet is refreshed. Credit Sele Training

[thelearningzone]

Excel Dynamic Array Formulas

Excel Tips and Tricks In January 2020 Microsoft released Dynamic Array Formulas for Excel. I'll show you the six new functions available to Office 365 Excel users. These functions are a dramatic change for Excel spreadsheets and that is why it took 2 years for Microsoft to release them. The da

[thelearningzone]

50 Ultimate Excel Tips and Tricks for 2020

Excel Tips and Tricks The ultimate compilation of Excel tips and tricks to enhance your productivity using Excel. Updated for 2020! I've combined long-established tips and tricks with new ones Microsoft added in 2019 and 2020. Credit Sele Training

[tomojitbose]

Array function (sum and v lookup 2020)