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: Unfortunately we have encountered a technical issue that is limiting our access to some on-demand recordings on the Zoom platform. We are currently working with Zoom to establish a resolution but as it stands we do not have a timeframe for this. We apologise for the inconvenience.
• 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