Quality content, Best instructor, No stupid Advertising, Clean and clear explanation, short and useful vdos, easy to understand... Thank u so so much Tutorials Point and Mr. #Pavan_Lalwani Sir ji✌️🙏
I am regular viewer of your videos, which are really educative and extremely helpful. Sir keep it up. And also educate us on creating formulas, particularly for calculating ITax. ThanQ
All the other tutorials says how to use these functions,but you are great in explaining the purpose of using those formula.i like your turtoruals very much thank u🙏
Thank you sir for your effort... Those are really helpful... Please make videos on vba....macro... How to copy data from Excel to notepad...Eagerly waiting for your videos...
hey sir , I am trying to use the same example and even I am applying the same method which you have used .but it is not including the topmost Monday . could you please the tell the error which is occurring
Hi,Can you help me in finding the number of calls done set of employees through the response sheet which they submit everyday...using countifs & Today() . Kinda automated sheet to find ftd details. I have tried the method which said in video but I get answer as 0.
Please post a session on Analysis of Bank account statement viz. Pivot Table and V Look up. This shall help in saving time during investigation. Thanks.
Sir it's urgent please reply me... It which institute they use this computer statistical tools in excel.... Like computer center or nursing ....like that... Sir please it's urgent... For applying exam they asking experience certificate.... So only sir... Pls pls it's request....
Hi, Can you assist me, how can we multiply a value based on the value selected on the other cell ? What conditions we can apply ? Eg: If I choose contractor in the first cell, then their day rate should be multiplied by 1.2 in the second cell.
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "CZcams12" to get ‘’FLAT 12%’’ OFF at Checkout.
Hi,
Do we have excel sheets data available for practising in this course?
I don’t know where you have been hiding. You have solved most of my data problems which I was struggling for long time. Thanks!
101 % correct
Quality content, Best instructor, No stupid Advertising, Clean and clear explanation, short and useful vdos, easy to understand...
Thank u so so much Tutorials Point and Mr. #Pavan_Lalwani Sir ji✌️🙏
your videos are making "excel learning" so easy. Thanks sir.
Nice comment dear👏
Hello sneha ,i can speake with you ,why beacuse of i ask one dowt in this problem,thank you
I feel I have learned many new things from this video and you should keep posting new short videos everyday.
I am regular viewer of your videos, which are really educative and extremely helpful. Sir keep it up. And also educate us on creating formulas, particularly for calculating ITax. ThanQ
All the other tutorials says how to use these functions,but you are great in explaining the purpose of using those formula.i like your turtoruals very much thank u🙏
Sir,
I am thankful to you.
Nice method of teaching, simplicity in words.keep it up.
Each and every point covered by you in specific tab🙏
बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब प्रैक्टिस के साथ जय हो
Superb explanation
If you want full knowledge of excel complete this playlist.
The way you teach is very simple and easy to learn.
Thanks❤
You are really very good teacher.I learned
lot off from you.god bless you.
His teaching skills is out of this world 🤍
simple explanation - Hallmark of an Excellent Teacher
Very Very USeful. Thank you, Sir and Tutorials Point (India) Pvt. Ltd.
all the presentations are really good and very easy to understand. good work. thanks for the videos.
Super sir
Very helpful
OMG, thank you for the easy clarification, gave me confidence!!!!!
Great lecture!
you have taught us very well in a very easy method.
Thank you sir for giveing the best examples for statastical functions.
Sir ur clz is very useful but one doubt how to know the equation how can that apply in each question
Thank you sir for your effort... Those are really helpful... Please make videos on vba....macro... How to copy data from Excel to notepad...Eagerly waiting for your videos...
Seedhi baat no bakwas. Great tutorial.
Really helpful n like savior for me..thanks is not enough for you sir.keep helping us🙏
Kya aak number teaching skill hai
This is the right thing to teach people
Presentation method very good for easy understand
i impressed for your explanation style.......keep it up. you are do well some special a day.
thank you sir for this very worthful lesson .
❤️ U deserve this!👍
It is stated for using because it is known as useful.
It is also for personal relevance.
It representation graphics.
Its really nice tutorials helpful in daily works -- Thank you very much
It does works. I am trying for long time
Tutorial point the way of learning
Hi, This gives result for John AND Monday; how to go about John OR Monday ?? Thanks in advance..
Great sir
Keep it up 💪
good clarity in explanation. very nice.
Also try with "monday" in 2:03 just to be more comfortable with queries. (Not Case Sensitive)
Thank you very much, greeting from Egypt
Great work sir .... ...God bless u
Great efforts 👏👏
Most usefull for analysis
Good teacher
Great presentation
Presentation is really good. thanks
Thank you sir 😊
Thank you sir!!
what I can see the first two functions sumif can be easily replaced by a simple filter and it will be faster. Meanwhile, keep looking....
Are u using smartboard?
All vedios are teaching sometging new
Thank u
Can you please arrange to provide vba vedios
You're great.
hey sir , I am trying to use the same example and even I am applying the same method which you have used .but it is not including the topmost Monday . could you please the tell the error which is occurring
Thank you so much sir
sir u r really talented
how to use countifs for 70. Please clarify
What device are you using as the projected screen?
Hi Sir...
Urgently looking to know why double code for numbers, hence it is used only for text..
Asap
what would be the formula when I want sum of those numbers which are less than 30 and also written against Mon & John?
IT WORKS, THANKS A LOT
Great lecture
Thank you😊😊😊😊😊😊
what should i do if i have to add for both mon and tue from one column
Excellent work
Are u using projector???
Excellent 👍
highly educative
what is the name of touch interface you use in background
Thank you sir
Sir aap great ho
Hi,Can you help me in finding the number of calls done set of employees through the response sheet which they submit everyday...using countifs & Today() . Kinda automated sheet to find ftd details. I have tried the method which said in video but I get answer as 0.
how the use of statistics function will help me with improve in my job and how to save time in arrange the fig well
Please post a session on Analysis of Bank account statement viz. Pivot Table and V Look up. This shall help in saving time during investigation. Thanks.
Do both the criteria’s need to be equal I mean in same row can’t it be in different row
Sir it's urgent please reply me... It which institute they use this computer statistical tools in excel.... Like computer center or nursing ....like that... Sir please it's urgent... For applying exam they asking experience certificate.... So only sir... Pls pls it's request....
Very nice
It was really nice tutorial.
U r great sir
THANK YOU
And cant be used in Sumif formula for the same Qsn
Please teach us how to use whatif analysis
Hello sir ,please explain the perform text functions for the given data using excel, sir please send the comment on link
Sir if I use =countif(C4:C15,"= E5") then formula could not accept the E5 cell number.
Let me know why it is not accepting this
remove quotes for E5, directly mention E5 instead =countif(C4:C15, E5)
Hi, Can you assist me, how can we multiply a value based on the value selected on the other cell ? What conditions we can apply ?
Eg: If I choose contractor in the first cell, then their day rate should be multiplied by 1.2 in the second cell.
=if(A1="contractor", 1.2*dayrate)
@@ksalikhan Thank you :)
Easily understand
Nice explain
Who is this cutie?
Sir pls make video how to make receipt payment entries and day book
Sir 2 table couldnot answer in formula
can I pay by debit card?? my paypal account is not working right now
How to use countif for words
Excellent work, but there is something wrong with my calculation
Sir nice teaching but you don’t zoom your screen it’s difficult to understand.
Double criteria is not working in ms excel 2007!
nice
Sir struggling to find sum ifs answer please help sir
This video very helpful
But video in teacher action is not seen to screen
thanks sir
how to formulate the following please
Good Good 1
Good Poor 2
poor good 3
poor poor 4
it is baste learning
when your financial function video comes
Sort it after the fomula