ACPD logo

Excel: Formula Enhancements

(3 reviews)
by Alan Murray

Part of a series on 2024 Excel. Excel continues to evolve with exciting new features that enhance how we use and manage formulas. This short course explores the latest formula enhancements available in both Excel Desktop and Excel for the Web.

£100+vat
1 CPD hours
120 days' access

This course will enable you to

  • Use Stale Value formatting to highlight outdated values
  • Use the Value Preview Tooltip to preview the evaluation of parts of a formula
  • Explore the Advanced Formula Environment
  • Take advantage of the enhanced formula experience in Excel for the Web
  • About the course

      Using formulas can seem daunting but the benefits of utilising them to their full potential far outweigh any effort taken to get to grips with them, especially now that the technology practically does it all for you.

      This short course looks at some of the latest advancements in how formulas are used. Innovative features include Stale Value formatting for managing manual calculations and the AI-driven Formula From Examples in Excel for the web, which simplifies the process by generating formulas for you.

    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

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