[2-Part Series] Excel VLOOKUP Function Series

  • On-Demand
  • Series
From $249.00
Training Includes:
  • Certificate of Attendance
  • All resources and training materials
  • An on-demand recording will be available after each live presentation.

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?

  • Everyone who uses or could use Excel
  • Human resources professionals

  • Business owners

  • Plant managers

  • Finance professionals

  • Operations managers

  • Contract managers

  • Contract administrators

  • Commercial managers

  • Supply chain managers

  • Supplier relationship managers

  • Supply base managers

  • Strategic sourcing managers

  • Procurement managers

  • Supervisors

  • Development staff

  • Program directors
  • Hiring staff
  • Nonprofit chief executives
  • Executive directors
  • Development staff
  • Consultants
  • Marketing staff
  • Fundraising staff
  • School district administrators
  • Charter school board members
  • Principals
  • Assistant principals
  • Department chairs
  • Curriculum specialists
  • Community engagement professionals

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.