1:1 Advanced Excel Interview Session | Excel Training | MS Excel | Dashboards | IvyProSchool
Common Excel Interview Questions are as follows:
1. What are the limitations of Vlookup? - 2:15
2. How to identify Duplicates in a dataset? - 3:25
3. How to delete Duplicates? - 4:09
4. What is the usage of Pivot Tables? - 4:25
5. What is the usage of Calculated Fields and Show value as? - 5:00
6. What are Text Functions? Can they be used on Numbers? - 6:46
8. Why do we need Charts? - 9:33
9. When to choose Donut chart over Pie chart? - 10:15
10.Why do we need Scatter Charts? - 11:40
11.How can we make Pivots dynamic? - 13:34
12.How and when do we use Advanced Filter? - 15:08
13.How to replace blank cells with some value? - 18:10
14.Which chart to prefer when we have a timeline associated with the data? - 19:24
15.When do we use Bubble charts? - 20:15
16.How to split data into multiple columns and vice versa? - 22:04
17.How to create a Dashboard? - 23:14
Learn Python with Ivy Pro School: • Data Structures In Pyt...
Learn more about our Students Success Stories: • Ivy Pro School Student...
Liked the video?
Subscribe to Our KZread Channel to get regular updates on amazing Data Science Industry Talks, Interviews, and Webinars.
Like and follow Ivy’s Facebook, Instagram and LinkedIn page to get data science career tips, interview opportunities, etc:
Facebook: / ivyproschool
Instagram: / ivyproschool
LinkedIn: / ivy-professional-school
Want to take a Data Science Course with @IvyProSchool - visit us at bit.ly/39OOhgM or call us at 7676882222
#AdvancedExcel #DataScienceTraining
Пікірлер: 27
We want this kind of interviews! I really learned so much from this. It’s a request to Ivy Pro School select proper candidates for interview like her 👆🏻
Excellent, thanks to both
This is the best ever interview ever! Vani you are the true epitome of Kiss….
Great Job
Excellent 👌
Superb interview wani....
excellent mam, very informative video for data analyst, plz make such video plz
Excellent
Charts are to take the raw data and showing areas to follow module for the end user to make business decisions you can use narrative charts, donut charts which ever effectively and is easily understand. Scatter plot shows the outliers. And the trend line shows the movement and allows u to sort out the data that is not the norm.
Row and data text to column and select the delimiter and concat brings them together
👏👏👏👏👏
@vaniagarwal7595
3 жыл бұрын
Thank you Pavan😁
Very nice 👌👌👌
@IvyProSchool
2 жыл бұрын
Thank you! Cheers!
Wow, Vani. Great job. You answered them all very confidently❤
@IvyProSchool
3 жыл бұрын
Yay, She did 😍
@CSE-AshikAhamedP
2 жыл бұрын
@@IvyProSchool Great mam your name bcoz I want to see you in Sql interview session. by that asking questions will be helpful for me
@telugu4529
11 ай бұрын
@@IvyProSchool please make more mock interview sessions for excel. It helps us to crack interview
Change data to dynamic. To keep it updated and current.
Can do a filter on each row. And condition formatting. Pivot table extract data and do summaries and calculations based on the fields you select. Show value as an avg total. How do u want it calculated.
Create a new sheet. Select row and than control g select blanks and put in new value
Were all the answers correct ...plz tell?
Are those questions asked in fresher interview?
@shubham-uc6ih
Жыл бұрын
Fresher ko koi leta hi nahi bro market ma in course bechne vaalon na webdevelopment or data science ki hype create kar k lakhi ha par ground reality dekhoge to bahi dar jaaoge 1 vacancy k liye 15000 applicants apply kar rahe ha jobs bahut limited ha or data analyst ma bahut bheed ho chuki ha
Vlook up will return the top 1st
Video like this make us feel depressed
@achyutshukla3236
2 жыл бұрын
Yesssssssss😔😔😔😔