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

Подписаться 148 тыс.

Просмотров 5 тыс.

50% 1

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

Опубликовано:

5 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 38

@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..

@anuragsharma2668 Месяц назад

Super very nice

@souvikdas9110 19 дней назад

Last example was excellent thanks sir 👍...

@deboprasadbiswas1987 12 дней назад

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

@KaranSaim Месяц назад

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

@ambarroy9703 Месяц назад

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

@debasisnej6095 Месяц назад

@@ambarroy9703advanced excel pe kaam karo aur different job portal pe apply karo

@Innozant 18 дней назад

Thanks

@StudyWithSunil0101 Месяц назад

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

@Aman_77777 Месяц назад

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

@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

@vasimshaikh5833 Месяц назад

Sir value added 🎉💯😢😊

@ask_puranik Месяц назад

Super sir First comment ❤

@jayantpatel2923 25 дней назад

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 21 день назад

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))))

@rahulsingh-ij7ur Месяц назад

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

@debabratachakraborty847 21 день назад

Requesting to Microsoft stop pivot table

@farooqtahir538 Месяц назад

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

@clone.stonee 23 дня назад

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 16 дней назад

Yes we can do that

@MuhammadZubair-je9th 7 дней назад

=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!,

@boolbool8385 Месяц назад

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

@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

@user-oh1zc4nn2v Месяц назад

fil is different plz check once

@achalrajput4173 29 дней назад

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

@Altaf_Alam 26 дней назад

❤😊

@RahulRoy-po9ct Месяц назад

🙏SIR🙏

@somethingspecial7543 24 дня назад

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 18 дней назад

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

@hemlatamukati2303 26 дней назад

sir apko interview sheet kaise bheje

@Innozant 26 дней назад

@innozantofficial telegram I'd par

@hemlatamukati2303 25 дней назад

@@Innozant ok

@ibrahimqureshi6067 Месяц назад

I'm first❤

@MuhammadZubair-je9th 10 дней назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-aU3NeJVjark.html above mention video link, you perform function in the same worksheet, so pls explain if data in external workbook.