2025-26 Update: Excel

by

Level up your Excel skills with the latest updates, from AI-powered Copilot to new regex and calculation functions, plus improved accessibility features.

£100 +VAT

1 CPD hours

120 days’ access

Use ACPD101 for 10% off any purchase.

2025-26 Update: Excel

£100 +VAT

4 CPD hours 120 days’ access
Use ACPD101 for 10% off any purchase.

2025-26 Update: Excel

This course is not currently available. To find out more, please get in touch.

This course will enable you to

  • Navigate the Copilot pane and in-grid AI experiences
  • Use new functions like TRIMRANGE, DETECTLANGUAGE, and simplified LAMBDA syntax
  • Apply REGEXEXTRACT, REGEXREPLACE, and REGEXTEST to handle data patterns efficiently
  • Enable and customise dark mode to improve focus and accessibility
  • Auto-refresh PivotTables for up-to-date reporting

About the course

Microsoft Excel is the accountant’s bread and butter, but with frequent updates and new features, it’s easy to fall behind. From emerging AI tools to evolving formula functions, keeping up with what matters can feel overwhelming – especially when time is short and deadlines are pressing.

This course explores the latest Excel developments for 2025–26, including Copilot’s AI-powered features, new in-grid experiences, and a range of powerful functions like TRIMRANGE, DETECTLANGUAGE, and the new REGEX suite. You’ll also look at accessibility upgrades, dark mode customisation, and automation options like auto-refreshing PivotTables.

By the end, you’ll be able to work more efficiently in Excel, take advantage of new functionality with confidence, and deliver cleaner, faster, and more professional spreadsheet work.

Contents

Copilot

Copilot integration in Excel
Working with context
Explaining formulas
Generating formulas with Copilot
Cleaning data

New functions

Simpler lambdas
TRIMRANGE
Running totals
Changing with the times
The dot
Conditional formatting with trimmed ranges
Upgraded functions
Dynamic array support
DETECTLANGUAGE and TRANSLATE

Regex functions

Regex
REGEXEXTRACT
REGEXREPLACE
REGEXTEST
XLOOKUP

Making things easier

The dark side
Auto Refresh
Check Performance
Accessibility Checker
Show Changes
Microsoft Forms

How it works

Author

Alan Murray

Alan Murray

Alan has over 20 years” experience as an Excel trainer and loves to help companies improve their business processes and learn how to harness the power of Excel.