Crack Jobs #6 - How to Crack MIS Excel Interview? | MIS Interview Questions and Answers | Hindi 

Thanks Manish Ji.Really means anlot to me

Thanks dear❤️👍

Love you Shashank Ji❤️❤️🙏Really means a lot to me . thanks for your love and support dear 🙏

Aaage nhi karenge ..ye yaad rakhen

Thanks Binni..Hope it helps

Thanks Pawan❤❤

Thanks Deepak ji..Happy learnibg dear❤

Thanks dear for wonderful comment,Hope you learn from there and. Enhance your skills.

Thanks..God bless You.. Really means a lot to me ❤️

This is what I expect Altaf ..Good job..koi nhi rok skta interview clear hone se ydi aap mis interview cracker series khudse attempt kar pa rahe hain to

@@Innozant ha sir 95% tak questions khud se kar pa rahe.....abhi mai 11th mein hu sir ....aur tally sikh rahe......ms excel toh mera sabse favourite hai hamesha se ....❤️

Wow...This is what I expect Sonali.. Never quit ..Keep learning ..God bless you Have a wonderful career ahead.

Thanks Anoop,Yes sure will always try to make videos that helps you ,Hope you learn from there,Hv a wonderful career ahead.

Thanks Khan sahab❤️

Thank You Vijay jl for lovely appreciation dear🙏❤

Thank You Aishwarya for valuable feedback,Never Stop Learning.

Thanks Gaurav Ji

Thanks Sachin,Hope it helps ,Keep learning

Thanks Arjun for such a wonderful appreciation dear..It really mean a lot to me.God bless you.🙏❤️🙂

Thanks Narender Ji❤

Thanks Komal ❤️👍

Thanks Manish Ji.Really means a lot to me .God bless You

Thanks Mayank ji.Happy Learning ♥️

Thanks Paresh Ji,Keep watching ,Learn and enhance your skills.

Thanks Danish sahab. Happy Learning.❤️

❤️🙏

Thabks Sridhar ji

Thanks Nisha Ji❤️

Thanks Ram❤

Thanks Mohammad Sadiq

Thank you Bhoopendra,Watch Full video and learn from there step by step.

Oh dear these words really mean a lot to me but I think subscriber count doesnt matter to me yes that's true cause everyday I am getting your lovely comments about how my videos have made a change in your life and that is the most amazing feeling . I will surely cover such things in a qna video some day 🙂🙏 till then keep Supporrting me

बहुत अच्छा लिखी हो

Such an amazing video you are making for us sir tq you for all these🙏🙏🙏🙏

Right say @ishutiwari

Yes dear you're right 👍

Thanks Singh Saab❤️🙏

Thanks Gulshan ji

Thanks Sneha..We welcome you to experience the taste of success with Innozant -Seed of Success ❤️🙏 @innozantofficial telegram id for query support 👍

yes

Good Morninh Dear,Dil to apke is pyare se feedback se khush hota h mera..air din ban jata h 🙏♥️🙂

@@Innozant video m aapka Question 2 nhi aa rha smjh m?

Thanks Ravi Sahab..Happy Learning 🙏❤️

Thanks Samat🙏❤️

Thanks Ram,Keep watching ,Learn in depth , enhance your skills and move ahead . Wishing you great career Ahead.

Thanks Preethi...Happy learning ❤️,Sure dear will make more quality content for you

@@Innozant Sir can u post data analyst interview questions?? and what are the actual skills required for an entry level data analyst role?

Sir date column values decimal format me rehti h toh, usse date format dd.mm.yy format me kaise convert karte hein???

Thanks Archana to start watching my video and learn from there , Recommend you to start learning step by step from Playlist-BASIC EXCEL as m going to upload class video there in sequence,Still facing issue you may feel free to discuss your query with me.

You may contact us for live interactive session.For more infor visit Innozant website

Thanks dear ❤

Thanks Meenu,Keep Watching ,Learn and Share.

Like to dil se automatically hota h sir

Thanks

♥️🙏

Thanks Deeapak ji❤🙏

👍👍♥️🙏

Like GOD.. You are Adorable...

