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
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
|Intended Audience||Regular users of Excel or those who have completed Excel Introduction topics|
|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|
This course requires a paid subscription to access. Please login to see if your organisation has a subscription.