Webinar: Mastering the Excel Lookup Functions
WC2782 | 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
- 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.
- We recommend you log in early to ensure you are ready to go when the presentation begins.
- 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