Hey guys, as I've posted on here before, I've been laid off for a few months now. I have an interview coming up where I'm going to have to take a 20 minute excel test. Since I've been out of work for a few months, I want to brush up on my excel skills. Anyone have any templates I could use to get some practice ? Also, any tips ? The interviewer mentioned VLookup and formatting as some of the stuff they would test.
excel test for interview
The excel test will include key functions that are used within your sector. However, there are some basic functions in excel that are standard across most industries. Focus on the basics of
I've taken 2 of these for F50s, one for tech and one for manufacturing.
The tech one, they gave you a bunch of random data on prices and click-through rates. They wanted you to then come up with recommended pricing and a sales forecast. This might be useful for an FP&A role? However it seemed like they intentionally left out key information to see what assumptions you would make and whether you could deal with the ambiguity.
The manufacturing one, they provided an investment scenario and gave key inputs (initial investment, cost of production, etc) and wanted a go or no-go decision. You needed to build out an income statement and cashflow and account for things like changes in FX. From what I've heard, this is a much more standard type of excel test for corp fin.
Ready to improve your modeling skills?skills and ace your interview. Click the button now to start your training.