Course Code: 16900

Using Lookup Functions and Formula Auditing in Excel® 2016

Class Dates:
1/2 Days
Class Time:
Virtual Instructor-Led Training, Instructor-Led Training


  • Course Overview
  • This course will help you develop the ability to create the advanced functions and formulas you need to perform complex calculations in Excel. In addition, it will give you the skills to audit your workbook content to find, troubleshoot, and correct errors or issues in your Excel data.
  • Audience
  • This course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features.


Course Details

  • Topic A: Use Lookup Functions
  • Lookup Functions
  • The VLOOKUP Function
  • The HLOOKUP Function
  • The MATCH Function
  • The INDEX Function
  • The TRANSPOSE Function
  • How to Use Lookup Functions
  • Using Lookup Functions
  • Topic B: Trace Cells
  • Precedent and Dependent Cells
  • The Trace Precedents and Trace Dependents Commands
  • Trace Arrows
  • The Go To Dialog Box and Trace Arrows
  • The Remove Arrows Options
  • How to Trace Precedent and Dependent Cells
  • Tracing Precedent and Dependent Cells
  • Topic C: Watch and Evaluate Formulas
  • The Watch Window
  • Formula Evaluation
  • The Evaluate Formula Dialog Box
  • How to Watch and Evaluate Formulas
  • Watching and Evaluating Formulas