[2-Part Series] Excel VLOOKUP Function Series

with
Jackie Kiadii
  • Live Session
  • Series
$259.00
  • September 23, 2021, 12:30 pm   EST
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 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
When:
Thursday, September 23, 2021; 12:30 PM Eastern and 2:00 PM Eastern
2 Sessions scheduled for 90 minutes including question and answer period.

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?

  • Everyone who uses or could use Excel, including:

    • 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