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

[@raghavmakwana22]

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 👆🏻

[@lakbaylaboy2644]

This is the best ever interview ever! Vani you are the true epitome of Kiss….

[@theronaldo84]

Excellent, thanks to both

[@chanchalarya983]

excellent mam, very informative video for data analyst, plz make such video plz

[@kunjalsahu3504]

Very nice 👌👌👌

[@IvyProSchool]

Thank you! Cheers!

[@ArvindSingh-qm2nh]

Great Job

[@rickeyjones729]

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.

[@gayatrimahajan3873]

Excellent 👌

[@shrikantshirsekar]

Excellent

[@sanjanadasburman2490]

Wow, Vani. Great job. You answered them all very confidently❤

[@IvyProSchool]

Yay, She did 😍

[@CSE-AshikAhamedP]

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

@@IvyProSchool please make more mock interview sessions for excel. It helps us to crack interview

[@rickeyjones729]

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.

[@nikhilthakur423]

Superb interview wani....

[@rickeyjones729]

Row and data text to column and select the delimiter and concat brings them together

[@rickeyjones729]

Change data to dynamic. To keep it updated and current.

[@rickeyjones729]

Create a new sheet. Select row and than control g select blanks and put in new value

[@gunnu61]

Were all the answers correct ...plz tell?

[@abhimanyutiwari100]

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

[@pavanelisetty9076]

👏👏👏👏👏

[@vaniagarwal7595]

Thank you Pavan😁

[@Manjitsingh-wc1xz]

Video like this make us feel depressed

[@achyutshukla3236]

Yesssssssss😔😔😔😔

[@rickeyjones729]

Vlook up will return the top 1st