Excel: Formula Enhancements

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.

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

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

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

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

  • Formula enhancements
    • Stale Value formatting
    • Formatting stale values
    • Value Preview Tooltip
    • The Advanced Formula Environment
    • Using the AFE in practice
    • Managing names and LAMBDA functions
    • Formula by Example
    • Excel for the web

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 days120 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 moreLearn moreLearn 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 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
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 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
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 Updates 2024-25