Sir,this is the best free excel course in youtube.Your presentation skills are top notch.Thank you so much sir🙏 and if possible can you share pdf of this course with us.
Would be nice if you could add time tags to your long videos to make it easier for us to come back and review parts that we didn't quite understand the first time.
Mostly used is the Vlookup and a mixture of Match and Index is very helpful, Anyway, since I have big data spreadsheets, I benefitted of Column and Columns. Thank you so much for such impressive infromation!
Some functions seem absurd and funny, especially the INDIRECT function. It feels like when someone wants to tell you about something, but that someone delays or avoids telling you the main point for some reason? Like reading between the lines or solving a riddle? Too much beating around the bush. 😂 Anyway, thank you again for the superb explanations, Mr. Sumit. Looking forward to seeing the applications of these functions in the coming videos. Stay safe!
Remember for any formula, instead of putting actual values, you can input a cel, so you can create a table where you can input quickly different values and the formula automatically outputs the result of the formula.
This video is not uptomark... observation in this video, Lack of knowledge in V'lookup & H'lookup etc.. now im little bit confused, that all your execl tutorial are in proper manner or lack of knowledge in excel...
when i used vlookup in which i used text as a look up value,but the rank of my very first cell was higher than the rank of lookup value.Does it means that the vlookup value in case of text do not need the text should be arranged in ascending order?
They are tools to make things more efficient in large and various types of datasets - for instance, what would take 2-4 people to do manually without these formulas you could do all by yourself (depending on the dataset complexity ofcourse which increases your ability to be efficient).
In large and various types of datasets. They are tools to make things more efficient - for instance, what would take 2-4 people to do manually without these formulas you can do all by yourself (depending on the dataset complexity ofcourse).
Jab hame pata hi hoga ki wo data kahan hai coloumn and row no then hum q use karege.bas formula remember kar ke explain kar diya real life use to bataya hi nahi
![[FREE Excel Course] Lesson 11 - Math Formulas in Excel](/img/1.gif)
Sir,this is the best free excel course in youtube.Your presentation skills are top notch.Thank you so much sir🙏 and if possible can you share pdf of this course with us.
Thank you for all of the excellent free content, Summit Bansal. Greetings from Brazil!
Would be nice if you could add time tags to your long videos to make it easier for us to come back and review parts that we didn't quite understand the first time.
Mostly used is the Vlookup and a mixture of Match and Index is very helpful,
Anyway, since I have big data spreadsheets, I benefitted of Column and Columns.
Thank you so much for such impressive infromation!
Some functions seem absurd and funny, especially the INDIRECT function.
It feels like when someone wants to tell you about something, but that someone delays or avoids telling you the main point for some reason? Like reading between the lines or solving a riddle? Too much beating around the bush. 😂
Anyway, thank you again for the superb explanations, Mr. Sumit. Looking forward to seeing the applications of these functions in the coming videos. Stay safe!
Sumit Bhai your excel video is very useful for me.
I learned so many things.
Thank you for the kind words Irfan... Happy to know the videos have been helpful 🙂
great videos sir, small suggestion can u give some examples liked why these are used in excel. mainly like match, offset etc
Thank a lot for your valuable lessons
Thank you so much for making these.
Glad you're finding the videos useful
Remember for any formula, instead of putting actual values, you can input a cel, so you can create a table where you can input quickly different values and the formula automatically outputs the result of the formula.
Thanks a lot for these amazing lessons. These are really useful :)
Very nice summit, thanks again for these awesome videos 😊
Very informative Thanks, brother
your way of explanation is awesome
Thanks for the upload
Thanks for the this course.
very important class of excel
Great video! Very informative
He supports Trump, how do you feel about that
Thanks Sir
Why does he hit Ctrl+Enter instead of Enter? I never get it
When we work with array formula then press ctrl+enter instead of just press enter key.
This video is not uptomark... observation in this video, Lack of knowledge in V'lookup & H'lookup etc.. now im little bit confused, that all your execl tutorial are in proper manner or lack of knowledge in excel...
If you use more data for V&H lookup then it will be understandable how to use.
Useful video...Thankyou
good video ...... but can any one tell me that weather we have to learn these formulas from lesson 11 to lesson 15 ? as i am new
I am unable to understand what happened in the last part of INDEX function
when i used vlookup in which i used text as a look up value,but the rank of my very first cell was higher than the rank of lookup value.Does it means that the vlookup value in case of text do not need the text should be arranged in ascending order?
Good video.... But Why do we need this formulas? As I m new I don't know
They are tools to make things more efficient in large and various types of datasets - for instance, what would take 2-4 people to do manually without these formulas you could do all by yourself (depending on the dataset complexity ofcourse which increases your ability to be efficient).
When using =INDIRECT("C"&C25) I don't get any values, it's like the ampersand isn't working. Any idea why? =INDIRECT("C26") gives me the value of C26.
i too didn't get any value, same problem here
Mine worked perfectly.
What's in your C25? I have some spare time now; I can help you troubleshoot your work.
It didn't worked for me too...
@@ellisiverdavid7978 I agree, you have to see, what is in C25
why you don't put 14 in double Quotes for approximate match
so many ungrateful ppl in this comment section lol
no one is forcing you to watch these videos ^-^ be nice or keep it to yourself
how do I hit F9 for multiple columns to convert formula into value, when there is a #VALUE error?
=vlookup("t",A3:C5,3,1) is giving the corresponding value to tom but.
Also first example of vlookup is not working. If you could answer please.
sir here MATCH is good only when the data is sorted? if the data is not sorted then there will be some error, is it right? or wrong?
YES
@@ashwindeshmukh4525 if the data is not sorted then the command is not useful sir.....
16:00
Sir अगर ये कोर्सेज हिंदी में बनाए तो हम जान सके क्योंकि अँग्रेज़ी भाषा हमें बहुत ही कम समझ में आती है....
Where we use VLOOKUP HLOOKUP WTF !!
some functions are useless bz it changes its value so y the video is so long, pnly VLOOKUP,INDEX,MATCHis usefull
The first Vlook up I couldn't get to work in Google Sheet or Apple Numbers-OOF
पूरे वीडियो के
Where we use these formulas???😢
Idk butt i think it's for blind ppl .
In large and various types of datasets. They are tools to make things more efficient - for instance, what would take 2-4 people to do manually without these formulas you can do all by yourself (depending on the dataset complexity ofcourse).
Jab hame pata hi hoga ki wo data kahan hai coloumn and row no then hum q use karege.bas formula remember kar ke explain kar diya real life use to bataya hi nahi
This one was reallly long and boring, ngl
Areee Hindi mai video bana detaaaaa
try to make your videos more entertaining
plz try to explain in simple way dont make the things complex.
i swear he makes his videos way too long and i dont like but thank you anyway
-
make it 1.5 x