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 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
VLOOKUP: an Excel Function that Will Save You Hours. Extract the data you need from huge spreadsheets.
As staffing shortages persist and you are asked to accomplish more, you can no longer afford to search for the right detail from hundreds or thousands of records. Instead, you can 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, the sixth-period class of a student on the football team, or the cost center for an invoice. People who get the best jobs and promotions aren’t just familiar with Excel; they are masters of spreadsheets.
In only 90 minutes, you will learn powerful functions and related features that will save you hours. Explore these capabilities during our upcoming webinar series:
- 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
CareerLearning Quality Commitment
CareerLearning wants you to be satisfied with your purchase. If this program does not meet your expectations, email us at support@careerlearning.com.