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.
Contents
How it works
Author
Reviews
| Recommended | ||||
Why not upgrade?Find the best way to complete your CPD | CourseNeed just a few unitshourshours? | Pick n MixAll you need for this year's CPD. | LicenceAll you need for this year and more. | TeamKeep your whole team up to date. |
|---|---|---|---|---|
| Access to this course | ||||
| Total CPD unitshourshours | 1 unitshourshours | 21 units20 hours21 hours | 1,500+ unitshourshours | 1,500+ unitshourshours |
| Access period | 120 days | 120 days | 12 months | 12+ 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 | ||
Why not upgrade?
Find the best way to complete your CPD
More in this series
Take a look more modules from the series: Excel Updates 2024-25
