I have watched many videos on Excel learning but yours' is the most in depth and easy to understand and I feel lucky that I came across your channel and now I get to learn excel in such a depth and with ease. Thanks a Lot.
I just want to say a big thank you for providing us such great content on excel... your all videos are good learning material on excel which are so relevant.
@@Innozant sir can you please make me understand, at the end of every video , you use to say that about your virtual class, do you mean to say about this youtube virtual class or your personal class room .
Sir, you always come up with unique things. Such things no institute or coaching teaches the students. When students get asked such questions in interview and they say. They have no idea or way of doing it. When we are unable to solve such questions it makes us feel less confident. Thank you so much Guruji 👍👍👍
Sir aafKa channel per bahut se bahut videos Dekha per all video se Mai bahut kux sikha Jo Mai dusra channel pe nahi sikha ovi Mai sikha aafse thanks sir....
No one on this whole you tube explores this much excel as Dipak Sir, even on little formula which can create huge impact if used properly. Every video gives entirely new concept to learn.
Thanks Shrikant ..Apne to sachme emotional Kar Diya...main jab ye channel par video upload Karna start kiya to socha bhi nhi tha ki sachme kisike life me ye itna impact layega ..uski life me value add hoga ISSA itna jyadam. M really speechless now.❤️🙏👍Love you all.
@@Innozant main pehle sir alag alag topics k liye alag alag videos dekhta tha. There was no channel that was giving complete information. But then I found Innozant and now I only watch Innozant. Baki sabko unsubscribe kar diye hai 😅
Sir Mahan ho aap sach me, maine aaj tak aise function or aise function apply ka tarika aaj tak kabhi nahi dekha...bahut kuch sikha hai sir aapse, bus aapse ek or request hai ki VBA macro ki kuch training de dijiye fir to koi rok nahi payega hume...please sir upload soon.
Gupta ji..Already Master Assignment Folder Link diya gaya hai jisme saare assignment rakhe gaye hain..Revision series ke questions bhi rakh dete Hain soon
@@Innozant thank you sir...... sir, aapne jo video provide kya hai excel k liye wo complete video hai ya muje khi or se koi course karna hoga......mai MIS executive banana chata hu...
Sir, mare Jo data h usme last Mai be wildcard h toh Mai uske liye pass kr rha Hu =sumifs(sale data,namedata,"~"&name&"~",region data,need region) . But ye result Galt show ho rha h. Aap btao do kaise krna h find out. Thanks in advance.
actually sir..apne not equal ka jo sign lgaya h wha pr koi condition to apply nhi hui ki...kiske equal nhi hona chahiye...to direct answer kaise aagya ............?
Guruji, COUNTIF formula with wildcard is working on the same sheet. But, it is not working on two sheets. For example: Same sheet formula: COUNTIF(C:C,"*"&A2&"*")-Working Two sheet formula: COUNTIF(‘Sheet 1’!C:C,’Sheet 2’!"*"&A2&"*")-Not working I am using EXCEL 2010. I am using Wild card of Numbers, not on Characters. Could you pls help me?
Hello Sunita..7pm Weekday new batch starts last week .You may join the same from tomorrow. For more info whatsapp/call us(contact no. Available in our website)
Sir in A1column name is written Ste and b1 column name is written steven c1 column value 6. In d1 column I am using this formula =iferror(Vlookup(A1&"*",A1:b1,3,0), "false")) The answer it will give 6. My difficulty is when I am changing A1 column name from ste to a or b,or any name, The output 6 is not changing but when I put in A1 column any numeric number it shows false. My basic request to you is I am missing something where A1 must find equality in b1. Such as A1 is ste and b1 is Steven Then A1 must check b1 has ste as wildcard character shows and give output,when A1 gets changes manually to any name the formula must show false. Request to you sir I am into food and beverage inventory and I have these semi names with proper names, Please assist me.
@@Innozant Correct Situation Country Capital Thailand Bangkok India Delhi USA New York on basis of this above correct situation i want to update status... Country Capital Status Thailand Bangkok India Lucknow USA Malaysia Thailand Indonesia India Kolkata USA New York Thailand Hong Kong India Delhi USA Germany I solved all the que. except this pls reply sir
We are Lucky because we found you & start learning from you.... Thanks sir...
Thanks Santanu..Happy Learning dear
Really superb way of teaching
God bless you
I have watched many videos on Excel learning but yours' is the most in depth and easy to understand and I feel lucky that I came across your channel and now I get to learn excel in such a depth and with ease. Thanks a Lot.
Thanks..Really means a lot to me .God bless you..happy Learning ❤️
U r a super hero in excel thanks a lot sir lots of advance tricks I have learned from you.
I just want to say a big thank you for providing us such great content on excel... your all videos are good learning material on excel which are so relevant.
Thanks Navin Ji.. Happy learning 🙏❤️
Superb, thank you very much for explaining these tricky concept in simple manner
Keep learning
Excellent explanation❤
Wao sir u are very great, Hamesha new cheez milti hai wo bhi bilkul unique ,🙏💯😍🥳👏👏👏👏👌👌👌👌👌💓💓💓
I r great sir 🙏 ram ji
The way you teaches us with smiling face is great sir,
Thanks Deepak for such a valuable feedback.❤
@@Innozant sir can you please make me understand, at the end of every video , you use to say that about your virtual class, do you mean to say about this youtube virtual class or your personal class room .
Awesome lesson, love from Pakistan Sir
Sir, you always come up with unique things.
Such things no institute or coaching teaches the students. When students get asked such questions in interview and they say. They have no idea or way of doing it.
When we are unable to solve such questions it makes us feel less confident. Thank you so much Guruji 👍👍👍
Thanks..Really means a lot to me
you are great sir
aapke jaise koi nahi hai sir ji s type se aap samjhate hain
thank you sir
Thanks Gaurav ji
Great sir 👌 . Sab video line se dekh ke sikh raha hu.. thank you so much. Keep it up ☺️
Good 👍❤️
Bahut khoob sirji funtastic video😘😘
Sir aafKa channel per bahut se bahut videos Dekha per all video se Mai bahut kux sikha Jo Mai dusra channel pe nahi sikha ovi Mai sikha aafse thanks sir....
Thanks Om..Step by step dekhte jaiye vodeos aur seekte jaiye dear..God bless you..life me bht tarakki karen yhi wish meri❤
Ek dum badhiya sikhaya aapne🙌🙏👏
Thanks
No one on this whole you tube explores this much excel as Dipak Sir, even on little formula which can create huge impact if used properly.
Every video gives entirely new concept to learn.
Thanks Shrikant ..Apne to sachme emotional Kar Diya...main jab ye channel par video upload Karna start kiya to socha bhi nhi tha ki sachme kisike life me ye itna impact layega ..uski life me value add hoga ISSA itna jyadam. M really speechless now.❤️🙏👍Love you all.
@@Innozant main pehle sir alag alag topics k liye alag alag videos dekhta tha. There was no channel that was giving complete information. But then I found Innozant and now I only watch Innozant. Baki sabko unsubscribe kar diye hai 😅
Love you Shrikant ..Ye Safar bht lamba chalna hai..Seekhte rhiye aur aage badhte rhiye 👍❤️
200% agreee
Sir Mahan ho aap sach me, maine aaj tak aise function or aise function apply ka tarika aaj tak kabhi nahi dekha...bahut kuch sikha hai sir aapse, bus aapse ek or request hai ki VBA macro ki kuch training de dijiye fir to koi rok nahi payega hume...please sir upload soon.
Thanks Deepak for your valuable appreciation.Yes dear will upload videos of VBA soon.
Good one..... although i was aware of weekly grouping but without logic behind
Too good sir 👍👍👍👍
You are donig a great job for student community.
God bless you Jha sir.
Thanks Jha ji..We welcome you to experience the taste of success. Happy Learning
Great sr 👌
Thanks virendra for your feedback,Keep Watching and share with your friends for the same.
Single word for "Great "👌
Thanks Ravi❤🙏
Thanks for this kind of Knowledge 🙏🏻
Osm video 😍😍
Thank you. Very helpful for my work.
Thanks dear. Happy Diwali 🙏❤️
Excellent 👌
Bahut sunadar sir
Very nice explanation, Logic Sir
Thanks Salil❤️🙏
Useful video.
excellent video
Thank you 🙏.. Very valuable videos
Thanks Ravi ❤️
very important video
Very Helpful
Very Nice Work
Thanks ❤️
Excellent sir
Thanks Koshik ji
Superb sir
sir apto mahan ho sir na jana hum apka jassa kab banaga please all frd share & like kara please🙏🙏🙏 or subscribe bhi
Mujhse bhi jyada aage jaoge life me.best wishes
Very interesting video
Thanks Harish Ji👍❤️
Very impressive boss
Thanks Sahir..God bless you dear
you give us good knowledge
Thanks ❤️❤️
Great Interpretation
Thanks Rajdeep
Bahut hi achha question hai
👍
Very nice channel
Thanks dear❤️
TQ...SIR....🙏🙏
Excellent
sir mai aapka video roj dekhta hu..aapke samjane ka trika kafi accha hai.........kya aap practice k liye or question provide kra sakte ho.....
Gupta ji..Already Master Assignment Folder Link diya gaya hai jisme saare assignment rakhe gaye hain..Revision series ke questions bhi rakh dete Hain soon
@@Innozant thank you sir......
sir, aapne jo video provide kya hai excel k liye wo complete video hai ya muje khi or se koi course karna hoga......mai MIS executive banana chata hu...
@@abhishekgupta-bp9ib aapko lgata hai in 500+ videos ke baad kahij aur se bhi padhne ki jrurat hogi?♥️
@@Innozant thank you sir....☺☺
Great 👍
Thanks
Great work sir,
Pl tell vlookup between two dates
Examples are already there for vlookup with date combination..Will add some examples in upcoming exacel maharaj series
@@Innozant thank you sir.....
I watch your video i have little knowledge. Can u let me know how can I become good to better.
Including dashboard
Behtreen
Thanks
Sir what is the short cut key for if we have to see the result of formula in Cell
F9 to evaluate
Thank you sir ❤🌹😊
Thanks Ravi..have a wonderful day
Good
Thanks Tejpal ji
Marvellous
Good video peoples
Thanks dear
i love it
Sir mujhe Block, GP n revenue village ki drop down list banani h. Isme block wise data kaise set kare is pr video dalen please
I did not get you for empty cells and to me it looks full.
Sir, isme last question mai jo NOT empty hai usmai criteria ki jagah par "*" ka bhi use kar sakte hai. haina sir.
Nice Sir
Thanks Om Prakash ji🙏❤️
sir excel ki class lecture 1,2 krke dala kro aise hmlog accordingly padh payenge aise confusion hoti h
Apne dekha hi nahi..upar thumbnail me dekhiye
Great
How to pull text with formula from another sheet ?
Sir Aaj aap sector 18 Noida me aaye the but himmat nhi huaa apse baat karne ki
Haan Team ke saath gya to tha,Aap kahan the ?mile kyu nhi aap..ohh❤️
This is not working in Vlookup
big applause to you sir ji :) but ye file kn se folder mai milegi
Thanks..Master assignment link diya gaya hai video description me dear❤️
Thnq sir
Aur aap se sikh sikh ke main main nahi raha, main office me chhota excel guru ban gaya hu... 😀🙏
Great❤️
No answer for your knowledge
♥️♥️♥️ Thanks
Nice
Thanks Anup Ji.❤🙏
Tilt wali file Kaun se folder me milegi
Excel ma auto hide & unhide mate function joie chhe
Sir, What if Sum Range is more than one?? Please clear my doubt.
Share any scenario where you think more than 1 sum range required ?
3:40 "Jisko humne use Kiya kisi or ko dhundne k liye ab hame usse he dhundna hai" sir😭💔
Hahahaha..keep learning
Sir, mare Jo data h usme last Mai be wildcard h toh Mai uske liye pass kr rha Hu =sumifs(sale data,namedata,"~"&name&"~",region data,need region) . But ye result Galt show ho rha h. Aap btao do kaise krna h find out. Thanks in advance.
Kaisa data hai wo share kijiye
awesome
Thanks dear
sir jese ek cell me 23456 likhe h to iska sum kese hoga. total inka sum 20 aa rha h to 20 aana chahiye
Interview cracker me karaya hua hai ye ques dear..aap in sequence video dekhte rhen bht kuch seekehnge
actually sir..apne not equal ka jo sign lgaya h wha pr koi condition to apply nhi hui ki...kiske equal nhi hona chahiye...to direct answer kaise aagya ............?
plz sir btana jarur aap
I would like to learn complete excel and VBA also
Ganesh ji kindly contact Innozant team for upcoming Mastering Excel new batches ke you may visit our website
how we join virtual training class
Connect team innozant for more information
Sql par video banaiye
Layenge SQL videos bhi
❤️❤️❤️❤️❤️
sir, wild card characters wala video nehi mil raha.
Isi series me hai dear
Data source bhi dediya karo. Practice k liye
Already diye gaye hain data source Description me link diya gaya hai
sir iski video playlist mein avalaible nahi hai
Saare videos in sequence hai dear.. playlist wise course kriye ..kahin se bhi nhi dekhna hai video
@@Innozant ok sir , abhi aap offline course karva rahe ho ya online?
Guruji, COUNTIF formula with wildcard is working on the same sheet. But, it is not working on two sheets.
For example:
Same sheet formula: COUNTIF(C:C,"*"&A2&"*")-Working
Two sheet formula: COUNTIF(‘Sheet 1’!C:C,’Sheet 2’!"*"&A2&"*")-Not working
I am using EXCEL 2010. I am using Wild card of Numbers, not on Characters.
Could you pls help me?
We also need a video on Wild card with numbers as well.
Ok .will make more videos on wildcard
Hello sir want to join your classes
Hello Sunita..7pm Weekday new batch starts last week .You may join the same from tomorrow.
For more info whatsapp/call us(contact no. Available in our website)
Sir aap ek fomula k dus vdeo bhi dalenge to vo TUM TUM NAHI RAHE, TUM KUCH AUR AUR BAN GAYE formula wale honge. Each different.
Hahahaha .Thanks ❤️
Please fee of this complete excel and vba
Innozant website visit kriye saare course details Available hai
Sir in A1column name is written Ste and b1 column name is written steven c1 column value 6.
In d1 column I am using this formula
=iferror(Vlookup(A1&"*",A1:b1,3,0),
"false"))
The answer it will give 6.
My difficulty is when I am changing A1 column name from ste to a or b,or any name,
The output 6 is not changing but when I put in A1 column any numeric number it shows false.
My basic request to you is I am missing something where A1 must find equality in b1.
Such as A1 is ste and b1 is Steven
Then A1 must check b1 has ste as wildcard character shows and give output,when A1 gets changes manually to any name the formula must show false.
Request to you sir I am into food and beverage inventory and I have these semi names with proper names,
Please assist me.
Kindly share your excel sheet with query explanation ..Will see once i am free❤️
Sir Apne "" null me "&" Ampercent q nhi lagaya
Whan kya benifit ?
Sir to ampercent kb lagya jat hai jb condition rahta hai tb?
Jab concatenate krna ho condition kanya waise bhi text ko
Aap excel k KHAN SIR ho
Though i don't know Hindi, understand the things by your step by step explanation. THANKS LOT.
I think you are from bihar sir ?
❤🙏
Sirji, video jhoom karke banaye formula dikhte nahi hai.
Ok..noted
Sir date wala topic smajh nhi aya
Dubara learn kriye dear
Sir Mujhe Iss Video Mein Date Wala Question Samajh Nahi Aaya Hai.
Toh Aap Detail Mein Define Kar Sakte Ho. Please @innozant
Great 👍
very nice concept
Thanks Sharmaji...Keep Learning ❤️❤️
@@Innozant Correct Situation
Country Capital
Thailand Bangkok
India Delhi
USA New York
on basis of this above correct situation i want to update status...
Country Capital Status
Thailand Bangkok
India Lucknow
USA Malaysia
Thailand Indonesia
India Kolkata
USA New York
Thailand Hong Kong
India Delhi
USA Germany
I solved all the que. except this
pls reply sir
If Capital is Matching with Country then Status should be Correct Else Wrong