Excel 365 Advanced Lookup Functions

Course Overview

This course is a more advanced session on lookup functions in Microsoft Excel. Students will use the VLOOKUP function in a variety of different ways to quickly find answers within a dataset. The course will also introduce a variety of useful functions regarding formula and error management. Lookup functions are one of the most frequently used advanced features in Excel, and this course will expand your knowledge of their power.

Who Should Attend

This course is intended for students who are already familiar with the basics of lookup functions and are looking to take their skills to the next level. It should be noted that using lookup functions requires a fair amount of experience writing formulas and a solid understanding of how datasets are structured, so this course is not recommended for beginners.

Course Objectives

The goal of this course is to teach students how to quickly find specific information in large datasets. Students will go beyond a basic VLOOKUP function to learn how to find data based on multiple criteria, or data based on partial information. This course will help guide students to unlock the full potential of lookup functions

Course Outline

1 - Lessons

  • Using Advanced Lookup Functions - Learn how to use the VLOOKUP and HLOOKUP functions with TRUE to find an approximate match.
  • Using VLOOKUP to Compare Two Lists- Learn how to compare two lists with VLOOKUP and hide #N/A errors with the IFNA function.
  • Using VLOOKUP with Multiple Criteria - Learn how use combine VLOOKUP and CONCAT to locate values based on multiple columns and use wildcards with VLOOKUP to retrieve information based on a partial match.
  • Using INDEX and MATCH - Learn how to create a combined INDEX and MATCH formula.
  • Using FORMULATEXT to Reveal a Formula - Learn how to return a formula as a text string from a given reference.
  • Excel ISFORMULA Function - Learn how to determine if specified cells contain formulas.

Price: $49.95

Class times are listed Eastern time.

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Cart When Time Where How
11/09/2020 11:00AM - 12:00PM Online LIVE LNL
12/11/2020 4:00PM - 5:00PM Online LIVE LNL
12/28/2020 11:00AM - 12:00PM Online LIVE LNL

Class times are listed Eastern time

This class is part of our LearnNow Pass. Click here for more details.