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.
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 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.
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
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
Thanks for suggestions,Sure dear ,Give me few days only ,Will upload it soon in Career guide playlist, You may find this helpful th-cam.com/video/Z-ElRbzWL2I/w-d-xo.html
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 ?.........
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
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👍
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 🙆🏻♂️
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.
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.
Gajab bhai..mai hamesha MIS se darta tha..ab thoda asaan Hua. Shukriya.
♥️♥️👍
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.
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.
Sir I love your all interview Question. You are great teacher👨🏫
Thanks Dear Sandeep
How unselfish you are 🙏 god bless you bro...
Thanks dear..God bless you
Hello Sir,
My approach for the last question
=LEFT(A2,1) &" "&LEFT(RIGHT(A2,LEN(A2)-FIND(" ",A2)),1)
Solid hai bhai... How's the josh... Very high sir aapka 👌🔥
Thanks Akshay ji..Keep learning
I appreciate your effort, you are providing us great knowledge. keep going, Thanks a lot sir
Thanks Azhar ❤️❤️
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.
Amezing teaching style 👏, ek like to banata h 👍
Thanks Puneet Ji..Happy Learning dear🙏❤️
Sir no one like you and no competiton of yours🔥🔥🔥
Thanks Karan for such a lovely appreciation dear❤🙏
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 🙏🙏🙏❤❤
This is just amazing... You are a gem
Thanks Aditya❤️
Super play with index formula thank you.
All good question sir 👍
Bahat badhia sir
Thanks ❤️🙏
Very helpful video for preparing MIS interview! Thanks Sir!
Thanks Dear,Hope it helps
@@Innozant Yes Sir, It helps a lot!!
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
Thank you for your useful information sir!
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.
Nice questions..
You are awsum bro 🙏🏻
Your video too much helpful
Thanks for your support it will really help people to crack an interview..
Thanks Jinesh Ji.❤️🙏
please make videos Regarding WFM preaparation.
Helpful ....
Very helpful video Sir thanks for sharing this.
Thanks Rahul ji🙏❤️❤️👍
Hi Sir, awesome! great explanation and very useful for excel lerners keep doing same thank you very much your hardwork.
Thanks dear ❤️
Crime petrol ke show से भी ज्यादा mujhe आपकी ये crack jobs wali series अच्छी लगती है 😁😂😂😂😂😂😂
Hahaha..Aisa kya..phir to ye series kai Years chalana hoga Nisha 😀
Great..
Sir getting more knowledge from u
Wonderful teaching
You are great sir🙏🏻🙏🏻🥳
Very nice sir.. its very helpful 🙏
Thanks ❤️
Thank you very much sir🙇♀️
Excellent video sir
Lovely boss,
Hi.. superb video u r uploading for us.. Thank u so much..!
Thanks Pankaj
Great video
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..🙏❤️
Owsm ❣️ Sir ❤️
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
Nice and helpful video...
Thanks
NICE SIR
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.👍👍🙂🙏❤️
I have learnt "index match function"
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
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
Good Sir
In last question you also use flash fill
Interviewer always ask Formula based Questions bro
Super
Last wala bahot badiya tha. If u don't have flash fill
Thanks dear
Thank you so much sir
Thanks Priya..God bless You.Happy Learning ❤️❤️
Thankyou for this videos 😊
Thanks Karan Ji❤🙏
You are #1.
Thanks Jha Ji.God bless you..Happy learning
Very nic sir
Thanks
amazing
Thanks
sir agar index match array main value same ajaye to?
Thank you sir
Thanks
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
th-cam.com/video/Z-ElRbzWL2I/w-d-xo.html
@@InnozantOK Thnqqq
Sir plz ap sab kuch to bta diye but agar hamare system me koi farmula nhi hai to kaise laye
I m working as MIS Executive
Great..
keep learning...and exploring
excellent
❤️🙏 Thanks dear
Great job sir👍
Hi Nice questions one doubt on last question
What if name column have middle name as well?
Python ka content banaeeye
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 ?.........
Sir mera interview kal hain dua_o mey yead raknah
Best of luck dear..apna 💯 percent dena..result ki parwah kiye bina
Would you provide online classes for ms Excel
Yes dear..we are running online and offline classes .You may join for the same
8:50 sir interview me bhi is trha se kar skte Hain vo kuch bolenge to nhi...?
Output is important 👍♥️
Nice l❤
Thanks dear
@@Innozant ❤❤
Sir datedif no option mare khoto aave chhe
Agar firstname middlename lastname ho kaise result aayega. For ex: NIKITA KUMAR PANT aur mujhe n p chahiye.
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
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..
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 =
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 🙏
Do you offer any courses for mis reports training
You may contact Team Innozant or visit Innozant website for more details
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 ..
sir MIS and data analyst dono alag hai kya ???
Data analytics me hi aata hai ye sab
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
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
If the maximum is done by more than one person then how will I find out?
😊💯
👍❤️
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 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
Hle sir
Hi Sneha
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...👏👏👏
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 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
Sir if i want to take class from you.
visit our website www.innozant.com for more info or whatsapp us.
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
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
Month sahi nhi nikle sir....
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
What is the full form of MIS???
Management information system
interview pass hone ke baad kaise reject krte ho sir. haha
Hahahaha ☺️❤️
5:00 Jyaada paise denge to..bata denge kitne months..kitne days...😂😂😂😂
Hahahaha