Webinar

Mastering the Excel Lookup Functions

Friday, April 11, 2025
2-4 p.m. Central
2 CPE (2 non-technical)

Course code: 25WX-0148
View pricing

Online registration is not available due to server maintenance. Please call 952-831-2707 between 7:30 a.m. and 4:30 p.m. Central to register.

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. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Major subjects

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

Learning objectives

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

Who should take this program?

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

Pricing

Standard Member Fee	$89.00
Standard Nonmember Fee	$89.00

Our records indicate you are a nonmember. If you register, you will be charged $89.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.

Online registration is not available due to server maintenance. Please call 952-831-2707 between 7:30 a.m. and 4:30 p.m. Central to register.