Menu

Mastering the Excel Lookup Functions

Overview

This course will be available for 90 days from your date of purchase. 

In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities.

Prerequisites

None

Objectives

After attending this presentation you will be able to: 

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

Highlights

  • A review of the various lookup functions, beyond VLOOKUP
  • Learn which lookup works best for your situation
  • How to apply the many lookup functions
  • Discover 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

Register Now

Materials are generally available 3 days in advance of an event. Once you have downloaded the manual, we are unable to cancel your registration.

Event Code:

RCPE782

2 CPE Credits
Computer Software & Applications: 2 Credits

Registration

Member Price:
$99
Non-member Price:
$129

Instructor

Bryan Smith