ADVANCED Excel Interview Test

Advanced Excel Interview Test: Can You Pass?
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation…
🆓 Excel file for this video: view.flodesk.com/pages/6250588cb77b86620ca21ff0

This is an advanced excel interview test you may encounter while recruiting for a business or finance job such as a business analyst or financial analyst. It consists of 3 questions, which can be solved using the following formulas, and making sure to lock the appropriate cells for efficiency (by pressing F4 for the $ signs):

Q1: IF statement and multiplications for growth rate and percentage of revenues.
Q2: Large function, small function, and xlookup (can also be done with an index match)
Q3: A combination of nested formulas. More specifically, nested if statements, and date functions such as emonth, day, month, etc.
For questions three, this can be simplified by breaking down the solution into several steps as opposed to doing it all in one cell.

Throughout the video, you'll get a breakdown of what the question is asking for, and an in-depth explanation of how to solve it.

Note: there is more than one correct way to do these questions. If you have any other ideas, feel free to comment them below!

LEARN:
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation…
👉 Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-busines…
🏦 The Investment Banking Program: www.careerprinciples.com/career-track/the-investme…
🚀 All our courses: www.careerprinciples.com/all-courses

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Question 1
4:24​ - Question 2
7:05​ - Question 3 (hardest)

Disclaimer: I may receive a small commission on some of the links provided at no extra cost t