Excel 365 Mastering the XLOOKUP Function

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

This course is a deep dive into the new XLOOKUP function. Students will learn about the different uses for XLOOKUP. The lessons in this course provide examples of how to use XLOOKUP to do vertical and horizontal lookups, return multiple values, two-way lookups, and compare two lists. This course is ideal for any Office 365 user who wants to move beyond VLOOKUP and master this exciting new tool.

 

Upcoming Class Dates and Times

Aug 03, 2021
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Aug 25, 2021
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Sep 17, 2021
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Oct 08, 2021
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Nov 01, 2021
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Nov 24, 2021
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Dec 17, 2021
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR

Who Should Attend

This course is designed to provide a deep dive into the new XLOOKUP function for Office 365 users who are interested in moving beyond conventional lookup functions and are already comfortable and familiar with using Excel functions. This course can also be helpful for Office 365 users who have never used a lookup function before—XLOOKUP is a great place to start.

Course Objectives

    The goal of this course is to introduce students to the new XLOOKUP function. Students will learn the many different ways that XLOOKUP can be used for looking up data and comparing lists. At the end of the course students will be prepared to use the XLOOKUP function to do vertical and horizontal lookups, return multiple values, two-way lookups, and compare two lists.

Agenda

1 - Lessons
  • What is XLOOKUP? - Learn about the new XLOOKUP function and how to use it for vertical lookups.
  • Use XLOOKUP to Return Two or More Values - Learn how to use XLOOKUP to return two or more values.
  • Use XLOOKUP for a Horizontal lookup - Learn how to use XLOOKUP for a horizontal lookup.
  • Use XLOOKUP Match Modes - Learn how to use XLOOKUP match modes.
  • Use XLOOKUP Search Modes - Learn how to use XLOOKUP search modes.
  • Use XLOOKUP for a Two-Way Lookup - Learn how to use XLOOKUP for a two-way lookup.
  • Use XLOOKUP to Compare Two Lists - Learn how to use XLOOKUP to compare two lists.