Excel: Lookup Functions in Depth
Offered By: LinkedIn Learning
Course Description
Overview
Master some of the most powerful lookup functions in Microsoft Excel, including VLOOKUP, INDEX, XMATCH, and XLOOKUP.
Syllabus
Introduction
- Introduction
- Locate data with the MATCH function
- Retrieve information by location with the INDEX function
- Use the MATCH and INDEX functions together
- Use the new XMATCH function: Expanded and improved MATCH
- Structure data for use with lookup functions
- Find approximate and exact matches with VLOOKUP and HLOOKUP
- Use the new XLOOKUP function for exact matches
- Use the new XLOOKUP function for approximate matches
- New and expanded capabilities using XLOOKUP
- Find table-like information within a function using CHOOSE
- Use the SWITCH function for formula-embedded selection
- Extract and count unique entries from a list using the UNIQUE function
- Filter data and return matching records with the FILTER function
- Use the SORT and SORTBY functions to create new lists
- Use INDIRECT to return references specified by text strings
- Next steps
Taught by
Dennis Taylor
Related Courses
Análisis de datos: Llévalo al MAX()Delft University of Technology via edX Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Data Processing and Analysis with Excel
Rochester Institute of Technology via edX Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera