Excel Basic to Advanced by CA Amit Jain – Day 2

by CHZ



Advanced Excel Functions : Lookup function (vlookup, Hlookup), Logical Function (If), Advanced Vlookup (lookup with match)

Practice file can be downloaded from below link:
https://www.dropbox.com/sh/a2j04iihhrgr2cq/AAC0FMJHD98EOR6xZn1SBk90a?dl=0

source

14 comments

manoj pandey August 9, 2020 - 7:32 pm

Sir aap bahut acha batate ho thnx sir jo poor family s hai unki aap bahut help kar rahe ho

Reply
Skdave Skdave August 9, 2020 - 7:32 pm

Apki excel file practice ke liye down load karte hai vah jpg me miltihai yeh problem kese solve kare

Reply
Prasad Biwalkar August 9, 2020 - 7:32 pm

these videos are really helpful…keep doing it…

Reply
Prasad Biwalkar August 9, 2020 - 7:32 pm

Hi…while i put my vlook up formula combine with match formula in the remaining columns i get error as reference, like this……….. #REF! , how should i fix this.

Reply
Uttam Kalika August 9, 2020 - 7:32 pm

Watched 2 video of 2 days session

And these are really helpful

CA Students or CA fresher need a structured course to start their excel journey.

Your 5 day series will give that without any charge. I hope u will bring more content. God bless you sir

Reply
Rahul Kumar August 9, 2020 - 7:32 pm

Sir where are you from?

Reply
KAMLESH SAH August 9, 2020 - 7:32 pm

Awesome
👌👌

Reply
vikram raghuwanshi August 9, 2020 - 7:32 pm

great explanation hats off to you.

Reply
saurabh kalra August 9, 2020 - 7:32 pm

Sir please teach about Xlookup also..

Reply
Avirup Ghosh August 9, 2020 - 7:32 pm

VLOOKUP WITH MATCH FUNCTION IS REALLY GOOD.

Reply
Tarun Agarwal August 9, 2020 - 7:32 pm

Sir you r amazing, attending your sessions , pls make more videos on dashboard, advance vlookup.

Reply
subhash kumar August 9, 2020 - 7:32 pm

Great sir
Your videos are exactly what we need in company for daily use
Thank you

Reply
MANOJ PAGHDAL August 9, 2020 - 7:32 pm

Plz share link to download sample file

Reply
NAVEEN GUPTA August 9, 2020 - 7:32 pm

PLEASE SHARE YOUR ZOOM MEETING ID

Reply

Leave a Comment