Crack Jobs #63 | MIS & Data Analytics Excel Interview Question and Answers

MIS & Data Analytics Excel Interview Question and Answers
Download Practice Set - docs.google.com/spreadsheets/...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
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/innozantinfotech
#innozant #excelinterviewquestions#excelinterview #exceltutorial

[@DataAnalyst251]

Sir ,i watched your videos. i got job as Data Analyst, I'm pretty much working on excel

[@JugalLohani]

Sir, the excel file you have used in the video and the link you have attached in the description, both are different, please check them again... I like your teaching style sir..

[@deboprasadbiswas1987]

Sir, please make a video on how to auto hide and unhide rows by button in google sheet by google app script......

[@Aman_77777]

Sir MIS and data analytics me fresher bhi apply kar sakte hai jo Excel Sikh chuke hai

[@souvikdas9110]

Last example was excellent thanks sir 👍...

[@prashanttyagi1156]

Sir , ye bhi bataye aap ki jo practice fole hai discription mein wo wo mhtml mei download hobrahi hai excel mein kaise convert hogi

[@anuragsharma2668]

Super very nice

[@rahulsingh-ij7ur]

Dada, mix text data theke ki vbe a to z text korbo.

[@StudyWithSunil0101]

Sir proquest series phir se continue kro....
nice session ❤❤

[@KaranSaim]

Hello sir
Today I am doing Mis Executive Job Because of you thaks for everything
Kindly start to make a vba series

[@Abhijit9703]

Bro kon kon sa skill sikha aur job kaha se mila?

[@debasisnej6095]

​@@Abhijit9703advanced excel pe kaam karo aur different job portal pe apply karo

[@Innozant]

Thanks

[@debabratachakraborty847]

Requesting to Microsoft stop pivot table

[@vasimshaikh5833]

Sir value added 🎉💯😢😊

[@boolbool8385]

SIR MERI EK PROBLEM H DOLVE KR SKTE H KYA ECEL RELATED

[@clone.stonee]

Jis prakar se automatic serial no generate karte hai Google sheets me kya us prakar automatic date generate kar sakte hai ?
Plss provide formula

[@UmbrellaInFo882]

Yes we can do that

[@ask_puranik]

Super sir First comment ❤

[@farooqtahir538]

Really in India employers are nuts.Most of these can easily be done with excel function no need of formulas

[@MuhammadZubair-je9th]

=INDEX(C132:E140,MATCH(F132&G131,C132:C140&D132:D140,0),3)
If pressing F9 shows that all values are correct, but the formula still returns #VALUE!,

[@jayantpatel2923]

Hi sir,
I want to know how to find the count of unique values within a single cell
(or)
To find the count of duplicate values within a single cell ?

[@mohitchauhan758]

if the cell value is 12311212224 then
we can count unique value using this formula -
COUNT(VALUE(UNIQUE(MID("cell reference",SEQUENCE(LEN("cell reference"),1,1,1),1))))
we can count duplicate value using this formula
=LEN("cell reference")-COUNT(VALUE(UNIQUE(MID("cell reference",SEQUENCE(LEN("cell reference"),1,1,1),1))))

[@aryanjangid4771]

Sir the file you attached in the description is different from the file you have used in the video please update the same.

[@Innozant]

Oho..will check and update it within a day or 2

[@achalrajput4173]

Sir, oppo , vivo country nahi h company h ( last wale question m )

[@Altaf_Alam]

❤😊

[@user-oh1zc4nn2v]

fil is different plz check once

[@RahulRoy-po9ct]

🙏SIR🙏

[@somethingspecial7543]

Sir I want a Data Analyst Job. I did my graduation in Data Analytics and also did 4 months internship. Sir when I will see the post of Data Analytics. I saw there that they need 2 to 3 year of experience. How to get the job of Data Analytics. Sir Please guide me.

[@Innozant]

Kindly connect with team innozant for more details

[@ArjunGupta-bg2md]

Sir symbol konsa ha sahi se dikh nhi aarha ha

[@ArjunGupta-bg2md]

please share emoji here sir

[@ibrahimqureshi6067]

I'm first❤

[@hemlatamukati2303]

sir apko interview sheet kaise bheje

[@Innozant]

@innozantofficial telegram I'd par

[@hemlatamukati2303]

@@Innozant ok

[@MuhammadZubair-je9th]

ua-cam.com/video/aU3NeJVjark/v-deo.html
above mention video link, you perform function in the same worksheet, so pls explain if data in external workbook.