Sir aap Interview cracks tips aur questions bahut hi achai lekai aatai ho. En questions ko karkai muje confident aata hai ki muje aur kitni workhard karni hai. Mera purai weeks ka revision ho jaata hai. You are my legend. Aap hamarai liyai bahut workhard kartai ho. Hamara bhi faraz hai aapki videos ko samjkara practice karkai apni skils ko grow karai. Thank you so much sir ji. Word nahi hai bolnai kai liyai. Thanks...............sir.
2:55 sir ye question =vlookup("zzz",$A$2:A2,1)&B2 isse bhi ho jayega but sir ye "zzz" ka smjh nhi aya apne part mis cracker part 23 me btaya h iske bare me. iski detailed explanation kis video me milegi?
Hii Sir..... Recently I Joined Ethos Watches Corporate office Delhi. When I was giving technical round of excel. There was two question of this video. Q.1 is Sum + VLOOKUP Q2. is Concatenate Both question are copy & paste
Hahahaha...kahin aur jayenge ab dubara to pata chale pura hi copy mile aapko yahan ka...Keep learning, 👍❤️ Kahain bhi interview dena jaana to gurur se se jaana..ki phodke aayenge 😊
Sir ek question h meria related by sort sa for eg meria pass ek data h jisma s.no district block and gp name h tho muja Sort karna h block waisa a to z and gp name a to z aana chaiya filter Mai custamaization so ho nhi RHA plz can u clear that....custamaization
Sort karna hai ya filter..pehle data sort kijiye..major sort dcide kijiye kaunsa field hai Aapka ,pehle Uske bases par sort ..phir Jo data chaiye extract krke wo customize krke dekhiye Apne requirement ke hisab se
Sir ek choti so video baana diyta tho or jaada help ho jaati...plz ek.video baana do sir🙏and u are. amazing sir or Mai yahi chata hu ki apka touch Mai RHA hu or jaada excle kho sikhu
Sir how many Sundays between two dates is question ko thoda aur details me samjhaiye please. You have already made a video but can you please make a detailed one.
Aise comment me smajhana to muskil hai aap Zoom par connect kar Lena Wil explain you.You may whatsapp me on no. 7065069985 will share zoom id with you.
Sir mai aapke dwara sikhna chahta hoon ye sab aapke samjhane ka tarika gajab ka hai bas aap ye bataiye ki aage SQL.vba. aur. Power bl in aabko kaise aur kaha se sikhu jaldi
![KRK - ชนิสรา Ft.WanMai , N/A [Official MV] Prod. By Sakarin](http://i.ytimg.com/vi/C-WMwwYobcU/mqdefault.jpg)
Kisi ne sahi कहा हे sir gyan ko expand karne se ही gyan बढता he.. आप sir हमारे लिये इतने efforts करके video leke आते हो mind blowing sir.
Aplogon ke itne pyare comment mujhe motivate karta hai Kuch behtar lane ke liye.🙏♥️
Sir aap Interview cracks tips aur questions bahut hi achai lekai aatai ho. En questions ko karkai muje confident aata hai ki muje aur kitni workhard karni hai. Mera purai weeks ka revision ho jaata hai. You are my legend. Aap hamarai liyai bahut workhard kartai ho. Hamara bhi faraz hai aapki videos ko samjkara practice karkai apni skils ko grow karai. Thank you so much sir ji. Word nahi hai bolnai kai liyai. Thanks...............sir.
God Bless you dear.. I know you are a dedicated Student and always willing to learn and enhance your skills.🙏♥️
There are so many people in the world but you are unique to us.
Thanks For such a lovely comment..Will always try to make awesome lecture 🙏♥️
Very nice interview of mis explain by you thank you & Happy vijayadashmi
Thanks Pramod Ji🙏♥️Happy Vijaydashmi
Extra ordinary interview questions.....
👍❤️
I watch video excellent explanation sir and now practice start.Good night sir
Great ..GN🙏♥️
Mind blowing questions, thanks for all your efforts
Thanks Mohit👍❤️
I was waiting eagerly.
Thanks Samat Sekh Sahab🙏♥️🙂
Excellent sir.....
Thanks 🙏❤️
@@Innozant sir do you know I really like your one thing you always reply each comment.....and your video is really amazing.........
Regards,
Saifi
Very very good questions
Thank Bhoopendra Raghav Ji..Hope you like the questions and will do Practice for the same.🙏♥️🙂
@@Innozant g sir
Thanks you sir but I saw all this question earlier but not sure where.
2:55
sir ye question
=vlookup("zzz",$A$2:A2,1)&B2
isse bhi ho jayega
but sir ye "zzz" ka smjh nhi aya
apne part mis cracker part 23 me btaya h iske bare me.
iski detailed explanation kis video me milegi?
Data set ke last value ko leke aata hai ..zzz lookup dear ..Maine Kisi video me explain Kar rakha hai sayad tips and tricks series me..🙏♥️
@@Innozant
ok sir g
thank you so much 🙏
th-cam.com/video/rQmN9SzYOBw/w-d-xo.html yahe raha ishu ji "ZZZ" ka link .
Very useful Sir
Thanks Ganga Sagar♥️👍🙂
Excellent.
Thanks Gopala Sir 🙏♥️
Nice sir
Hii Sir.....
Recently I Joined Ethos Watches Corporate office Delhi. When I was giving technical round of excel. There was two question of this video. Q.1 is Sum + VLOOKUP
Q2. is Concatenate
Both question are copy & paste
Hahahaha...kahin aur jayenge ab dubara to pata chale pura hi copy mile aapko yahan ka...Keep learning, 👍❤️
Kahain bhi interview dena jaana to gurur se se jaana..ki phodke aayenge 😊
@@Innozant Bilkul Sir
Apeke Video bhut helpfull for all excel user.
nice informatin sir
Thanks Kashif sahab
@@Innozant my plzr
Easy way concatenate sir hum ese bhi kar skte h =if(a2="",left (c1,len(c1)-1)&b2,a2&b2)
Sir,
INZ AUR NTX KE SATH NUMBER WALE Q. KO AISE SOLVE KARNA SAHI H KYA?
=INDIRECT("A"&MAX(($A$1:A2"")*ROW($A$1:A2)))&B2
Nice sirji Mera kal interview hi va hai mere pass ek test hai apko share krna Chahta hoon
Kar dena @innozantofficial telegram
👌👌👌👌
Sir ager text ke center mai number ho tho kese nikalenge
Iska video bnaya hua hai ..excel tips and tricks me dekhiye..aur Interview cracker me bhi hai solution iska .
Sir i watch all video excel. Inhance my skill fantastic🤘😝🤘 pls make video VBA Macro thanks🌹
Thanks Shukla Ki,Soon we will start a new series after excel 🙏❤️
sir is there any other way to solve Q.2
Good
🙏♥️
Sir pls make the vdos on VBA
Kuch time baad aayega dear..HV patience ❤️🙏
❤️❤️❤️❤️
Sir ek question h meria related by sort sa for eg meria pass ek data h jisma s.no district block and gp name h tho muja Sort karna h block waisa a to z and gp name a to z aana chaiya filter Mai custamaization so ho nhi RHA plz can u clear that....custamaization
Sort karna hai ya filter..pehle data sort kijiye..major sort dcide kijiye kaunsa field hai Aapka ,pehle Uske bases par sort ..phir Jo data chaiye extract krke wo customize krke dekhiye Apne requirement ke hisab se
Sir ek choti so video baana diyta tho or jaada help ho jaati...plz ek.video baana do sir🙏and u are. amazing sir or Mai yahi chata hu ki apka touch Mai RHA hu or jaada excle kho sikhu
right ke sath +1 hoga sir
Sir how many Sundays between two dates is question ko thoda aur details me samjhaiye please. You have already made a video but can you please make a detailed one.
👍👍
Percentage waala concatenate ka another solution
=A2 & TEXT (B2, "0%")
No need to round
You are trying to enhance your skills it's good🙂
gotose blank wala array lagakar fir concatinate kar de fir bhi aa jayega
Kaunse question me ?
First view
🙏♥️
After extracting Text, we can extract Number by using the formula in C2
=substitute(A2,B2,"")
👍👍
👍🏻👌🏻🙏
Kahan gayab rhte hain Karan Sahab
@@Innozant sir kahi nhi sir whats app Question please answers 🙏
last question i attempt it =A2&CONCATENATE(" ")&TEXT(B2,"0%") no need to round.
MIs me kya kya karna hota hai
Reporting work
To sum list containing errors. Simple sumproduct se kyun nhi aa Raha, sumproduct with if ke saath aa Raha hai. Without if se kyun nhi aa Raha
Kaunse question me Mohit Ji?
@@Innozant
6
8
#num!
#value!
5
To get the sum of above.
If ko batana to Hoga na ki error hai inme
🙏
sir second question bilkul samajh nahi aya..please samjha dijiye
Aise comment me smajhana to muskil hai aap Zoom par connect kar Lena Wil explain you.You may whatsapp me on no. 7065069985 will share zoom id with you.
MIS Executive ka course karate hai aap?
Yes offcourse
@@Innozant sir mujhe ye Course karna hai
@@Innozant sir mujhe ye Course karna hai aapse sikhna hai guruji aapka course kaise milega mughe wale bare me bataiye
@@Innozant sir kya charge hai mis executive course ka
Q2 Alternate solution
=IF(A2"",CONCAT(A2,B2),IF(A2="",LEFT(C1,3)&B2))
Inz1,inz2 ... Ka another solution
=If(A2="", replace (C1, Len (C1,1,"")& B2, A2 & B2)
Good
ye solution samajh nhi aya
@@anuradhasharma2449 did you verify this formula???
wrong formula
MIs executive job ke liye kya kya aana chahiye
Advanced Excel ,SQL ,power BI,vba
Sir mujhe to sirf advance excel hi aata hai o bhi kar raha hu
I don't know anything about SQL.vba.power bl ye kaise sikhu sir eske bare me bhi bata dijiye
Sir mai aapke dwara sikhna chahta hoon ye sab aapke samjhane ka tarika gajab ka hai bas aap ye bataiye ki aage SQL.vba. aur. Power bl in aabko kaise aur kaha se sikhu jaldi
Sir 1hi cell me double data validation create होता he aap vo video बना dijiye or सभी को happy कर दीजिए
Data validation Maine abhi karaya kahan hai dear...aane wala hai ab topic..bht kuch amazing milega seekhne ko Nileshgiri Sahab..Have patience 🙂🙏♥️
@@Innozant I am eagerly waiting for your video
=IF (INDEX (ARRAY, MATCH (VALUE, ARRAY, 0))0, CONCAT (TXT, NUM), "")
❤️👍