Excel 2025: New Functions

by Alan Murray

Part of a series on 2025 Excel. Modern formulas are more powerful and more readable than ever. Get ready for a deep dive into how smarter formulas and range handling can boost your spreadsheets and change the way you work.

price £150+vat
cpd hours 1 CPD hour
access 120 days' access

This module will enable you to

  • Take advantage of Excel's new support for simplified LAMBDA syntax
  • Simplify ranges for calculations using TRIMRANGE
  • Trim ranges quickly and effectively with the dot operator
  • Connect dynamic arrays directly to charts
  • Apply DETECTLANGUAGE and TRANSLATE functions to multilingual data

About the module

New Excel functions like TRIMRANGE and version 2 text functions simplify what once required complex workarounds.

This short course demonstrates how smarter formulas and range handling can help you write faster, cleaner, and more maintainable spreadsheets. Your Excel worksheets are about to become more powerful and more readable than ever.

Look inside

imac
slide-1
slide-2
slide-3
slide-4
slide-5
slide-1-thumbnail
slide-2-thumbnail
slide-3-thumbnail
slide-4-thumbnail
slide-5-thumbnail

Contents

  • 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

How it works

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.

Reviews

Recommended

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Pick n Mix

All you need for this year's CPD.

Licence

All you need for this year and more.

Team

Keep your whole team up to date.
Access to this course
Total CPD unitshourshours1 unitshourshours21 units20 hours21 hours1,500+ unitshourshours1,500+ unitshourshours
Access period120 days365 days12 months12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more!
Account manager on hand to support your team's needs
Learn more Learn more Learn more
Recommended

Why not upgrade?

Find the best way to complete your CPD

Licence

All you need for this year and more.
Access to this course
Total CPD unitshourshours1,500+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more!
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?
Access to this course
Total CPD unitshourshours1 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more!
Account manager on hand to support your team's needs

Why not upgrade?

Find the best way to complete your CPD

Pick n Mix

All you need for this year's CPD.
Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period365 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more!
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Team

Keep your whole team up to date.
Access to this course
Total CPD unitshourshours1,500+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more!
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Licence

Recommended

All you need for this year and more.
Access to this course
Total CPD unitshourshours1,500+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more!
Account manager on hand to support your team's needs
Learn more

Course

Need just a few unitshourshours?
Access to this course
Total CPD unitshourshours1 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more!
Account manager on hand to support your team's needs

Pick n Mix

All you need for this year's CPD.
Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period365 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more!
Account manager on hand to support your team's needs
Learn more

Team

Keep your whole team up to date.
Access to this course
Total CPD unitshourshours1,500+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more!
Account manager on hand to support your team's needs
Learn more

More in this series

Take a look more modules from the series: Excel 2025