Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More
- Offered byUDEMY
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More at UDEMY Overview
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More
at UDEMY
Master Microsoft Excel VLOOKUP, HLOOKUP, LOOKUP, INDEX-MATCH, XLOOKUP, XMATCH, Two-Dimensional Lookups & Data Validation
Duration | 2 hours |
Total fee | ₹649 |
Mode of learning | Online |
Credential | Certificate |
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More at UDEMY Highlights
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More
at UDEMY
- Earn a certificate of completion from Udemy
- Learn from 41 downloadable resources & 1 articles
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
Read more
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More at UDEMY Course details
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More
at UDEMY
Skills you will learn
Who should do this course?
- The Excel user who wants to be able to confidently use lookup functions
- The Excel user who wants to gain a deep understanding of how lookup functions work and wants to learn more than just how to use VLOOKUP
- The Excel user who is looking to enhance their knowledge of Excel and learn lookup concepts that can take their productivity and efficiency to the next level
What are the course deliverables?
- How to use Excel lookup functions including VLOOKUP, HLOOKUP, INDEX-MATCH, LOOKUP, XLOOKUP, and XMATCH
- How to add data validation to make your lookup projects more interactive and easier to use
- How to correct the errors that most commonly arise when creating lookup formulas
- How to create and use named ranges in lookup projects
- How to create nested lookup functions
- How to perform two-dimensional lookups
More about this course
- This course is a comprehensive deep dive into Excel’s lookup functions including (but certainly not limited to) the ever-popular VLOOKUP, my personal favorite, INDEX-MATCH, and the new function, XLOOKUP
- It will give you a solid foundation of lookup function knowledge, but also challenge you to learn about and create nested and two-dimensional lookup functions that can really take your Excel capabilities to the next level
- By the end of this course you’ll be able to confidently use lookup functions, perform two-dimensional lookups, create nested lookup functions, use data validation in your lookup projects, and know how to correct common errors, among many other things
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More at UDEMY Curriculum
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More
at UDEMY
Introduction
Introduction to me and the course
How to Get the Most Out of the Course
Lookup Functions Overview
What can Lookup Functions Do?
Lookup Functions Terminology and Operations
VLOOKUP and HLOOKUP
The VLOOKUP Function
Exact and Approximate Match
The HLOOKUP Function
The VLOOKUP-HLOOKUP Function (Advanced)
The Table Array Argument
Absolute Reference
Named Ranges
The VLOOKUP-INDIRECT Function (Advanced)
LOOKUP
LOOKUP Vector Form
LOOKUP Array Form
Exact and Approximate Match
INDEX and MATCH
The INDEX Function
The MATCH Function
The INDEX-MATCH Function (Advanced)
The INDEX-MATCH-MATCH Function (Advanced)
The VLOOKUP-MATCH Function (Advanced)
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More at UDEMY Faculty details
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More
at UDEMY
Robin Davis
She specialize in creating instructional videos that are easy to understand and help users feel confident in their skills.
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More at UDEMY Entry Requirements
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More
at UDEMY
Eligibility criteria
- Prerequisite: Basic Excel skills
Conditional Offer
- Not mentioned
Other courses offered by UDEMY
₹599
10 hours
– / –
View Other 2346 Courses
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More
at UDEMY
Student Forum
Anything you would want to ask experts?