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
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 ?.........
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 🙆🏻♂️
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
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
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👍
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.
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.
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.
Sir I love your all interview Question. You are great teacher👨🏫
Thanks Dear Sandeep
Hello Sir,
My approach for the last question
=LEFT(A2,1) &" "&LEFT(RIGHT(A2,LEN(A2)-FIND(" ",A2)),1)
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.
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❤🙏
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 🙏🙏🙏❤❤
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.
Solid hai bhai... How's the josh... Very high sir aapka 👌🔥
Thanks Akshay ji..Keep learning
This is just amazing... You are a gem
Thanks Aditya❤️
Super play with index formula thank you.
Hi Sir, awesome! great explanation and very useful for excel lerners keep doing same thank you very much your hardwork.
Thanks dear ❤️
Amezing teaching style 👏, ek like to banata h 👍
Thanks Puneet Ji..Happy Learning dear🙏❤️
Thank you for your useful information sir!
Very helpful video for preparing MIS interview! Thanks Sir!
Thanks Dear,Hope it helps
@@Innozant Yes Sir, It helps a lot!!
Thanks for your support it will really help people to crack an interview..
Thanks Jinesh Ji.❤️🙏
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..🙏❤️
Nice questions..
All good question sir 👍
Wonderful teaching
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
Very helpful video Sir thanks for sharing this.
Thanks Rahul ji🙏❤️❤️👍
Hi.. superb video u r uploading for us.. Thank u so much..!
Thanks Pankaj
Your video too much helpful
please make videos Regarding WFM preaparation.
Sir getting more knowledge from u
Excellent video sir
Very nice sir.. its very helpful 🙏
Thanks ❤️
You are great sir🙏🏻🙏🏻🥳
You are awsum bro 🙏🏻
Bahat badhia sir
Thanks ❤️🙏
Helpful ....
Nice and helpful video...
Thanks
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
In last question you also use flash fill
Interviewer always ask Formula based Questions bro
Thank you very much 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.👍👍🙂🙏❤️
Great video
8:50 sir interview me bhi is trha se kar skte Hain vo kuch bolenge to nhi...?
Output is important 👍♥️
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
Lovely boss,
Last wala bahot badiya tha. If u don't have flash fill
Thanks dear
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
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 ?.........
Crime petrol ke show से भी ज्यादा mujhe आपकी ये crack jobs wali series अच्छी लगती है 😁😂😂😂😂😂😂
Hahaha..Aisa kya..phir to ye series kai Years chalana hoga Nisha 😀
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 agar index match array main value same ajaye to?
Owsm ❣️ Sir ❤️
Great..
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
Hi Nice questions one doubt on last question
What if name column have middle name as well?
I have learnt "index match function"
Thank you so much sir
Thanks Priya..God bless You.Happy Learning ❤️❤️
Good Sir
NICE SIR
Thankyou for this videos 😊
Thanks Karan Ji❤🙏
Would you provide online classes for ms Excel
Yes dear..we are running online and offline classes .You may join for the same
Python ka content banaeeye
Very nic 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
excellent
❤️🙏 Thanks dear
Great job sir👍
Sir mera interview kal hain dua_o mey yead raknah
Best of luck dear..apna 💯 percent dena..result ki parwah kiye bina
You are #1.
Thanks Jha Ji.God bless you..Happy learning
amazing
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..
Do you offer any courses for mis reports training
You may contact Team Innozant or visit Innozant website for more details
Super
I m working as MIS Executive
Great..
keep learning...and exploring
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
Thank you sir
Thanks
Sir plz ap sab kuch to bta diye but agar hamare system me koi farmula nhi hai to kaise laye
Sir datedif no option mare khoto aave chhe
Thanks
sir MIS and data analyst dono alag hai kya ???
Data analytics me hi aata hai ye sab
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 🙏
Nice l❤
Thanks dear
@@Innozant ❤❤
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 =
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 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
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
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
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.
😊💯
👍❤️
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 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
Sir if i want to take class from you.
visit our website www.innozant.com for more info or whatsapp us.
AGR SIR NAME 3 CHARCTER KE H TO FIR KESE NIKALNEGE SHRU KE WORD SAME QUESTION
Which ques ?
@@Innozant text function wle me
Hle sir
Hi Sneha
Month sahi nhi nikle sir....
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...👏👏👏
What is the full form of MIS???
Management information system
Formula lag nhi Raha h sir
Kaunse no. Ques ka Parul.@innozantofficial telegram id par connect kijiye excel related query ke liye
Mujhe excel me sab ata hai kya koi gwalior me job hai kya
Hn hai na
@@shdwneon3086 kha par hai please batao
2031 mey jo apney formula use kiya hai same use kar raha hu. Par N/A show kar raha hey.
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