Using Lookup Functions and Formula Auditing in ExcelŽ 2016
CLASS DATE(s):
Request a Class

COURSE LENGTH: 1/2

COURSE COST: $175.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

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 AND PREREQUISITES

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 cost listed does not include the cost of courseware. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions. Course is subject to a minimum enrollment to run. This course may run as a live distance learning class if the minimum enrollment is not met.

COURSE TOPICS:


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