October 22-25, 2023 / Caesars Palace / Las Vegas, NV

Agenda

Mastering Excel’s VLOOKUP & More!

Sep 14 2022

9:00 AM - 10:15 AM EDT

Coronado K

Advanced

Spending too much time manipulating spreadsheets and pairing the right information in tables you use? VLOOKUP gets you there faster. And, if you use VLOOKUP regularly, there are newer options you won’t want to miss. In this session, we will explore the functionality of VLOOKUP, and compare it with INDEX and MATCH, FILTER, XLOOKUP, and more options.

Learning Objectives:

  • Using VLOOKUP to compare and combine data tables
  • Building a more sophisticated lookup with INDEX and MATCH
  • Using new functions with XLOOKUP and FILTER
  • Understanding the relationships between multiple data tables in Excel

Speakers

Neil Malek

Knack Training, LLC

- Principal

© Diversified Communications. All rights reserved.