❤🙏🙏

🤣🤣🤣🤣Thanks Bhawna,Chalo aapne ye aaj yakeen dilaya ki mujhe acting bhi aati hai..Thanks Keep watching and learning.Main aaplogon ke liye humesha interview aise hi deta rahunga.🤣🤣

I got it , sir 😃

@@Innozant 🤣

Haan kyu nhi

Why not...flash fill requires data pattern

Thanks Negi Sahab,Hope apne is Interview video se kuch jaroor seekha hoga.

Yes but I am working in different domain but like your teaching skills😍😍

Excel will be applicable everywhere so it is good to learn new things.

Good Morning Arti, -1 isliye kyunki humen jo text extract krke leke aana hai wo space tak aaye ye ek character pegle tak?thats why -1 ,aap debug krke dekhiye select and f9 press karke.Samajh ke apply karna hai formula ,Nahin aye kuch samajh to aap connect kar sakte h mujhse via telegram or Zoom or you may call me for the same.🙏❤️🙂

please find all files in Mis Interview cracker folder under Assignment Master

But interviewer want formula based solution not using flash fill

Haan kar sakte hain but formula hi interview me puchega ...😊👍

Find .com and extract the same

Haan aati rehti hai opening..aap Innozant consultancy me contact Karen for job reference

👍❤️

Its not silly questions frok you dear..your dought is genuine..Excel Skills Is one part ..interviewer is also know about candidates other skillset..His presentation skills .. communication skills..technical and other criteria they need to map

Ok Pradeep Ji..try Kiya kijiye alag alag method se Questions ko attempt krne ka .👍👍♥️

Offcourse it's enough to start your career in MIS Field ,Yes VBA and SQL is required but it not necessary that without VBA and SQL there is no job or very low profile..You may view my video in detail..Why MIS.Job oriented. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Z-ElRbzWL2I.html

@@Innozant Thanks a lot Sir for your precious guidance and thank you for the valuable link.

Good .👍❤️🙏

@@Innozant Thanks dost...🙏👍

Kar sakte hain.bug formula use Kiya kijiye kyunki interview me nhi use krne dega flash fill

Sourav Ji Practice file is not for view only ,Its FREE to download,kindly download master assignment and start your practice now

Bilkul sahi bola hai Nasim sahab..Jo gyan aap de rahe hain Flash Fill ka Wo Excel ke liye bachon wala khilona hai dear😀Aur is khilone se khelne ko mai kabhi nhi kehta hu kyunki ye aapaahij banata hai skils ko.. Aap ek kaam kariye flash fil apply krke output lane ke baad source data ko change kriye ..output change hua? Formula ki jagah koi le hi nahi sakta .. interview dene jana aur aise hi flash fill use krke ek second me output nikal dena..wo bhi ek second me gate ke bahar ka rasta dikha dega😀😀 Na andher nagri hai na chaupat raja hai..Ye learner ke upar depend krta hai..Malik.🙏 Humne to jaise kabhi flash fill ka naam hi nhi suna hai Parvez sahab❤️😀😀😀

innozantcampus@gmail.com

NO, 2 way lookup is fine but we need to check attendance as well for P or A thats why If is mandatory to check the attendance status.You may try to implement using index match match with if one time only even it is more optimized.

@@Innozant I did this way. If(A1="p",index(match),"")

Good..

Thanks Virendra For wonderful feedback,It's my pleasure dear.

Kaunsa Question?? ❤️🙏

Sir yahi video wala

Therse are interview questions collected from various interviews.keep learning

@@Innozant thank you sir ❤️

Vba macro series is not uploaded till now.

Itne jaldi Interview schedule hai koi baat nhi..Give your 💯 percent,Statistical function (Countifs series ,Rank, Frequency ) ye sab ek baar revise kar lijiye Question aayega isse ,Saath hi double Vlookup ,Duplicate vlookup, thore bht index match if possible ki practice kar lijiye,Selection ho ya na ho interview kaise bhi arrange ho dena hai..ok..Kuch seekhenge hi..aur aap apna skills alreday improve karne me lage hi hain..Best of luck