Skip to main content Help with accessibility Skip to main navigation
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