What you'll learn

Use VLOOKUP, HLOOKUP, INDEX, MATCH, and XLOOKUP functions.
Implement OFFSET and INDIRECT functions for dynamic data selection.
Perform two-way lookups efficiently.
Utilize CHOOSE and SWITCH for conditional data retrieval.

Requirements

Basic Excel knowledge.
Understanding of Excel functions.
Access to Excel 2016 or later.

Description

**This course includes downloadable course instructor files and exercise files to work with and follow along.**Welcome to our "Lookup Functions in Excel" course, where you'll learn essential tools for efficient data retrieval and manipulation. In this comprehensive training, you'll explore various lookup functions, including VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, and more. You'll discover how to use VLOOKUP for exact and approximate matches and explore alternative methods like INDEX and MATCH for more advanced lookup scenarios.Throughout the course, you'll also delve into lesser-known functions like OFFSET, INDIRECT, CHOOSE, and SWITCH, expanding your repertoire of Excel skills.By mastering these lookup functions, you should be able to perform two-way lookups and efficiently retrieve data from large datasets. Whether you're a student, professional, or business owner, this course will enhance your ability to organize, analyze, and interpret data effectively, making you an asset in any setting.In this course, you will learn how to:Use VLOOKUP, HLOOKUP, INDEX, MATCH, and XLOOKUP functions.Implement OFFSET and INDIRECT functions for dynamic data selection.Perform two-way lookups efficiently.Utilize CHOOSE and SWITCH for conditional data retrieval.This course includes:1 hour 40 minutes of video tutorials14 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion

Overview

Section 1: Looking Up Functions
Lecture 1 Course Introduction
Lecture 2 WATCH ME: Essential Information for a Successful Training Experience
Lecture 3 DOWNLOAD ME: Course Files
Lecture 4 DOWNLOAD ME: Exercise Files
Lecture 5 Using VLOOKUP Part 1 (Exact Match)
Lecture 6 Using VLOOKUP Part 2 (Approx Match)
Lecture 7 Using HLOOKUP
Lecture 8 Using INDEX and MATCH
Lecture 9 Using XLOOKUP and XMATCH
Lecture 10 The OFFSET Function
Lecture 11 The INDIRECT Function
Lecture 12 Exercise 01
Section 2: Advanced Lookup and Reference Functions
Lecture 13 Performing 2-Way Lookups
Lecture 14 Using the CHOOSE Function
Lecture 15 Using the SWITCH Function
Lecture 16 Exercise 02
Lecture 17 Course Close
Anyone who wants to become more efficient with Excel functions.,Students learning Excel functions for school projects or future job opportunities,Professionals who work in any field where you deal with data, such as finance, marketing, or research.,Business owners who handle lots of data.

Homepage:

https://www.udemy.com/course/lookup-functions-in-excel/

Udemy – Lookup Functions In Excel Fast Download
Udemy – Lookup Functions In Excel Full Download