Excel - Plain and Simple Lookups

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

This course is an introduction to lookup functions. Learn different types of lookup functions, when to use them, and how to quickly find answers within a dataset. Lookup functions are one of the most frequently used advanced features and this is a great place to start.

 

Upcoming Class Dates and Times

Aug 23, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Sep 14, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Oct 06, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Oct 27, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Nov 18, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Dec 13, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR

Agenda

1 - Outline
  • Make functions and formulas easier to read with named and data easier to access by defining and using range names.
  • Find and return specific values in a dataset with the power of VLOOKUP. One of the most used tools in higher levels of excel
  • Find values from differently structured datasets where VLOOKUP might not work.
  • Use VLOOKUP and HLOOKUP functions with true to find an approximate match.
  • Index and match - learn how to set up and use the powerful lookup function index and learn about the differences from VLOOKUP.