ICAEW.com works better with JavaScript enabled.

What's new in Excel and Sheets over the last year

Author: Excel Community

Published: 05 Sep 2024

Discover new features from Excel and Sheets, released over the last twelve months.
Allow StreamAMG video

This video is provided by StreamAMG. We ask for your permission before anything is loaded as they place a few cookies on our site. For more information on how we handle cookies, please see our privacy policy and cookies policy. To view this content on the website, please accept and continue.

Excel is ever evolving with dozens of new features released yearly, Excel MVP David Benaim will present the new features released over the last twelve months including:

  • Excel’s built in AI engine Copilot
  • Ways to reduce bloated file sizes
  • Improvements to cross file linked cells
  • New keyboard shortcuts and updates to collaboration tools
  • Office Scripts – VBA’s successor
  • Built in AI ways to clean misspelled data and new formula auditing features

Note that features released only on the Beta channel will not be showcased.

David will mostly showcase Excel updates but will also show some key Google Sheets updates such as:

  • Convert to table
  • Group by views
  • Allocating columns to take place names or files<

First broadcast on 5 September 2024

Webinar resources

David Benaim resources

Excel videos

Google Sheets videos

Please be aware that this webinar has closed captions enabled. In order to enable 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.

CPD

This webinar could contribute to up to 1 hour of verifiable CPD, so long as you can demonstrate that the content is relevant to your role. Find out more.

 

Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250