5 MUST-KNOW Excel Interview Questions
Most common Excel Interview Test Questions you need to know.
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/62ffa6...
In this video we go over 5 of the most common excel interview test questions for business & finance roles such as a business analyst or a financial analyst. The questions are:
Q1: Use two different formulas to look for a value within a table. You can use vlookup, xlookup, or index match for this
Q2: Find the quantity sold to reach 10k in profit. You can use goal seek under what if analysis for this
Q3: Clean this raw set of data. For this you can use the text to columns feature, alongside the conditional formatting to identify the relevant values
Q4: Visualize the data. For this you can use a combo chart with two different axis
Q5: Show by quarter, the quantity sold, the total sales, and the average sale price. This can be found using a pivot table
Note: there is more than one way to do these questions. If you have any other methods, comment them below!
LEARN:
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS
SOCIALS:
📸 Instagram - https://www.instagram.com/careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: https://kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Q1
2:25 - Q2
4:03 - Q3
7:03 - Q4
9:08 - Q5
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Смотрите видео 5 MUST-KNOW Excel Interview Questions онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Kenji Explains 04 Сентябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 237,538 раз и оно понравилось 7 тысяч людям.