Crack Jobs #38 | MIS Interview Questions and Answers | MIS Executive Work details
HTML-код
- Опубликовано: 5 окт 2024
- MIS Interview Questions and Answers | MIS Executive Work details | How to crack interview. Learn how to clear excel interview? Excel formulas and function based real time interview question faced to clear excel job interview. MIS Job Seeker interview experience revealed.
MIS Interview Cracker Playlist Link- • MIS Interview Cracker
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
1. Find Repeated words in a Cell
2. Extract Name from Dataset using appropriate excel lookup and error formula
3. Pivot Table Questions,
4. Sumifs Questions
5. Vlookup with Large and Small functions
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#misinterviewquestionsandanswers#misinterviewcracker#Innozant #excelinterviewquestions#msexcel
Sir sare question samag main aya weekday wala samaj main nehe aya mind blowing sir you are great teacher mujhe tumara jesa teacher ke jarurat ha
Thanks Dear Shiva..Ek baar aur recap kroye wo bhi aayega.samajh
Jab jab youtube par excel k baat hogi tab tab aap ka contribution sab se upper hoga innozant dil se❤️
Thanks Puran for your true love and support..God bless you dear
Sir real me sabse jyada gyan aap hi expand kar rhe ho इसीलिए aap ka gyan भी increase ho rha he क्योंकि kisi ne shi कहा he ki gyan ko expand karne se ही gyan बढता हे.. There are so many people in the world but you are unique to us.. Aap hi hamare mentor ho..
Thanks Goswami Ji..Happy learning dear,Humesha koshish hogi mero better content deliver krne ki
Sir aap itne efforts karke hanare liye video banate ho mind blowing sir utna efforts pure you tube koi भी नहीं karta hoga or aap real me punctual ho.. Please believe me that I never tell a lie..
Ye saare effort mere aap sabke behtar kal ke liye dear.🙏
Dear Sir
Again very informative & useful excel interview cracker. Every time when I watch the interview tutorial , I learn & learn from it. Thanks again for uploading such type of tutorial
Thanks
Jayanta Bhattacharyya
Thanks Jayanta .Happy learning dear
Questions are really thought provoking. I am practising crack jobs now a days.
Thank you ,Sir.☺☺
Thanks Deepak.Really means a lot to me.Keep learning concept and Interview cracker..
Very effective qus. Sir .. Her baar hame exam cracker per naye naye qus. Aur knowledge milta hai.... Sir ye fresher ka interview tha ya experience..... 🙄🙄🤔
Thanks Pragati..Happy learning.❤🙏
its for both
Thank u so much sir... seriously with help of ur videos I cracked mis interview nd got a job. Truly Thank u ☺️☺️ and I wish god fulfill ur all wishes toooo
Wow Radha...M truly happy for you..God Bless you dear..Have a wonderful career ahead.
Learning stop mat karna sat sun time milega to jaroor apni further study continue rakhna ,Abhi bht kuch swwkhna hai,Power Pivot ,Power Query and Power BI ,Time ke saath sab karaunga main.❤❤🙏🙏
Sirji Replace, substitute aur search zabardast functions ko milake solution yeh raha apke samne
Innozant(545556)
=substitute(Replace(A2,1,search("(",A2),""),")","")
Output = 545556
Very Nice Mohan...Good attempt and solution too
Thank you so much sir ji, I like this Interview cracker series very much.
Prnam Guruji 🙏
I was waiting your video ..
Thanks dear
I always feel thankful to be your student..
God bless you Suvankar
Very good and important question sir.
Thanks
Thanks Tejpal Ji
Bahut badhiya, interesting or valuable content Sir jii... 😍😍❤❤
Thanks Jitender ji❤🙏🙏
Sir table array ki jagah transpose formula use
yes
very nice sir, its too hard for me but i will try it so many times.
Thats good..Recimmned you to learn concept first then proceed with Interview Cracker
Thanku sir again help to how crack interview. kaise hai aap.sir we kindly request you pls uploaded video daily🙏🙏🙏.have a nice day sir.
Yes m trying to upload videos on regular basis
sir jo 2nd question jisme hme NUMber nikalna hai , kya vo vaise hi hoga jo apne sikhaya tha text aur number ka alag alga karna ...usi se hi ho jayga na sir ??
Sir extract numbers from text can be done in google sheets using this formula filter(flatten(iferror(ArrayFormula(split(I3:I17," ")*1),"")),(flatten(iferror(ArrayFormula(split(I3:I17," ")*1),""))0)*(flatten(iferror(ArrayFormula(split(I3:I17," ")*1),""))""))
Sir, question no :- 4 m ek doubt h jesse video m solution btaya h usse answer sahi nahi aata jb hm same day s start kre to wo agli date nahi de pata jbki usi date ko de deta h .....matlab...agar aaj monday h or hme agla monday kis date ko pdega nikalna h to video m btaye gye solution k according answer correct nahi aata usi date ko de deta h.
Mere me value error aa rhi h sir transpose wale formula me
Columns formula columns index num ki jagah
haan kyu nhi
SIR 1st Question Vlookup or match se bhi answer aa jayega
=VLOOKUP(B$12,$A$1:$G$4,MATCH($A13,$A$1:$G$1,0),0)
thats good❤
nice
Thanks Tushar ji❤
Very good sir
Thanks dear
🙏
hi,
please create a video
how to use greater than and less than in excel with IF condition alongwith vlookup.
if and vlookup videos are already uploaded ..will create more videos for the same soon
@@Innozant I watched, but greater than less than condition missing
ok will make videos for the same
Innozant sir👌👌👌
❤❤🙏🙏
Superb support
Thanks dear
SIR , 12:19 में iferror bhi use kr sakte hai ?
haan..
Sir Google Sheet ki video bhi upload kariye it will help us 🙏
haan google sheet ke videos bho banayenge
@@Innozant okay sir tysm ❤️
❤️❤️❤️❤️❤️
👍👍👍👍
thanks mohit ji
🙏
Gm..Thanks Gaurav ji
sirji practice sheet nhi mil rha crack 38 ka😔
haan aaj update kar dunga link
YEH SECOND QUESTION K LIYE YEH FORMULA BANAYA =MAX(IFERROR(VALUE(MID(B4,MIN(IFERROR(SEARCH(SEQUENCE(10,,CHAR(48)),B4),"")),SEQUENCE(LEN(B4)))),""))
Download the Practice Workbook Direct Link updated soon.WAIT SIR
Will update today
the first question can be done through hlook up.we do not need to transpose the table array