You'll learn how to use powerful lookup and reference functions to find, match, and organize data efficiently, even in large or complex worksheets. The course also emphasizes formula auditing techniques, helping you trace how calculations work, identify errors, and resolve issues that could impact your results. These skills are especially valuable for anyone who relies on Excel for reporting, analysis, or decision-making.

By the end of the course, you'll be able to create advanced formulas, understand how data flows through your workbook, and quickly pinpoint and correct problems to maintain accurate, dependable spreadsheets.

Course Content Includes:

• Using advanced functions such as VLOOKUP, HLOOKUP, MATCH, INDEX, and TRANSPOSE
• Tracing precedent and dependent cells using auditing tools and trace arrows
• Watching and evaluating formulas to identify and resolve errors

Prerequisite: Basic knowledge of Excel®.

This class has two options to participate:

You will be able to select the option that works for you (ONLINE or IN-PERSON) at time of registration.

About the Instructor