ADVANCED Excel Interview Test

Advanced Excel Interview Test: Can You Pass?
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
🆓 Excel file for this video: https://view.flodesk.com/pages/625058...

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: 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 -   / kenji_explains  
🤳 TikTok - https://www.tiktok.com/@kenjiexplains...

GEAR:
📹 My Favorite Books & Gear: https://kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

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 to you.