Data analyst interview | Excel Interview Questions and answers || Excel test for job interview Hindi

  Рет қаралды 39,999

MData Finnovatics

MData Finnovatics

Күн бұрын

What are the Microsoft interview or excel interview questions for data analyst?
We have taken one of the company's real-life interview questions in Excel. Here, we have 9 different sheets with different problems which we are going to solve in detail by using excel formulas and functions. Please share your feedback or ask your questions in the comment section if you have any.
What are some of the top ms excel interview questions and answers? 🔥🔥🔥🔥🔥
What you will learn in this video:
✔️ Vlookup formula in excel
✔️ Countif formula in excel
✔️ Create drop down list in excel
✔️ Countifs formula in excel
✔️ IF formula in excel
✔️ Cell referencing in excel
✔️ Conditional Formatting in excel
✔️ IF formula with multiple conditions
✔️ IF with AND formula
✔️ Pivot Tables in excel
✔️ How to fill blank cells in excel
✔️ DATEDIF formula in excel
Download Excel File - docs.google.co...
----------------◀◀◀ KZbin Playlist ▶▶▶------------
ADVANCED EXCEL LATEST VIDEOS - bit.ly/3tRuOJ5
EXCEL FORMULAS & FUNCTIONS - bit.ly/33lp6UZ
USE MULTIPLE FORMULAS TOGETHER - bit.ly/350p0Cy
EXCEL SHORTS | EXCEL TIPS & TRICKS - bit.ly/3nx2ojd
EXCEL TOOLS - bit.ly/350Dp1z
----------------▪▪◾◼◼Social Media ◼◼◾▪▪------------
WEBSITE LINK - www.mdatafinno...
KZbin CHANNEL - www.youtube.co...
FACEBOOK PAGE - / mdatafinnovaticsofficial
TWITTER PAGE - / mfinnovatics
INSTAGRAM PAGE - / mdatafinnovatics
COMPANY LINKEDIN PAGE - / mdatafinnovatics
QUORA - www.quora.com/...
----------------------⬅◀◼Blogs◼▶➡----------------------
How to get the List of All sheets with Hyperlink Automatically / How to create indexing in Excel - www.mdatafinno...
---------------✉️✉️✉️Contact Us✉️✉️✉️--------------
EMAIL ADDRESS: support@mdatafinnovatics.com
✔️ Excel interview questions and answers in Hindi
✔️ Microsoft excel interview questions
✔️ Excel interview questions answers for freshers
✔️ Interview questions on excel
✔️ Data analytics interview
✔️ Excel interview questions for business analyst
#mdatafinnovatics #dataanalystinterview #msexcelinterviewquestionsandanswers #msexcel

