Availability:In stock
- +

FocusCHOICE: Using Lookup Functions and Formula Auditing in Excel® 2016

Course Specifications

Course Number:


Course Description


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.

Target Student:

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 Content

Lesson 1: Using Lookup Functions and Formula Auditing

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

More Information
SKU 025003-02S
Course Number FOCUS CHOICE
Page Count 44
Product Type Print and Digital Courseware
Isbn 1424628083
Electronic 1
Publication Date 2017-12-15 00:00:00
Curriculum Library Excel
Secondary Category Microsoft Office