Live Interview of MIS Executive | MIS Interview Questions and Answers | MIS executive work details

[@Arb17-18]

You are really a great actor, how many of candidate Interview have you taken sir

[@Innozant]

These real time interview video for all of dear to enhance your skills,To check the reason of not selection-Rectify.-Rehearse and again reapply to crack interview

[@bhaveshrawat1364]

Hello sir, in the "count even numbers" part it is actually counting the odd numbers. it should be =SUM(IF(MOD(A2:A11,2)=0,1,0)) for counting even numbers.

[@yogeshrao5924]

Right

[@sandeepaswal8944]

नमस्ते सर जी | सर आप सच मै महान हो | आपके Live Interview of MIS Executive बहुत ही अच्छे होते है | आपके Interview से हमेशा बहुत हेल्प मिलती है | आप हमारी बहुत हेल्प करै हो | आप बहुत ही unique हो | आप हमको एक अच्छी राह दिखारै हो |

[@Innozant]

संदीप जी मुझे उम्मीद है ये वीडियो आपको पसंद आया होगा और विनीत के खूबियों और खामियों से आपने सीखा होगा

[@sandeepaswal8944]

@@Innozant सर मेरी दुआ हमेशा आपके साथ है | आप हमेशा खुश रहे | सबकुछ मिले आपको जिंदगी मै |

[@Innozant]

Kya lagta hai Vineet ko dekhke ,Hone chaiye selection inka,? Ya apko over confident laga,Phycho sa dikha ya kuch ajeeb nature tha ..kya hain apke opinion ?

[@sandeepaswal8944]

@@Innozant sir nature acha nahi laga. Overconfident dikhai daivraha tha. But technical aur aptitude knowledge acha hai.

[@AbhishekSingh-jy7tu]

Sir bas itna kahna tha aap ki. You are too good 👍🏻 ❤

[@ishutiwari5567]

