Master Class on XLOOKUP

Course Fee - INR 500/- only 

Why it's important!

XLOOKUP : 10 Times powerful than VLOOKUP 

Left or Right any side Lookup

No need of HLOOKUP 

No need of IFERROR

No more INDEX/MATCH

XLOOKUP is part of EXCEL 365 New Dynamic Functions. This is going to change our working tremendously and going to be immensely helpful to automate tasks in our spreadsheets.


We always wished to learn Vlookup well and even after learning still struggling a lot due to its limitations like: 

πŸ‘Ž It works only left to right 

πŸ‘Ž its very slow, 

πŸ‘Ž  How to avoid errors like N/A

πŸ‘Ž Inserting or deleting columns make results wrong

πŸ‘Ž Need to learn HLOOKUP

πŸ‘Ž Its find only 1st matching values

πŸ‘Ž What to do if we need to match values on LIFO basis 

πŸ‘Ž and many other issues 

Salient features of the Course:

πŸ‘‰ Shortcomings of VLOOKUP

πŸ‘‰ Understanding XLOOKUP Conceptually

πŸ‘‰ Apply anywhere Left or Right

πŸ‘‰ No need of using IFERROR

πŸ‘‰ No Need of learning HLOOKUP or INDEX/MATCH

πŸ‘‰   Dynamic Lookup - Auto update results even on inserting/Deleting of columns

πŸ‘‰ How to find value from multiple databases based on priority

πŸ‘‰ Able to Find Last Value 1st like finding last purchase price

πŸ‘‰   How to get value from multiple sheets dynamically

πŸ‘‰ What to do if exact match is not there, like in Data base values are Dr Sanjeev, Ms Sonia, XYZ Ltd., but we look for Sanjeev, Sonia or XYZ

πŸ‘‰ Many other unexplored areas

πŸ‘‰   Some Interesting Business Cases​

πŸ‘‰   Q&A

Step 1: Signup

Click on 'Enroll Now' button and do signup first.

Step 2: Payment

After signing up go for payment method.

Step 3: Done

After payment, do register for Live Webinar schedule at 23-05-2021, Sun 6:00pm to 8:30 pm

CONNECT WITH US