Webinar: Mastering the Excel Lookup Functions

WC844  |  Course  |  Basic  |  Scheduled

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 Exc

Credits

Number of Credits Type of Credits
2.00 Computer Software & Applications

Designed For

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

Prerequisites

None

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

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

Preparation

None

Notes

Webinar Day - HELP and Assistance Instructions

  1. The session will open 30 minutes prior to the start time. At that time, you will receive a reminder email bringing you to your Attendee Dashboard and a link to join the webinar.
  2. We recommend you log in early to ensure you are ready to go when the presentation begins.
  3. IF YOU ARE HAVING TROUBLE LOGGING INTO THE WEBINAR, please call the CPA Crossings Customer Service Team at (877)-370-2220 Ext. #1.

Prices

Member (Early Bird)
$89.00
Non-Member (Early Bird)
$89.00
Member
$89.00
Non-Member
$89.00
Registration for this event has closed. If you have any question or concerns please give us a call at 615-377-3825 or send us an e-mail at registrar@tscpa.com
Return to Events