*********************************************************
Download this Practice Workbook HERE: forms.gle/MLtkd5gBmWhkNkLE6
********************************************************
You might think that an interviewer might ask you what is VLOOKUP, what is SUMIF? But this happens rarely. They don’t just give you a function name and ask.. Tell me how SUMIF works, VLOOKUP or COUNTIF works. Instead, they will specify what task they want to perform and ask you which Excel Feature or Function you’ll use to perform that task.
Let’s look at 10 such questions today.
The 10 questions (along with answers) that are covered in this video are:
1. I have 3 columns called ‘first’, ‘middle’ and ‘last’ names. How do I merge these 3 and create a new column called, ‘full name’?
2. Now I want to split my ‘Full Name’ column into 2 columns with ‘first’ and ‘last’ names. How do I do that?
3. If you have a large dataset, and want the header row to be visible even when you scroll down, what MS Excel feature would you use?
4. How can you prevent someone else from modifying a worksheet?
5. Why am I getting a #N/A when I am using my VLOOKUP Function?
6. In my dataset, I have 3 columns. Student name, subject and their scores. How do I find the sum of all the scores of a single student?
7. From this data, how do I highlight the scores that are greater than 80?
8. I have a list of subjects like History, Chemistry, Maths, Science etc. And the collective marks students have stored in each of these subjects. How do I find the total sum of scores of all the subjects ending with ‘y’?
9. I deleted something and now my excel is filled with #REF errors. How do I prevent this from happening?
10. If I have a huge dataset of Digital Marketing spend of a company. How can I make decisions for the next marketing campaign using this data?
Let’s start learning!
*********************************************************
TIMESTAMPS:
0:00 - Introduction
1:13 - Question 1 (Concat and TextJoin)
2:20 - Question 2 (Text to Columns Feature)
3:40 - Question 3 (Freeze Frame)
4:40 - Question 4 (Protect Sheet)
5:10 - Question 5 (VLOOKUP)
7:14 - Question 6 (SUMIF)
7:55 - Question 7 (Conditional Formatting)
8:34 - Question 8 (Wildcards: * Asterisk, ? Question Mark, ~ Tilde)
10:15 - Question 9 (#REF Error, Trace Dependents)
11:17 - Question 10 (Pivot Tables)
To learn more about Pivot Tables, check our Complete MS Excel Tutorial for Beginners Video, here: • Complete MS Excel Tuto...
*********************************************************
ABOUT THIS COURSE:
Welcome to the third and final video of our MS Excel Course for Beginners!
1. In the first video, we have learnt about the various job opportunities that require MS Excel as a skill, along with how you can access MS Excel for free.
2. The second video is a Complete MS Excel Tutorial for Beginners. I have also created a practice excel workbook for you, that you can download and practise those features along with me while watching the video. (Link to download this Interview practice sheet is in the description of Video 2)
3. And in the third video (which is this one!), we are going to cover 10 most commonly asked MS Excel Interview Questions along with their answers.
So it doesn’t matter if you are a beginner or someone looking to brush up their basics right before an interview, I promise, by the end of these 3 videos you’ll excel at your excel skills.
Don’t forget to comment and tell me what job role you are learning Excel for. It will help me decide what career videos to make next for you.
*********************************************************
LINKS TO OUR MS EXCEL COURSE:
1) Get MS Excel for FREE (Video 1): • How to get MS Excel fo...
2) Complete MS Excel Tutorial for Beginners (Video 2): • Complete MS Excel Tuto...
3) Most Commonly asked MS Excel Interview Questions and Answers (Video 3): • Top 10 MS Excel Interv...
Our Interview Preparation Course (12+ Videos): • Interview Preparation ...
*********************************************************
OUR OTHER VIDEOS YOU MIGHT LIKE:
1) Stock Market for Beginners: • Stock Market Basics fo...
2) Zerodha Trading Tutorial for Beginners: • Zerodha Trading Tutori...
*********************************************************
#MSExcel #CompleteExcelTutorial #Excel2023 #LearnExcel #interview #excelinterview
27 июн 2024