Пікірлер: 36
@MDataFinnovatics
@MDataFinnovatics 2 жыл бұрын
Call us at +91-9354674901 for Advanced Excel LIVE Training, Excel Automation, Excel Dashboards, and Power BI assistance. 😀😀👍
@GautamKarkera
@GautamKarkera Жыл бұрын
Very Informative video, kindly provide the practice sheet, the previous download link is showing an error
@vedothesinger7319
@vedothesinger7319 Жыл бұрын
Sir plz provide the practice file it would help us...
@panathulamasthanbabu4834
@panathulamasthanbabu4834 2 жыл бұрын
Use datedif function and instead of y-years use ym for year and months, if you also want dates then use md for months and days.
@sumitkumarsao
@sumitkumarsao 2 жыл бұрын
The video is so much informative. Please provide the Practice file.
@MDataFinnovatics
@MDataFinnovatics 2 жыл бұрын
Thanks Sumit, You can download the excel file of all videos from the below link mdatafinnovatics.com/tutorials/
@subbu-manya
@subbu-manya Жыл бұрын
It says Page can't found.
@lakkudawargave
@lakkudawargave 6 ай бұрын
Ohh that's so usefull and helpfull , thank you for making such A video 🤝🎊✨️
@parimalauutade6586
@parimalauutade6586 22 күн бұрын
USEFUL SIR ,but the sheet not accessible,we cant download it for practice
@souravkumar8553
@souravkumar8553 5 ай бұрын
Hello Sir, vedio was awesome and knowledgeable but what you have mention the data set i.e. not completed. So, can you please check once.
@AftabAhmed-uw4ki
@AftabAhmed-uw4ki Жыл бұрын
Very informative video plz upload other video related the excel plz
@MDataFinnovatics
@MDataFinnovatics Жыл бұрын
Sir, we have started uploading the videos. Please check. Thank you!
@nikhilbhute07
@nikhilbhute07 3 ай бұрын
Narrow Minded People will call it Show off, Genius call it Soft Power, Marketing of our Country, Rich Hindu Culture and Tradition.
@rakeshjadhav3498
@rakeshjadhav3498 2 ай бұрын
sir which file you have shared in that file in data sheet some columns are missing like serviceline and employeetype.
@raginishrivastav4264
@raginishrivastav4264 Жыл бұрын
Great video... Great content 👍 😊
@MDataFinnovatics
@MDataFinnovatics Жыл бұрын
Thank you Ragini Ji!
@ubaidillahmuhammad20
@ubaidillahmuhammad20 2 жыл бұрын
amazing job. as usual please put link excel file ,,,
@Legend-sd7gr
@Legend-sd7gr 6 ай бұрын
Sir, please provide proper uncorrupted excel file. The one which is provided in link is does not have serviceline column in data, and also it has bad formatting and bad display
@simransingh-mm4bm
@simransingh-mm4bm Жыл бұрын
please provide the practice file used in the video
@somrajbanerjee3500
@somrajbanerjee3500 Ай бұрын
Sir thoda zoom kariyega, kyuki hum mobile mein dekh rahe hai
@AkmalMirza_29
@AkmalMirza_29 4 ай бұрын
THE DATA FILE YOU SHARED DESCRIPTION IS NOT IN CORRECT FORMAT AND ALSO DATA IS MISSING COULD YOU PLEASE SHARE A PROPER FILE.
@yashigoyal9490
@yashigoyal9490 8 ай бұрын
Please explain level 8 ques again , i didn't understood
@jaysohane3345
@jaysohane3345 Жыл бұрын
your voice is similar to mukesh khanna
@MDataFinnovatics
@MDataFinnovatics Жыл бұрын
Really! Thank you for a good sense of humor!
@excelmaster1328
@excelmaster1328 8 ай бұрын
Company me real time work kya hota hai Excel me ?
@SmitRathod-k3h
@SmitRathod-k3h 9 ай бұрын
Why you pressed f4 three times and on column two times in countifs function
@MDataFinnovatics
@MDataFinnovatics 9 ай бұрын
Here is the concept of pressing f4 multiple times: One time: Freeze the whole cell (Row + Column). Two times: Freeze the row and unfreeze the column. Three times: Unfreeze the row and freeze the column. Please let me know if you have any other queries.
@Legend-sd7gr
@Legend-sd7gr 6 ай бұрын
15:40 Can you please explain this sir?
@niteshmittal6389
@niteshmittal6389 Жыл бұрын
Are you know coachx?
@abhishekpandey3070
@abhishekpandey3070 Жыл бұрын
sql is more imp
@MOHDRIZWAN-ff6qc
@MOHDRIZWAN-ff6qc 4 ай бұрын
Yeh data mil sakta h
@shumettefera3258
@shumettefera3258 Жыл бұрын
Add the phrase 'in Hindi ' to the video title
@MDataFinnovatics
@MDataFinnovatics Жыл бұрын
Thanks, Shumet for informing us. We have added the phrase.
@silverstreet7984
@silverstreet7984 Жыл бұрын
Let me save some time for those who want to practice the sheets in this video. The page can't be found.
@MDataFinnovatics
@MDataFinnovatics Жыл бұрын
Hi SilverStreet, thanks for your reminder. We have uploaded the practice file. Please use the same for your practice.
@rohitbhise6583
@rohitbhise6583 25 күн бұрын
sir please add timestamp
ROSÉ & Bruno Mars - APT. (Official Music Video)
02:54
ROSÉ
Рет қаралды 204 МЛН
How I Turned a Lolipop Into A New One 🤯🍭
00:19
Wian
Рет қаралды 13 МЛН
啊?就这么水灵灵的穿上了?
00:18
一航1
Рет қаралды 101 МЛН
5 MUST-KNOW Excel Interview Questions
11:55
Kenji Explains
Рет қаралды 240 М.
Excel Interview Questions | Excel Job Interview | Intellipaat
40:05
Excel Interview Questions For Data Analyst
31:21
Online Training for Everyone
Рет қаралды 287 М.
Top 10 Data Analyst Interview Questions (with answers)
15:58
Can You Pass This Excel Interview Test?
11:20
Kenji Explains
Рет қаралды 952 М.
ROSÉ & Bruno Mars - APT. (Official Music Video)
02:54
ROSÉ
Рет қаралды 204 МЛН