12:09 sir i think ye formula shi h is question me =(sum(len(table2))-sum(len(substitute(table2,E4,""))))/len(E4) kyoki video vale formula me temporary output to ara h but jha apne E4 ki jgh glti se E5 Le Liya h use bhi agr theek krle tb bhi agr hum E4 me "is" ki jgh kuch aur(let's say "a" or type "is" two time in a single cell) le lete h to vo correct output show nhi krega.

[@Innozant]

Ok ..dekhta hu main kaunsa question hai ye jisme apne ye formula apply Kiya h❤👍🙏

[@aashanexcel2811]

I like your all videos also your confidence... Superb ❤️

[@Innozant]

Thanks Raj Kumar Ji for such a wonderful comment dear.It really means a lot to me.🙏♥️

[@harshvardanraghavan8086]

Thank you sir for sharing your knowledge. Kindly share a video on how to prepare resumes for both experienced as well as fresher MIS Executives.

[@Innozant]

Thanks Harshvardhan for watching and share your valuable feedback,Ok dear soon i m going to make video on CV making for both.

[@nandansingh3535]

Sir mai 12th pass hu or bcom ke first semester mai hu per mene MIS executive ka course kiya hai or mere pass MIS executive ka certificate bhi hai per meri graduation complete nhi hui hai to mujhe job mil jayegi small company mai ?

[@ishutiwari5567]

12:42 is question me conditional formatting ke liye mene pehle b3:h3 select kiya. fir conditional formatting me formula type kiya =min($b3:$h3)=b3 apply krne ke bad fir se b3:h3 select kiya ,format painter pe double click krke down arrow press kiya 7th row tk. automatic sbpe lg gya formatting.

[@Innozant]

Are wah..Start thinking out of the box Ishu.Good hai❤👍

[@Soft-tips-tricks]

Most important question sir very nice explaination

[@Innozant]

Thanks Sintu,Hope pasand aaya hoga video ka concept,Vineet ka positive side adopt kijiye aur negative Jo tha usme over attitude use door hi rakhiye 🙏❤️ Thanks for watching

[@Soft-tips-tricks]

@@Innozant sure Sir

[@hassaanmirza3942]

Your Technical and Acting skills are awesome

[@Innozant]

Thanks Hassan sahab..God bless you..Happy Learning dear❤️❤️❤️🙏🙏

[@uniquemobiletipstricks7714]

You are Brilliant all perfect Quality you have

[@Innozant]

Thanks

[@shraddhajadhav8874]

Hello sir...aapke interview video k practice se mujhe aacha job Mila with good salary pakage...Thank you so much😊😇

[@Innozant]

Congratulations Shraddha..Have a wonderful career ahead ❤️👍

[@princegirl5640]

In second question we can also use = countif( range,"*is*")

[@yogeshrao5924]

Exactly

[@kavita8390]

Great informative video, sir, I have question regarding highlight lowest value using conditional formatting, I can’t figure out why it did not work for him for all minimum values. Pls advise

[@Innozant]

What's prob you are facing Kavita ji?

[@kavita8390]

I am not able to highlight all minimum values , same problem the applicant is facing. Pls advise

[@MrNiks-li6jn]

Your videos are very helpful to crack any interview

[@Innozant]

Thanks dear 🙏😊❤️

[@suvadipnarayanchowdhury4614]

Hello Sir...I am watching few of your videos for past few days. They are very very useful for learning and practice both for freshers and experienced. Your acting skills and coordination between the shots are really very organized and focused. Your videos truly deserve to be subscribed. Sir just one feedback from my end - While watching till the end of the video, I thought at the end, you will evaluate the candidate's result (means the results of Vineet Mishra - You Vs. You). Sometimes I thought Vineet is going right but with some over confidence and attitude and sometimes wrong by showing the unnecessary vocal tones and body language. I will be grateful, if you could analyze Vineet's outcome from the recruiter's point of view. Thank you Sir..

[@Innozant]

Thanks Suvadip Ji for such a valuable appreciation. Really means a lot .Kindly note that my perspective via these videos episodes and cast is to teach.To make all of you aware and understand what is right and wrong. Recommend you to watch more interview series an rehearse..Thanks for your suggestions..❤❤🙏🙏

[@aishwaryaambasta7013]

Soo relevant questions...and its all about presence of mind, great experience it was.

[@Innozant]

Thanks Aish,Hope you like the video and learn positive side of Vineet.🙏❤️

[@swagatamkhanra4667]

Sir this is the best video of ur chanel

[@Innozant]

Thanks ❤️

[@RamSingh-ol5xz]

Nice

[@vinayrsoni4334]

What an outstanding video sirji

[@Innozant]

Thanks Vinay for such a lovely feedback.🙏❤️

[@rahulviz8559]

Wow Guru Ji ........ Bahut badiya Interview Session...✌✌✌✌✌

[@Innozant]

Thanks Rahul Ji❤️

[@kanitar786]

Awesome way of teaching

[@Innozant]

Thanks Waseem sahab

[@E_K18]

Superb acting skills sir ✨ bohot badhiya!!!

[@Innozant]

Haha...You like it♥️🙏

[@bpatel4330]

so useful...thank you for the vedio

[@paramjeet975singh3]

It was nice sir

[@Innozant]

Recommend you to watch Full video,It's worth watching 🙏😊

[@paramjeet975singh3]

@@Innozant i have watched sir.... Sir hme reasoning bhi karni padegi interview mai

[@Innozant]

Ji Haan..thora bht reasoning bhi kro prepare,Achi company me puchte h reasoning bhi

[@paramjeet975singh3]

@@Innozant ohk sir...thnnzz

[@rajdeepsaha9059]

Great Great

[@vijaysahal4556]

hi sir is sentence table mein is nd the ko count krna hai ki repeat kitne time huaa hai but is 3 time huaa hai or the 4 time huaa hai but aapke ans 4 nd 6 aarhe hai kese

[@Innozant]

Ek baar aap formula apply krke dekhiue aur chevk kijiye output sahi aa ra h ki nhi

[@vijaysahal4556]

ohk I ll check

[@Nitesh-sq7ci]

Ye video mst lga ....

[@Innozant]

Acha ji . Thanks 🙏❤️happy Learning

[@yudichouhan2812]

Very great..

[@Innozant]

Thanks dear

[@nareshkumar-no2hx]

sir i am not understanding question number 4 in this question even has to find but only seven values are even i think by iseven formula plz reply me

[@Innozant]

ok.will check the ques you are asking for

[@itssingh.Prashant]

Hello Sir, With due respect i have a query to ask @ (13:52) Ques4. says "Count How many Even Values", But if we look into the Table there are only "7" values(72,92,90,12,60,96,98) which are even, whereas our output is "12". Could you plz explain how it's possible ? Thankyou....

[@Innozant]

aisa to nhi hona chaiye...Hoe many even numbers are therw in list ?it may coung the same.

[@riyadalela6096]

It was very nice sir..

[@Innozant]

Thanks,Hope you like the concept and learn positive side of Vineet. Over confidence is always bad.

[@riyadalela6096]

@@Innozant yes sir..

[@earthmaticalthings4998]

Sir Apne to acting class b deni chahiye..😃😍

[@Innozant]

😀❤️

[@niladriroy2204]

Sir repeatation mein COUNTIF bhi toh laga ke output nikal sakte hai?

[@Innozant]

Haan..nikal skte h

[@msexcelgooglesheet374]

I think sir ji Vineet Mishra is not watching INNOZANT Sir's excel video, agar wo dekhta to uska interview pakka achha jata, He and all must watch innozant video for excel LEARNING AND JOB INTERVIEW ............................................

[@Innozant]

Thanks dear,Haan Vineet ko knowledge to acha hai lekin attitude,over confident,jyada bolne ka issue ye sab negative factor hai . Interview purpose se. Thank for watching and share your opinion.. Happy Learning

[@msexcelgooglesheet374]

@@Innozant Past 1 months i started watching your video sir ji, abhi bohot se video baki he dekhni aapki ...............too many work........for learning 🙏

[@Innozant]

Thanks Dear,Watch and learn step by step.

[@akashkumar-oi1fw]

Sir google spread sheet kiya hai or iski script kaise hoti h mis ke liye isse bhi ans chahiye kiya

[@Innozant]

haan google sheet se bhi ques puche jane lage hain interview me..bnata hu uska bhi kucg videos.

[@Letters_and_covers]

how to prepare daily sheets sir, please make a video on that

[@Innozant]

Daily sheet for what..?eg HR ,Inventry Production etc?

[@Letters_and_covers]

@@Innozant daily sheets on production and also explain difference between Excel sheets and Google sheets.. it would be very helpful for us..and thanks for your videos sir.

[@Innozant]

Ok...Soon will start making Videos on Google sheets Jyothsna.Thanks for your suggestion

[@yogeshrao5924]

Count how many Even value वाला गलत हे सर जी

[@RamSingh-ol5xz]

Great sir

[@Innozant]

Recommend you to watch Full video dear🙏❤️

[@sagararora8040]

Sir 1 Q Ha apse sir Dob mention is formet mein 07-Jan-2010 Sir munjhe mont ka count chahiye only toh kaise karenge

[@Innozant]

Month Ka count chaiye matlab.moutput kya chaiye??

[@sagararora8040]

Out put mein only month ka cout chahiye

[@sagararora8040]

Month ka count

[@Innozant]

Sirf month no. Chaiye to month(date) pass Kar dijiye .. Mujhe Ques apka Sahi se smjh nhi aa Ra hai kya output chahte Hain aap..wahi puch Ra hu apse required output likhiye ya data sheet dikhaiye

[@manishasingh765]

Sir please can you take my class.. I m from mumbai?? How can i learn from you?

[@Innozant]

Good Morning Manisha,We welcome you to experience the taste of success with Innozant-Seed of success. Yes dear out Live classroom training sessions are running now,You may whatsap/call us for more details about Data Amalytucs course. For query- Whatsapp/call us (For contact no visit Innozant website or you may find it on latest videos Intro)

[@Innozant]

Hybrid Classes (offline & online classes at same times) are running via Zoom meeting, There is no difference ,You may feel like offline class experience❤️It's better you may connect us today for live session and feel the difference ❤️

[@ROMODLAL]

First jitnaa puchaa jaaye utnaa bolo Second....araam se aur point k saath bolo... Third....listen first Four...overconfident is very bad..

[@Innozant]

Wow..You really watch this video what I am trying to deliver ..You exactly analize the good and bad part of Interview and hip must learn from there . Thanks dear Arjun 🙏♥️♥️🙏

[@ROMODLAL]

@@Innozantexpreince with skill is more improptant.......degree is only for entrance.....aapki koshis shaandar hai👍🙏

[@Innozant]

Love you Arjun..Your words really means a lot to me👍❤️God bless you dear

[@akashkumar-oi1fw]

Sir aap job interview ke liye kaha 2 apply karte ho mujhe to mostly consultancy hi milti hai or paise mangto h

[@Innozant]

Haha..main to nhi karta hu .haan aplpgon ki jaroor help kàrta rehta hu.inteeview ref provide krenge yadi aap mehnat krenge to

[@saritakharwar109]

Sir maine last question kiya wo hua nhi 15.1.11 ki jagah 40543 aa rha h ku ..pls btaye

[@Innozant]

Oho Sahi to aa raha hai Sarita,Wo date value show kar rha hai use aap Date format me change kar dijiye bus 👍❤️❤️😀 Aapne basic excel nhin padhe hain? Yadi date and time. Functions padhe hote to ye galti nhi krte aap na.. Basic Excel playlist bko complete revise kijiye aap❤️

[@vijaysahal4556]

hii sir count how many even value but sir isme divisor 0 to table mein 7 hi aarhi hai

[@Innozant]

kaunse ques me?ek baar khudsw formula apply krke dekhihe ..sahi aana chaiye dear

[@harivanshgautam3424]

Sir ji koi aap jaisa bhala recruiter hua toh 15-20 ke liye personally gyan dega or select Kar lega. Vaise toh mushkil hai vineet Ka select hona 🙏 10 out of 2 percent chances.🙏🙏

[@Innozant]

Hahaha..Aapko kya laga Vineet ko dekhke ,Ye candidate over confident hai ya uska jaldwaji krne ka nature hi hai ,ya NO patience,apne dekha interviewer ke ques puchne se pehle hi answer Dena start. Jabki knowledge perfect hai..😊

[@harivanshgautam3424]

@@Innozant sir ji mujhe toh ek problem sabse jyada nazar aati hai wo hai vineet Ka jarurat se jyada bolna. Baki hardworking and knowledgeable person hai. Baki problem toh solve ho jayege but kum bolna vineet ke liye kafi mushkil Hoga. Thodi se grooming ke avashyakta hai just interview ke baad jisse usko pata chal sake kee usko call kyun nhi aa rhi hai. 🙏🙏

[@Innozant]

Yes 100 percent right observation from you..Learn from this interview session,That's why I make these learning videos.

[@harivanshgautam3424]

@@Innozant yes, of course, every time I learn new things from your videos. Thank you Sir 🙏

[@bishtlokesh1297]

Overconfident is not good speally interview time

[@Aghast88]

For Jata G it,s Easy.. For him...Not Sure 😀

[@Innozant]

Hahaha

[@excelsolutions.7167]

Sir aap acting bhi acchi karte hai

[@Innozant]

Thanks Jaswant ji ❤️

[@paramsingh383]

thanx sir to fir ap ab isi company mai ho kya ...mean ap select ho gaye !!

[@Innozant]

hahaha.. Thanks Param..Happy learning🙂❤🙏

[@yogeshrao5924]

You are good Actor also😂😊

[@Innozant]

Thanks..Keep learning

[@zaibakhanum203]

Hi sir I need urgent help from u I have 1 qsn paper can u solve and send back to me in 1 he its urgent

[@Innozant]

Ok You may send me your question will try to make time for that. [e-mail]

[@gauravbhatia7987]

Technical round gajab ka tha 😅

[@Innozant]

Haha...Pasand Aaya apko ..👍❤️🙏

[@kishorpanara4191]

Nice sir kal off liya tha?

[@Innozant]

Kaun off dega mujhe dear..No off 7 days working

[@kishorpanara4191]

@@Innozant only mazak dear

[@grreankyworld6549]

So sir your institute is open now a days 🙄

[@Innozant]

Na abhi Kahan..😭Online Live class is running.

[@msexcelgooglesheet374]

@@Innozant Par sir ji apka institute hai kaha?

[@Innozant]

New Ashok Nagar

[@msexcelgooglesheet374]

@@Innozant is it in Delhi

[@KarthikReddy-kg8zv]

Why you using Hindi always while giving explanations .. It better to teach in english so that every one get it .otherwise it ll be useful for only who knows hindi

[@Innozant]

Thanks Kartik for your suggestion,But I had started this channel to target the Hindi audience because most of the english speaking population might know hindi but it might not be the same the other way around.

[@uniquemobiletipstricks7714]

Vineet bahut utaawle ho rhe he 😂 jawaab dene k liye bhare pde he

[@Innozant]

Hahahaha..keep learning

[@RamSingh-ol5xz]

Sir

[@hemantgusain1260]

Video was nice, but you are showing too much attitude in video, such type attitude will not work in interview. I know it was just video that you made for us giving knowledge that don't behave like that in interview. No one will select us, if we behave like that in interview.

[@Innozant]

Yes,this is what the opinion and Interview analysis I expect from you Hemant. This video is Learning specially for over confident person, Knowledge matter but your attitude matters a lot.It was real incident I face while Interview one candidate with same nature and attitude as I try to deliver in video. Awesome knowledge tha us ladke me jab main Interview le ra tha but wo Meri ek nhi sun ra tha. Thanks for suggestion and true opinion ❤️🙏 Happy Learning dear

[@hemantgusain1260]

@@InnozantI think that guy had not need that job. If you waited someone like that anyone can loose his temper. But still we will have to be patience. Because only our behave distinguishes us from animal. But sir your video was too good for interview purpose. I leared alot from this.

[@hemantgusain1260]

Sir apne jo question number four kiya hai uska answer I think galat hai Maine aise kiya hai or mera answer for even 7 and for odd 12 hai. =Sumproduct(--(Mod($A$2:$A$20,2)=0)) for even and =Sumproduct (--Mod($A$2:$A$20,2)=1)) for odd.

[@saudagarawais599]

2:20 same mera haal hai..

[@Innozant]

Haha...really♥️😆apni halat recall ho gya hoga apko?

[@ubaidillahmuhammad20]

direct link : drive.google.com/file/d/1B9bm...________is lock down

[@Innozant]

Working now

[@sarojkakitchen]

Mis interview mai aptitude test question,😂😂

[@Innozant]

Ji Haan...ap kisi big organization me Interview dein .. Aptitude se jarur samna hoga aapka.

[@shubhamprateek2536]

Jitna questions aptitude ka isme solve hua h utna hi mere se hua.....fir to selection ni ho payega ..? Aptitude ka koi syllabus hai ky?

[@bhoopendraraghav9781]

I feel overconfident

[@Innozant]

You are right Bhoopi..Jo Vineet ka positive side hai use adopt kijiye aur negative ko door hi rakhen

[@bhoopendraraghav9781]

@@Innozant g sir

[@TechnicalAmar9554]

😅😅😅😅

[@markroy2374]

আর পারছি না নেকামি দেখতে

[@Innozant]

❤️🙏Kindly write in English..😀🙏❤️

[@bhawanabaghel8368]

😂😂

[@Innozant]

❤️🙏