Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 44100 Hz
Language: English | VTT | Size: 0.98 GB | Duration: 3 hours

Did you know VLOOKUP is the third most used function on #excel after SUM and AVERAGE?

What you'll learn

VLOOKUP, INDEX, MATCH, XLOOKUP, OFFSET, INDIRECT

Requirements

Basic Excel Knowledge

Description

(Microsoft research)

Think you know VLOOKUP well? :)

Prepare to look again with a fresh pair of eyes!

Glad to offer the MASTER GUIDE on VLOOKUP.

3 hour course for INR 500

30 + Lectures | Life Access | All solutions provided

Everything you need to Excel at VLOOKUP.

Work like never before!

Covers:

VLOOKUP with Column Reference

VLOOKUP with Range Name

VLOOKUP with Table

VLOOKUP with INDIRECT

VLOOKUP with VALUE for Data Type Mismatch

VLOOKUP with unclean names

VLOOKUP with IFERROR

VLOOKUP with Column Number Picker

VLOOKUP with Multiple Column Search

VLOOKUP based on Two Tables

VLOOKUP based on Multiple Sheets

VLOOKUP with results from Multiple Columns

VLOOKUP with SUM

VLOOKUP with Approximate Match

VLOOKUP with Approximate Match without Table Array

VLOOKUP with Approximate Match - Advanced

VLOOKUP with Duplicate Values

INDEX Function

MATCH Function

MATCH Function with match type

INDEX + MATCH as replacement for VLOOKUP

INDEX + MATCH for Data Type Mismatch on both sides

INDEX + MATCH for Multi Column Search

INDEX + MATCH with Case Sensitivity

Introduction to XLOOKUP

XLOOKUP with Multi Column Results

XLOOKUP with Multi Column Search

The OFFSET Function

The INDIRECT Function

Who this course is for:

Working Professionals

Management Students



DOWNLOAD
uploadgig