On-Demand


2 CPE

Surgent's Mastering the Excel Lookup Functions

On-Demand
2 CPE

Learning Objectives

  • Identify which lookup function works for your needs
  • Distinguish between the many lookup functions
  • Recall how to effectively utilize Excel's lookup functions

Major Topics

  • A review of the various lookup functions, beyond VLOOKUP
  • Which lookup works best for your situation?
  • How to apply the many lookup functions
  • Advanced lookup techniques like nested lookups, approximate matching, and handling errors effectively
  • An in-depth review of the following functions: VLOOKUP/HLOOKUP, XLOOKUP, MATCH / INDEX, XMATCH, INDIRECT, FILTER, SORT/SORTBY, UNIQUE
  • An overview of some newer functions

CPE Credits Available

2 CPE
2
Computer Software & Applications

Things to Know About This Course

Course Level

  • Basic

Professional Area of Focus

  • Technology

Prerequisites

None

Advanced Preparation

None

Intended Audience

Any Excel user that wants to learn how to use the LOOKUP functions

Provider

Surgent CPE

Purchase This Course

  • COCPA Member

    $ 109 109
    Join
  • COCPA Non-Member

    $ 142 142
    Your Price

Please login to register.