master certificate class on

xlookup hired - vlookup fired

Course Fee - Rs. 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. CHAMP EXCEL is glad to organize ONCE AGAIN a Master CERTIFICATE Class on XLOOKUP HIRED - VLOOKUP FIRED an Interactive Webinars by Eminent Excel Expert and CA Sh. Vijay Agarwal, awarded Microsoft Excel MVP for four consecutive years (2014-18) for his Excel Skills.


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

                   more perks

CERTIFICATION
Obtain a digital certificate for completing this course

WORKING FILES
Get access to the working and business solution files

90 DAYS ACCESS
Get access to the webinar recording for 3 months

INTERACTIVE Q/A
Get answers to all your queries

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 18-07-2021, Sun 6:00 pm to 8:30 pm

SUBSCRIBE
CONNECT WITH US