Mastering the Excel Lookup Functions (C62146)

Log In to Register

Cancellation Policy

Please note that this webinar Is from a third party vendor, CPA Crossings. We strongly recommend registering no later than one-hour before the webinar begins. Please contact CPA Crossings webinar hotline if you do Not receive your webinar invitation via email within five minutes after registering:  877-370-2220 ext. 1. Thank you.

Date(s):

04/08/2024

Registration Open:

12:00 AM - 2:30 PM

Time:

2:30 PM - 4:30 PM

Facility:

 Online

Meeting Type:

Webinars

CPE Credit:

2.00

Field(s) Of Study:

Computer Software and Applications (2.00)

Level of Knowledge:

Basic

Price:

Member: $89.00
Nonmember: $109.00

Individual Discounts:

Not Available

Overview

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

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

Speaker(s)

Prerequisites

None