This is the important part guys. This method of Deepak Sir is preparing us mentally like a simulation. Even after knowing all the formulas & functions, many of us fail to explain it properly. Such training should be provided in schools also.
Thank you Shrikant,It means a lot to me and I will further try to improvise my content as much as I can and will try to get to you with awesome piece of content for you all who are my supporters stay with me forever 😊
@@Innozant such things should be taught in schools and colleges. such guidance and help cannot be more precious than anything else in this world sir. what an incredible effort sir. hatsoff
Sir, aap 1st qus m Absent Present count karne kw liye sumproduct use kar sakte the 2nd solution k liye wo jada impress kar deta interviewer ko 😃jokes apart but thank you sir you are doing great work you are my guru i am your chela....i always watch your videos
Sir awsome vedio. It helps alots to prepare ourselves for interview. Every vedio has a different content which helps to learn more about excel and interviews. Thank you so much.
Thanks Poonam for wonderful feedback,These feedback really motivates me to make some good content that adds some value in your life,Have a blooming career ahead
last week me (14 sept'21) ko aap ne ek "Student interaction session" liya tha. agar possible ho to please ye session week me ek baar or month me ek bar Please lijiye yeh request hai aapse. bahut acha guide karto ho aap......aapne jo video upload kiye + guidance superb.......Guru ho aap jaisa. Thank you...!
Are bhaiyeji aise nahi hote interview hamare yaha English use hota hai😂 aur technical round aise pucha nahi jata, uska test dena padta h aur itne aasan sawal nahi puche jaate. 10 saal ho gaye muje MIS ka kaam krte hue🙏
Deepak Ji lagta hai naye family member bane ho Innozant ke,Ek baar Mis Interview cracker series ke questions attempt karke dekhne tabhi yakeen hoga Kitna easy question hai😀Saath hi ye channel life me value add krne ke liye banaya gya hai..mujhe bhi Pata hai communication English me hota hai..its for learning purpose dear..Ummeed gai jav aap complete channel go through kar lenge ,Videos dekh lenge to aapka perception thora jaroor Badal jayega..Happy learning.
Sir Please bataye ki agar main koi function laga raha huun ref ke liye kafi door chala gaya row mein yaa colum mein to instant back fiction per kaise aaunga.
@@Innozant thanks sir Done. Vaakay mein sumproduct is amazing functions , I m using first time I m sure this is function akela sab pe Bhari hai iske ander sab sama jata hai. Sir thanks again for this sumproduct series. I like it very very much.
Dono ka perspective alag hai dear ek professional training hai job oriented aur dusra diploma computer course.decision apko sochke Lena hai. Saath hi Yaad rahe ab wo time nhi hai ki degree aur diploma se job lagti hai apke paas key skills aur specialization kya hai Uske base par job lagti hai dear
Nahin Dear Akanksha,Aap saare questions ke interview video ko dekhenge to asaani se kar skte h.Saare question aur solution to wahin rakhe hue hain drive me.Common link diya hai na description me wahan se download kijiye aur video dekhke koshish kijiye solve karne ki. But pehle concept seekhiye tutorial video se step by step phir kar payenge solve aap
This is the important part guys. This method of Deepak Sir is preparing us mentally like a simulation. Even after knowing all the formulas & functions, many of us fail to explain it properly. Such training should be provided in schools also.
Thank you Shrikant,It means a lot to me and I will further try to improvise my content as much as I can and will try to get to you with awesome piece of content for you all who are my supporters stay with me forever 😊
@@Innozant such things should be taught in schools and colleges. such guidance and help cannot be more precious than anything else in this world sir. what an incredible effort sir. hatsoff
Sir aisehi videos banate rahiye. Aapke channel ke maadhyam se bahut kuch sikhne ko mil raha hai......!!
Thank you Sir.
Thanks Satish ji .Jaroor dear aata rhega videos apke liye
Sir Your interview Questions always Wonderful. I love your all videos & practice daily with your videos. God bless u.sir ji.
Thanks Sandeep,Keep Learning and share with others.
I don't know sir, this video was easy yaa aapki itni sari video dekhne ke baat my level increased, thanks sir ji ...............🙏✌
Your level increased dear and you are updating your skills on Regular besis this is the main reason.Never stop learning.
@@Innozant yupe sir ji🙏
Sir, aap 1st qus m Absent Present count karne kw liye sumproduct use kar sakte the 2nd solution k liye wo jada impress kar deta interviewer ko 😃jokes apart but thank you sir you are doing great work you are my guru i am your chela....i always watch your videos
Really like the interview series so far… very well created and as always great content.
Thanks heaps for all your efforts
Thanks Kavita...Hope these videos adds some value in your life.Happy learning ❤️
Because of your videos i learn a lot.
Thanks Ashwin
Good sir I was really excited to all learning to excal formula
Thanks dear..God bless you
Very effective video sir..and all questions are very practical..
Your videos are very realistic and help to boost the conference mainly for freshers as well as experienced, thanks
Thanks dear for your valuable feedback ❤️
Thanks for uploading this is so helpful methods you show us
Sir awsome vedio. It helps alots to prepare ourselves for interview. Every vedio has a different content which helps to learn more about excel and interviews. Thank you so much.
Thanks Poonam for wonderful feedback,These feedback really motivates me to make some good content that adds some value in your life,Have a blooming career ahead
Thank you so much sir, such kind of videos increase our mis knowledge
Thanks Anup,Hope this video helps and boost your confidence
all your videos are perfect and explain so easy thank you so much for uploading these videos
Thanks Pankaj Ji..Happy Learning dear
last week me (14 sept'21) ko aap ne ek "Student interaction session" liya tha. agar possible ho to please ye session week me ek baar or month me ek bar Please lijiye yeh request hai aapse. bahut acha guide karto ho aap......aapne jo video upload kiye + guidance superb.......Guru ho aap jaisa. Thank you...!
Awesome video sir , it's helpful for the preparation interview.....And helping for me increase my skill. Thank you for making this video sir. 👍
Yes Mohit ..Kindly follow all series
@@Innozant sure sir 👍 I am waching all videos and all Excel series.
Good interview sir...
Thanks Sunil ji
Sir, very nice video and the interview session is really very informative. It gives us a very deep knowledge about the excel.🙏
Thanks Harivansh Ji,Hope you enjoy the interview conversation.❤️
@@Innozant yes sir very much.
Great...thank you.
Thank you So much Deepak Sir
Thanks Prashant Ji,Hope aapne aajke video se kuch seekha hoga.
Very informative sir 👍
Thanks Dheeraj Ji
Ur really🔥 great👏👏😊
Thanks Ashraf Sahab👍❤️
Good sir asan tha😊
Ok..very good. Happy Learning ❤️🙏
Nice
Thanks Vikas ji❤️
Are bhaiyeji aise nahi hote interview hamare yaha English use hota hai😂 aur technical round aise pucha nahi jata, uska test dena padta h aur itne aasan sawal nahi puche jaate. 10 saal ho gaye muje MIS ka kaam krte hue🙏
Deepak Ji lagta hai naye family member bane ho Innozant ke,Ek baar Mis Interview cracker series ke questions attempt karke dekhne tabhi yakeen hoga Kitna easy question hai😀Saath hi ye channel life me value add krne ke liye banaya gya hai..mujhe bhi Pata hai communication English me hota hai..its for learning purpose dear..Ummeed gai jav aap complete channel go through kar lenge ,Videos dekh lenge to aapka perception thora jaroor Badal jayega..Happy learning.
Sahi kaha English me puchte h or usi time 😅 problem hoti h
V Nice sir
Thanks Bhoopendra ji,Hope you like and learn
@@Innozant always like sir u are great sir
Hello sir...I have one question...In Sumproduct how can I get unique value from sheet 2 based on match conditions 🙏
We can use second solution of 1st question
Sumproduct(--(B4:B24="P"))
Good Sourabh ji
Please describe the second example or there are any video whereas you describe the =text (A1,"00\/00\/0000) function.
Iits argument seprater
First comment sir
I want to be a MIS EXECUTIVE
Thanks dear,My wishes is always with you.
Enhance your skills and get ready to Crack the interview.
@@Innozant sir what should i do for being best in this field
Sir, aisa interview ho jaaye mera. job pakki. easy hai.
Sir
Please bataye ki agar main koi function laga raha huun ref ke liye kafi door chala gaya row mein yaa colum mein to instant back fiction per kaise aaunga.
Ctrl back space
@@Innozant thanks sir
Done. Vaakay mein sumproduct is amazing functions , I m using first time I m sure this is function akela sab pe Bhari hai iske ander sab sama jata hai. Sir thanks again for this sumproduct series. I like it very very much.
Thanks Tyagi ji..Happy Learning 👍❤️🙏
Sir plz upload a tutorial at xlookup with complete details
Soon these formula videos You may able to see in excel maharaj Playlist
Thanks for reply.
Salary kitani hoti haii...Basic aur experienced ...Plzzz reply🙏🙏🙏
Depend karta hai skills ke upara har organization to organization vary karta hai salary..
Bhai mis aur adca inme se konsa course job ke lye jyada suitable hai
Dono ka perspective alag hai dear ek professional training hai job oriented aur dusra diploma computer course.decision apko sochke Lena hai.
Saath hi Yaad rahe ab wo time nhi hai ki degree aur diploma se job lagti hai apke paas key skills aur specialization kya hai Uske base par job lagti hai dear
Sir apke drive me jo que diye wo bhot hard h....bilkul h alg unke solutions kaha milnge?
Nahin Dear Akanksha,Aap saare questions ke interview video ko dekhenge to asaani se kar skte h.Saare question aur solution to wahin rakhe hue hain drive me.Common link diya hai na description me wahan se download kijiye aur video dekhke koshish kijiye solve karne ki.
But pehle concept seekhiye tutorial video se step by step phir kar payenge solve aap
@@Innozant yes sir mil gya mujhe
Sr itna simple be hota h kya Excel interview
Offcourse, Interview Questions vary from compnay to Company and thier requirements.
Iske interview hindi m hote hai...?
both english and hindi..even vary from organization to org
Language problem aati hai interview crack karne me.kuchh batayein
Thora sa communication pae jarooe dhyan dijiye..bht jarooro hai comm skills aage badhne k liye life m
What's the approx salary of an MIS Executive ?
It depends and vary from organization to organisation dear,Initially don't think about salary focus on skills first
Execl mai salary 8 k se 10 k tak to mil jati hai na?
It's too less dear,Excel acha hoga aapka advance to Fresher 15k to 18k tak aaramse milega.
@@Innozant ok sir excel mai power pivot aur power query bhi seekhna padta hai??
Wo bhi aayega to aur achi baat hai..addon advantage hai..
It's simple tool ..aasaan hai
@@Innozant okk sir... Vaise interview wale puchte hai kya power pivot aur query k bare m
Harek company ki alag requirement hoti hai..jiske yahan jaisa kaam waise hi interview ke Question puchte h candidate se.
Any Course In MIS
Yes..you may visit Innozant website for more information
😂