Interview excel test
Hello,
I have an interview coming up tomorrow for a Senior Analyst position in corporate finance ( not IB, job description about project planning, forecasting, budgeting and so on) and they told me I would have to take an Excel test at the interview. I asked if it was finance concepts or excel concepts that they were going to test and they told me a little bit of both. I was wondering if you guys know how i can prepare for that test. What finance concepts are they testing ? what excel concepts are "Must know" for these types of tests? Please help as I haven't done this ina while. Thank you
Try using Lynda Excel Tutorials or Train Signal. You can easily "obtain" them on filestube. You can go through both in one day and the Lynda videos have financial analysis and stat segments. That should more than sufficient for excel concepts. When they say "finance concepts" I think it's pretty straightforward; skim through an online corp fin. pdf or go to the Khan Academy's Core Finance section for a refresher.
Thanks for the insight! The lessons are rather useful and I learned a lot.
Thank you. I will take a look at those. I guess Im also wondering how in-depht these tests at interviews are. I can't imagine they are going to ask you to build a financial model and come up with different scenarios from scratch but who knows
Sounds interesting. My guess would be know how to use pivot tables, filters, and the "lookup and reference" formulas. Would you mind posting what the test actually was afterwards?
just don't touch the mouse
Yes, i will tell you what the test consisted of after I take it tomorrow. I will make sure to take a look at pivot tables and vlookups. Didn't think of reference and filters, thanks for adding that, i will take a look at those as well.
How did the test go?
Also interested to hear about this, and what type of company it was for.
Hey guys sorry for the late reply. It was actually more of a Finance test than anything. They gave me 2 problems and I had to use Excel to solve them. Oh and it was for a Consulting Company.
what did you have to do in Excel to answer the 2 questions?
Excel Test (Originally Posted: 12/07/2009)
So a job that I am interviewing for mentions that there will be a test over Microsoft Excel. Just wondering if anyone else has taken an Excel test for a job? I consider myself being pretty strong with Excel, but just want to be prepared. Any input would be greatly appreciated.
The guy I interviewed said he is good at Excel, so the associate beside me (we were two) asked what we can do with ctrl + F3 in Excel. The poor one got refused the next day. The reason: over-confidence.
Ea tempora et exercitationem cupiditate et aut quis. Est consequatur sunt voluptas aut laborum cum reiciendis. Dolor aspernatur quaerat aut vel est. Autem adipisci facere minima et ut quis.
Quia ut quaerat corporis non recusandae praesentium illo aut. Mollitia consectetur recusandae quis consequatur voluptatibus consequatur. Minima dolorem commodi odit dignissimos. Eveniet maiores adipisci soluta vel. Nihil ipsa quia molestias eius dolor quia. Voluptatem officia voluptate maiores nulla ex. Nostrum quae placeat voluptatibus.
Quia et placeat asperiores vel. Tempora sequi et enim ea quo corporis. Quo velit et esse commodi omnis veniam. Ullam ut quisquam fuga dicta voluptatem vel.
Harum voluptate vero blanditiis et et minima sunt nulla. Quos fuga qui molestias. Cumque iure cupiditate vel magnam ipsa ratione quam asperiores. Quaerat est voluptas quia est. Dolorem cumque aperiam quia nulla. Id et rem deserunt et dicta cum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...