2025-26 Update: Excel
Level up your Excel skills with the latest updates, from AI-powered Copilot to new regex and calculation functions, plus improved accessibility features.
£150 +VAT
2025-26 Update: Excel
£150 +VAT
365 days’ access
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
Author
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.
14 reviews for 2025-26 Update: Excel
You might also like
Take a look at some of our bestselling courses
David Atkins –
The course was really useful and the tutor was fantastic
Malgorzata Kostecka –
very interesting and student-friendly
Jennifer Quigley –
Really enjoyed this course. Informative and moved at the right pace. It’s good to have notes to download for future reference. I’d recommend the course.
Edwin Parr –
The course gave me some new idea’s on innovations I can make to my spreadsheets and formulae
Terry Hedditch –
The presenter was clear and engaging. The course was well‑structured and explained the new Excel 2025–26 features in a straightforward, easy to understand way.
Daragh Solan –
This is a really useful course on some additional functions and features of excel.
Khurram Shahzad Minhas –
Excellent
Eileen Jenkins –
Very useful – easy to understand
Roxanne MacConnachie –
Really useful. However, I learn best through videos vs reading, and whilst this training did include a lot, even more videos would be helpful.
Stewart Douglas –
Excellent update.
Diane Mary Kenny –
Very useful course presenting and explaining changes and improvements to Excel.
Michelle Capp –
Great session with clear examples and working documents to use whilst following the material presented
Kate Corbett –
Really good presenter. Clear and concise information.
Trevor Hogg –
Excellent concise information on updates