Updated on: 09-05-2022
Excel Intermediate/Advanced Formula Auditing and IFERROR Function - Online
At the end of the session all delegates will:
On successful completion of this course you will be able to:
- Use the Formula Auditing options
- Insert the IFERROR function
Topics covered
Formula Auditing and IFERROR Function in Excel
- Error checking formulas and trace errors
- Trace Precedents and Dependents cells
- Use a Watch Window
- Insert an IFERROR function
Formula auditing in Excel allows you to display the relationship between formulas and cells. You can use the IFERROR function to trap and handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error.
Online training will be delivered via MS Teams. You will receive joining instructions before your selected session.
About the course
Course Code | MLCSU-TR0106 |
---|---|
Intended Audience | Regular users of Excel or those who have completed Excel Introduction topics |
Delivery Method | Online |
Required Experience / Training | Comfortable with the content of the Excel Introduction topics Quiet room with access to MS Teams and headset or headphones |
Duration of Training | 1 hour |
Premium Content
This course requires a paid subscription to access. Please login to see if your organisation has a subscription.