Welcome, Guest

Formula Auditing in Excel: Mini Masterclass

Overview

This course, Formula Auditing in Excel, is an exploration into the intricacies of managing and understanding complex formulas, designed to empower you with the skills to ensure accuracy and reliability in spreadsheet calculations.

In this course, you will learn how to use the formula auditing tools, Trace Precedents and Trace Dependents, to show how an individual cell links to other cells. You'll explore different options available in the Formula Auditing group, such as Show Formula, Evaluate Formula and Error Checking, to detect and solve issues with formulas.

Learning Outcomes

  • Use the formula auditing tools, Trace Precedents and Trace Dependents, to show how an individual cell links to other cells.  
  • Use the additional options available in the Formula Auditing group, such as Show Formula, Evaluate Formula and Error Checking, to detect and solve issues with formulas.
  • Install the Inquire Add-In and use it to audit the data thoroughly to find issues and improve the reliability of the spreadsheet.

Audience

Individuals looking to further their knowledge of Excel.