Crack Jobs #8 - How to Crack MIS Excel Interview? | MIS Interview Questions and Answers | Hindi
HTML-код
- Опубликовано: 11 сен 2024
- Learn about How to clear Excel interview?
Excel Formulas & Function based real time interview question faced to clear Excel Job Interview. Mis Job Seeker interview experience revealed.
Excel Interview Questions and Quiz in Hindi.
1. Find out how many people are born in the month of Jan,Feb,Mar,….Nov,Dec. based on the data provided
2. Find the age of a person till date. Using DatedIf ?
3. Questions using index formula in excel
4. Use Data validation to show full List drop down list
5. ExtractFirst initial of first name and first initial of last name separated by a space.
Download the Assignment Master Practice Folder here (All Example at one place)
drive.google.c...
(Playlist - MIS Interview Cracker -Crack Jobs #8.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#excelinterviewquestions #excelquestions #Innozant #Exceltutorial #exceltips #interviewcracker
I am saying rom my really soul and heart as its only your channel only your, How can someone dislike it make me think. you really put your all making even a single video. Love from new Delhi, I wanna be investment banker. Your excel help me a lot. I am at 1st year of my college until complete my graduation.. You are really gonna make me master in excel. Thanks in advance sir.
Sir I love your all interview Question. You are great teacher👨🏫
Thanks Dear Sandeep
Gajab bhai..mai hamesha MIS se darta tha..ab thoda asaan Hua. Shukriya.
♥️♥️👍
i am student of Jha sir, and I am able to fetch DOB by month without helper column because he taught me how i can combine different formulas and customize them as per the requirement, thank u so much sir, you are a game changer
Thanks dear.God bless You.
I appreciate your effort, you are providing us great knowledge. keep going, Thanks a lot sir
Thanks Azhar ❤️❤️
Sir no one like you and no competiton of yours🔥🔥🔥
Thanks Karan for such a lovely appreciation dear❤🙏
How unselfish you are 🙏 god bless you bro...
Thanks dear..God bless you
Great question sir ji.... I was subscribed your channel approx. 15 days ago and I learned here quite a lot about MS excel....Thank you very much sir
Thanks Sunil ji..God bless you dear...We welcome 🙏 you to experience the taste of success.
Gajab level hai bhai sikhaane ka. I am an indian from kuwait and i want to learn advanced excel
Thanks Moin Khan Sahab.Really means a lot to me.Yadi aap seekhma chahte hain step by step to Playlist Basic Excel se apne learning journey ki shuruwat Karen.Thanks for being part of Innozant family.
Great Job Sir.
No one is making videos on such content.
Love you alot sir
Really means a lot to me Rafi Sahab..Happy learning 🙏🙏🙏❤❤
Solid hai bhai... How's the josh... Very high sir aapka 👌🔥
Thanks Akshay ji..Keep learning
Very helpful video for preparing MIS interview! Thanks Sir!
Thanks Dear,Hope it helps
@@Innozant Yes Sir, It helps a lot!!
This is just amazing... You are a gem
Thanks Aditya❤️
Super play with index formula thank you.
Amezing teaching style 👏, ek like to banata h 👍
Thanks Puneet Ji..Happy Learning dear🙏❤️
It was a quite easy but I enjoyed watch it. Appreciate sir. Keep uploading like this video🙏🙏🙏🙏🙏
Thanks...more than 20 Interview Cracker Videos uploaded..Must watch dear..🙏❤️
Hi Sir, awesome! great explanation and very useful for excel lerners keep doing same thank you very much your hardwork.
Thanks dear ❤️
Name wala boht badi aafat h... 10 din ho gye practise but abi bhi clean nhi h... Mera .... Mid & right wala boht hard lagta h.... Substitute with retn wala easy h
Thanks for your support it will really help people to crack an interview..
Thanks Jinesh Ji.❤️🙏
Helpful ....
Bahat badhia sir
Thanks ❤️🙏
Nice questions..
Thank you for your useful information sir!
All good question sir 👍
Sir really great knowledge thanks
please make videos Regarding WFM preaparation.
NICE SIR
In last question you also use flash fill
Interviewer always ask Formula based Questions bro
Wonderful teaching
Sir I love your videos this is very very helpful for us
Love you Dharmendra... INTERVIEW CRACKER AUR live interview ke questions jaroor practice pehle saare concept seekh Lene ke baad.👍👍🙂🙏❤️
Your video too much helpful
Sir getting more knowledge from u
You are great sir🙏🏻🙏🏻🥳
Hi.. superb video u r uploading for us.. Thank u so much..!
Thanks Pankaj
Excellent video sir
Grade sir but sir jo apne maximum sale nikala h base on name toh agar kai bar same value aai ho minimum pass karne par range me toh bo kiska name uthaye sabse upar bale ka hame toh upar bala ka nahi niche bala ka chahiye ho toh
Mera matlab sab sahi h but jo match formula me lookup value h bo lookup array kai bar ho toh fir kya hogaa thoda usko clear kar dena please bese apne yah pahle kisi video ke btaya h
Very helpful video Sir thanks for sharing this.
Thanks Rahul ji🙏❤️❤️👍
Super
Lovely boss,
How to formula use of FDT (Financial till date) , YTD (Year till date ),QTD (Quarter till date ) , MTD ( Month till date ) & WTD (Week till date) in Excel format ?.........
You are awsum bro 🙏🏻
Mera 1 questions sir 🙆🏻♂️ hum series no. 1,2,3,4,5 automatically yaa apne logic se feel kr lete hai.. mgr same mujhe Agr Series ki jagah Column A me A,B,C,D,E feel dikhana ho to kya formula hoga ... Maine A to Z tk to kr diya hai mgr mujhe uske aage ki bhi range chahiye Mtlb ki Z ke baad AA,AB,AC show kre Plz solve this my question sir 🙆🏻♂️
Maine kisi mis interview cracker series me bataya hua hai ye ..kindly check.. indirect with char ka use kr skte h
@@Innozant sir us char formula se sirf A to Z tk show krega uske baad kuch or hi text aata hai ..
Great video
I have learnt "index match function"
Very nice sir.. its very helpful 🙏
Thanks ❤️
Thank you very much sir🙇♀️
namste sir ji..i m Hemant ,i hope pehchan lia hoga. sir bahut hi badiya video hai.
Offcourse Hemant Aap bhulne wale insaan ho 😀,Oh Thanks you like the video and learn from there
Index formula was great help.. Thanks :)
You may see complete Video on Index match ,choose ,indirect and offset soon in playlist Excel lookup series..Thanks for watching.Happy learning
Thanks
Owsm ❣️ Sir ❤️
Great..
Hi Nice questions one doubt on last question
What if name column have middle name as well?
Good Sir
sir agar index match array main value same ajaye to?
Last wala bahot badiya tha. If u don't have flash fill
Thanks dear
Nice and helpful video...
Thanks
Crime petrol ke show से भी ज्यादा mujhe आपकी ये crack jobs wali series अच्छी लगती है 😁😂😂😂😂😂😂
Hahaha..Aisa kya..phir to ye series kai Years chalana hoga Nisha 😀
Thank you so much sir. Sir interview ka kaise pata kare. Koi consultant ka number ho to plz share kijiye sir.. ham bhi chahte h interview dete rahe
Ok..pehle to sabhi job portal pe apna updated cv update karen,Saath hi consultant jo before job paise ki baat krta hai bilkul nhi consit kre use.apna cv aap humen bhi send kar dein👍
@@Innozant thank you sir, I will send my resume you today, plz help for me..
Thank you so much sir
Thanks Priya..God bless You.Happy Learning ❤️❤️
Sir plz ap sab kuch to bta diye but agar hamare system me koi farmula nhi hai to kaise laye
Very nic sir
Thanks
Python ka content banaeeye
Sir, please make a video on how to say roles and responsibilities of mis analyst in different industries like bpo, fmcg, manufacturing industry
Thanks for suggestions,Sure dear ,Give me few days only ,Will upload it soon in Career guide playlist, You may find this helpful
ruclips.net/video/Z-ElRbzWL2I/видео.html
@@InnozantOK Thnqqq
You are #1.
Thanks Jha Ji.God bless you..Happy learning
amazing
Thankyou for this videos 😊
Thanks Karan Ji❤🙏
8:50 sir interview me bhi is trha se kar skte Hain vo kuch bolenge to nhi...?
Output is important 👍♥️
Agar firstname middlename lastname ho kaise result aayega. For ex: NIKITA KUMAR PANT aur mujhe n p chahiye.
If the maximum is done by more than one person then how will I find out?
Sir mera interview kal hain dua_o mey yead raknah
Best of luck dear..apna 💯 percent dena..result ki parwah kiye bina
Thank you sir
Thanks
Hii sir apne jo bataya tha name ka first name ka mid name first initial separate kiya apne lekin full name rahega to last name kese nikale
Excel text maharaj dekhiye aap, solution wahan diya gya hao
Formula kese rahega sir uska
how you copy paste formulaes without locking......whenever i am trying the column get shifted.....that's why i need to locked all columns
Just inactive your formula by pressing space before =
I m working as MIS Executive
Great..
keep learning...and exploring
Sir datedif no option mare khoto aave chhe
excellent
❤️🙏 Thanks dear
Great job sir👍
Nice l❤
Thanks dear
@@Innozant ❤❤
😊💯
👍❤️
interview pass hone ke baad kaise reject krte ho sir. haha
Hahahaha ☺️❤️
Would you provide online classes for ms Excel
Yes dear..we are running online and offline classes .You may join for the same
sir MIS and data analyst dono alag hai kya ???
Data analytics me hi aata hai ye sab
Month sahi nhi nikle sir....
Sir i have a question
From 2 sheet find duplicate id name phn no an come on 3rd sheet the duplicate case can come if yes plz solve it sir
share your sheet ..Will check it
Do you offer any courses for mis reports training
You may contact Team Innozant or visit Innozant website for more details
sir please excel ka home tab or insert tab ka sara functions ko explain kariya sir🙏
Ye ti basic video me braya hua hai dear..ok alagse bna denge video
@@Innozant please jaldi sa jaldi please 🙏excel all function explain please 🙏
Sir b.com fresher hu mis main opening dhund rha hu freshers ko kaisi job milti hai
Apne skills jo upgrade kariye..mis ki kaafi jobs aaati hain..Will help you out
11:45
just type first N P then select below coumn and press CTRL + E
Chopra sahab what if I change the source data😀Flash fill or text to column features is good when you want to extract data once..But if my source data change there is no replacement of Excel formula.So recommend you to focus on formula instead of short tricks
2031 mey jo apney formula use kiya hai same use kar raha hu. Par N/A show kar raha hey.
AGR SIR NAME 3 CHARCTER KE H TO FIR KESE NIKALNEGE SHRU KE WORD SAME QUESTION
Which ques ?
@@Innozant text function wle me
Itne easy quetion kon c company m puchte h company bta do
Harpal sahab..ek baaris interview cracker series ke kuch aur episode me aage badhiye..phir btana itna easy ya tough 😊
Sir how to enter in data analyst through mis job experience please suggest
Enhance your excel ,Sql and power BI skills and try to enter as data analyst profile .
@@Innozant is one year experience is sufficient to enter in data analyst if I have a knowledge of advance Excel and sql in mis
Is there have scope in excel for Art stream graduate?
Offcourse,No matter from which background you are.Data science and mis is vast domain and benificial to learn for both Technical or non technical person.
Sir MIS job k liye Arts stream hone se hota hai
But I have experience excel and accounting
Koi fark nhi hai aap kisi bhi stream se hain to..skilled hona jyada eham hai dear❤️🙏
ThnQ
Hle sir
Hi Sneha
Sir test kitne min ka hota hai
Sir aapne bataya nahi kitne min ka test rahta hai. Agar 30 min ka test rahega toh kitne questions rahte hai
What is the full form of MIS???
Management information system
Sir cunseltency ka address share kijiye n... Jahan se interview k liye bheja jaye???
Jha ji is month ke baad thora situation theek hoga,Abhi Innozant consultancy me bhi kam aa rahe hain Interview reference,Sure aap sabse share karunga opening mere paas aayega to.Khod ko ready rakhiye interview ke liye.
Tq so much sir...👏👏👏
5:00 Jyaada paise denge to..bata denge kitne months..kitne days...😂😂😂😂
Hahahaha
Mujhe excel me sab ata hai kya koi gwalior me job hai kya
Hn hai na
@@shdwneon3086 kha par hai please batao
Formula lag nhi Raha h sir
Kaunse no. Ques ka Parul.@innozantofficial telegram id par connect kijiye excel related query ke liye
Sir if i want to take class from you.
visit our website www.innozant.com for more info or whatsapp us.