Mastering the Excel Lookup Functions

Mastering the Excel Lookup Functions

CPE Credit:
2

Overview

Description:
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.
Field of Study:
Computer Software & Applications (2.0 CPE)

Instructor

Instructor:
Bryan L. Smith, CPA.CITP, CISA

Additional Details

Who should attend:
Any Excel user that wants to learn how to use the LOOKUP functions
Program Level:
Basic
Program Content:
The major topics that will be covered in this class include:
  • 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:

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
Prerequisites:
None
Advanced Preparation:
None
Developed By:
DataSmithPro
Format:
Group-Internet-Based
Course Code:
DPBSMEL2

Registration:

$89.00

Attendee Information

Please select one of the following options to register for this webinar:

Our Partners

NASBA Sponsor

Mastering the Excel Lookup Functions

Course Code:
DPBSMEL2
Program Level:
Basic
Description:
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.
Program Content:
The major topics that will be covered in this class include:
  • 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:

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
Who should attend:
Any Excel user that wants to learn how to use the LOOKUP functions
Developed By:
DataSmithPro
Instructor:
Bryan L. Smith, CPA.CITP, CISA
CPE Credit:
2
Field of Study:
Computer Software & Applications (2.0 CPE)
Prerequisites:
None
Advanced Preparation:
None
Format:
Group-Internet-Based

Registration:

$89.00

Attendee Information

Please select one of the following options to register for this webinar:

OR

Register By Phone: Call 877.370.2220 and press “1” for the webinar hotline to register

Price

Single Registration
$89.00

Upcoming Dates

  • 5/22/2025 @ 11:00 AM
  • 6/6/2025 @ 9:30 AM
  • 6/16/2025 @ 10:30 AM
  • 7/1/2025 @ 4:00 PM
  • 7/23/2025 @ 2:30 PM
  • 8/1/2025 @ 9:00 AM
  • 8/11/2025 @ 4:00 PM
  • 9/2/2025 @ 10:30 AM
  • 9/19/2025 @ 3:00 PM
  • 10/11/2025 @ 9:00 AM
  • 10/20/2025 @ 3:30 PM
  • 11/7/2025 @ 1:30 PM
  • 11/17/2025 @ 1:30 PM
  • 12/1/2025 @ 9:30 AM
  • 12/17/2025 @ 4:00 PM
  • 1/10/2026 @ 10:30 AM
  • 1/23/2026 @ 9:30 AM
  • 2/2/2026 @ 3:00 PM
  • 2/20/2026 @ 3:00 PM
  • 3/4/2026 @ 3:00 PM
  • 3/16/2026 @ 2:00 PM
  • 4/1/2026 @ 3:00 PM
  • 4/13/2026 @ 11:30 AM

All times are Eastern Time Zone

Developed By

Your Instructor

Shopping Cart