Microsoft® Certified Trainer and Excel expert Jackie Kiadii will tell you how to harness the power of lookup functions. You will learn how to extract specific data from massive spreadsheets quickly and accurately.
What You'll Learn:
- How to create named ranges
- VLOOKUP function
- Exact and approximate matches
- VLOOKUP to match data from two workbooks
- MATCH function
- INDEX function
- XLOOKUP function
Training Overview
Finally, discover how to look up data using Excel. Find the specific information you need from a spreadsheet.
People who get the best jobs and promotions aren’t just familiar with Excel; they are masters of spreadsheets. They pop information out of massive data sets with the ease of a magician plucking the selected card from a deck.
As the Delta variant of COVID-19 and staffing shortages worsen, you can no longer afford to look for the right detail from hundreds or thousands of records. Instead, you need to get Excel to do the work for you.
For example, you may want to retrieve the customer’s name associated with a particular order number, the department of an employee who responded to a survey, or the cost center for an invoice.
In only 90 minutes, you can discover powerful lookup functions and related features that will save you hours:
- How to create named ranges
- VLOOKUP function
- Exact and approximate matches
- VLOOKUP to match data from two workbooks
- MATCH function
- INDEX function
- XLOOKUP function
Who Should Attend?
|
|
Expert Presenter
Jackie Kiadii
-
Founder of Phoenix Computer Consultants, LLC, an Atlanta-based IT services firm
-
Helping clients leverage technology to increase their productivity and profitability since 2001
-
Provides curriculum development, consulting, and training in Microsoft 365® applications
-
Microsoft® Certified Trainer and Microsoft® Certified Expert – Excel