Very important and interesting questions from interview cracker series. I really like all video and I learn & practice daily new concept thanku sir for all this.good night
2:52 sir 2nd question ke answer me pehle date ke niche ek helper row insert krke usme 0 type kiya.fir date ke column me jha1 likha h uske samne formula ye lgaya =IF(A4=A3+1,"",A3+1) fir A3 row jisme 0 type kiya tha use hide kr diya. ye bhi shi h na?
Haan ye Sahi hai...♥️Pivot Table Multiple workboo aaj Ka video Dekh liye?uski practice bht jaruri hai..patience se dekhna aur ek Baar uski Practice jarur Karna..pivot multisheet aur multiworkbo ok k bht important video h.🙏❤️
sir i have a list of words in which some words contain vowel and i want to extract only those words which have vowel please provide formula. ex- word is subordinate and so on.
sir i have a list of words in which some words contain vowel and i want to extract only those words which have vowel please provide formula. ex- word is subordinate and so on.
Dear Aaliya..Direct practice file link is broken now ..m working on it . Meanwhile you may download all playlist master assignment folder from second link given in any video description m❤️👍
@@Innozant SIR AAPNE REPLY KAR DIYA YAHI BAHUT BADI BAAT HAI MERE LIYE TO. BAHUT BAHUT DHANYAVAAD, KASH AAP PICHLE SAAL DIKH GYE HOTE, KHER AAPNE JO PRACTICE WALI FILES DAALI HAI NA WO OPEN HI NHI HOTI HAI
Under graduate ke base par small level organisation rakh leti hai but aapko graduation jaroor karna chaiye yadi ek behtar career ke liye Jana chahte hain to
Navjot Ji .. Formula Yaad rakhne wali cheej😁Nahi hai.. Pehle concept saara apne Sahi kijiye vlookup series ke videos aur basic excel videos ache se dekhke wo Sahi kijiye ..khub b khud time me Saath formula apply krna aane lgega aur Yaad bhi rehne lgega ki kis scenario me kya formula apply Hoga.happy learning 🙏❤️👍
Sir aapka whatsapp no ya email id provide ho sakti h jisse ki mai question ki pic ya sheet aapko send kr saku taki mughe ans. Essay way mai provide ho sake
Koi baat Nhi Virender,Aapka concern main samajhta hu,But its ok for dislike,may be jinhone dislike Kiya hai unhe Nahi samajh aaya ho ya unke kaam Ka nhi ho..ab unke liye entertainment video to is channel par nhi bana skte Hain na😀🙏❤️
All questions were interesting. I really like this interview cracker series. Aaj kuch naya seekhne ko mila... 🙏
Thanks Vicky,🙏❤️ practice jaroor kiya kijiye
Amazing sir, most of the question I saw first time.
Thanks Hemant Ji,Hope you like the questions
But sir ek hee cretaria use hua isliye to pooch rahi hu sumif use kar sakete aur aapne to sumifs use kiya hai
Sir Your all questions so interesting. Really I salute you. You are super Teachers. I learned lots of thing you.
Thanks Sandeep ji ,God bless you dear.🙏❤️
bhai apki vidyo dekhne me bhot mza atta h advance sikhne ko milta h
Thanks Dheeraj ji
U are great sir bohat kuch sikhne ko mila hai aap se
Thanks dear
This series always teaches something. Thank You Sir
Thank you so much, your questions are very conceptual. Saare concept ka use hota hai aapke questions me.
Thanks 👍❤️🙏
Very informative video sir ji. All questions are very deep and of high levels. Very precious questions 🙏
Thanks Harivansh.. Happy Learning.👍❤️🙏
Sir you are extremely owsom, I solute you
Thanks Rohit Ji🙏♥️😊
Great Learning Sir
Gazab sir, international level tips.
Thanks dear...Happy learning
You are excellent sir...these all are very useful to me...!!*
Thanks Sandeep Ji.. Happy Learning..We welcome you to experience the taste of success with Innozant-Seed of success
Sir You are great teacher 🙏🙏🙏
Thanks dear❤️👍
Very important and interesting questions from interview cracker series. I really like all video and I learn & practice daily new concept thanku sir for all this.good night
Very good Satish 🙂👍❤️😀Good night dear
2:52
sir 2nd question ke answer me pehle date ke niche ek helper row insert krke usme 0 type kiya.fir date ke column me jha1 likha h uske samne formula ye lgaya
=IF(A4=A3+1,"",A3+1)
fir A3 row jisme 0 type kiya tha use hide kr diya.
ye bhi shi h na?
Haan ye Sahi hai...♥️Pivot Table Multiple workboo aaj Ka video Dekh liye?uski practice bht jaruri hai..patience se dekhna aur ek Baar uski Practice jarur Karna..pivot multisheet aur multiworkbo ok k bht important video h.🙏❤️
All questions were interested and useful...
Thanks Jitender.Practise it on regular basis
In question 4, you used sumifs but it we could also solve this in sumif too, right ??
thank you sir for something teaches
Thanks Rameshwar Ji❤️👍🙏
Sir fresher k lye question kya hoge
Your talking style is better Sir Ji
Thanks dear...Happy learning
Sir 4th question ka index match lagane ki jarurat nhi thi ye indirect se mene Kiya easy hai
Most useful sirji
Thanks Sarthak Ji.🙏♥️🙂
sir i have a list of words in which some words contain vowel and i want to extract only those words which have vowel please provide formula. ex- word is subordinate and so on.
Sir, please jaroor bataye ye vedio time 11:45 me sumifs kee sumif lagaa sakte hai kya
Nisha kya wahan single criteria hai..tab sumif na ..aur multiple hai to shmifs ?
Sir q ki saath agar complete month days check kre tu. ksi saturday or sunday ko count kre sir tell me soon
Sir vedio time 11:45 me ek hee cretaria use hua to sumif laga sakte hai kyonki aapne sumifs use kiya kiya hai jis se confusion ho raha hai
Haan..ek criteria ke liye sumif use krenge lekin.sumifs function single criteria ke liye bhi use kar sakte hain isliye jydatar sumifs hi use krte h
Thanks sir 🤗🤗🤗🤗🤗🤗🤗
Sir plz tell me how u have change date into month... I am not getting from custom formating
Great👏
Thanks dear
sir we can also try with this formula in question2 : =if(A3+1=A4,"",A3+1)
in question3. =(ROWS($A$2:$A$12)-MATCH($C$5,$A$2:$A$12,0))+1
are wah..nice attempt Mahesh ji
sir i have a list of words in which some words contain vowel and i want to extract only those words which have vowel please provide formula. ex- word is subordinate and so on.
Thank you so much sir
You Welcome Samir Jo🙏❤️👍Good Night
Good
🙏♥️
Amazing....Not able to download the practice file...please help!
Dear Aaliya..Direct practice file link is broken now ..m working on it .
Meanwhile you may download all playlist master assignment folder from second link given in any video description m❤️👍
Unable to download practice file
Why?
Durect Download link are broken but you may download assignement master from link given in video description
sir nice information
but sir jo student mis course krke aaye hai vo job kese le or fresher mis excutice interview crack kese kare
Thanks Kashif Sahab,Ok bnate Hain Fresher based Interview crack video soon🙏❤️
waise sarthak ne kis company mein interview diya tha?
Company name disclose nhi krte hain dear students ke liye prob hoti hai
@@Innozant SIR AAPNE REPLY KAR DIYA YAHI BAHUT BADI BAAT HAI MERE LIYE TO. BAHUT BAHUT DHANYAVAAD, KASH AAP PICHLE SAAL DIKH GYE HOTE, KHER AAPNE JO PRACTICE WALI FILES DAALI HAI NA WO OPEN HI NHI HOTI HAI
@@Gudakesha158 Chetan Ji..Aaap asignment master folder download kariye,saare student practice karte hain,koi prob nhi hai file me
Sir kya 12th ke bihalf pr ye job mil jayegi
Under graduate ke base par small level organisation rakh leti hai but aapko graduation jaroor karna chaiye yadi ek behtar career ke liye Jana chahte hain to
I Have One Question please solve it.
How can I upload the photo
Upload photo?what you want to do?
Sir you can tell how many questions are asked in the interview
aprox 10 ques in 45 minutes
Thanks Sir And Plz Can you tell me what are major important questions in interview excel
Sir, under MIS ANALYST Sql server also there right, when we will discuss that questions?
SQL is required when we apply for Data analyst.
Plan to make series of SQL in future
@@Innozant what about VBA script?
Step by step will upload tutorial as you already seen I am not just uploading few demo lecture ,Will try to upload complete video tutorial.
@@Innozant OK sir thank you, and ur teaching is awesome
Sir, in the topic of functions, what are the user defined functions
❤️❤️❤️❤️
sir itna kuch yaad kaise rakhenge ?
Navjot Ji .. Formula Yaad rakhne wali cheej😁Nahi hai..
Pehle concept saara apne Sahi kijiye vlookup series ke videos aur basic excel videos ache se dekhke wo Sahi kijiye ..khub b khud time me Saath formula apply krna aane lgega aur Yaad bhi rehne lgega ki kis scenario me kya formula apply Hoga.happy learning 🙏❤️👍
🙏
Sir aapka whatsapp no ya email id provide ho sakti h jisse ki mai question ki pic ya sheet aapko send kr saku taki mughe ans. Essay way mai provide ho sake
@innozantofficial telegram id ..uspar Kar sakte hain koi query ho to
Gd sr but ye dislike kon kr rha h chutiya unpadh hoonge ye log
Koi baat Nhi Virender,Aapka concern main samajhta hu,But its ok for dislike,may be jinhone dislike Kiya hai unhe Nahi samajh aaya ho ya unke kaam Ka nhi ho..ab unke liye entertainment video to is channel par nhi bana skte Hain na😀🙏❤️
@@Innozant 😂😂😂 great
❤️❤️❤️❤️