What's new in Excel from the last year

2022 had 40 new features in Excel, this webinar from the Excel Community will look at Excel’s new capabilities including commands such as the Navigation pane, how to turn pictures into data and Show Changes to track cell by cell edits as well as newly released functions such as TEXTSPLIT, VSTACK, IMAGE (including how to create a QR code from any website) and how to even create your own custom functions with LAMBDA.

Microsoft MVP David Benaim, who keeps up to date with all new business tech features through our quarterly blog series, will walk us through a digest of the new features in Excel.

First broadcast on 30 March 2023

Resources

• Webinar recording*
• Webinar slides
• Webinar workbook

YouTube videos

• Dynamic array from query parameters
• All 24 dynamic array functions in Excel
• Image function
• Navigation pane & other navigation speed up tricks
• Check performance & reduce excel bloated files
• Data from picture
• Get sheet name in a formula
• Keep header rows and choose cols for FILTER
• Dynamic table of contents no VBA

*This webinar has been recorded with closed captions enabled. In order to enable or disable this feature, please click on the “CC” icon at the bottom of your screen. Please note that the transcript is automatically generated and errors may occur.