ACPD logo

Excel 2025: New Functions

(1 reviews)
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.

£+vat
1 CPD hours
120 days' access

This course 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 course

      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

    Contents

    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

    3.5
    (1 review)
    5
    4
    3
    2
    1
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.

    You might also like

    Take a look at some of our bestselling courses

    alt

    2025 Autumn Budget

    alt

    2025 Winter Update: UK Tax

    alt

    2025 Tax Bulletin: December

    alt

    The Accountant as Company Secretary

    Got a team of 2 or more?

    Develop and retain a talented finance team with our team subscriptions.

    Use ACPD101 for 10% off any purchase.