Interview excel test

Subscribe

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

Comments (14)

 
Jul 18, 2011 - 2:44pm

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.

 
Jul 18, 2011 - 2:48pm

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

If it doesn't make dollars, it doesn't make sense..... Dear Internet Users, Someday u will regret not reading me. Sincerely, Terms & Conditions....
 
Jul 18, 2011 - 3:22pm

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?

 
Jul 18, 2011 - 3:43pm

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.

If it doesn't make dollars, it doesn't make sense..... Dear Internet Users, Someday u will regret not reading me. Sincerely, Terms & Conditions....
 
Aug 1, 2011 - 4:17pm

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.

If it doesn't make dollars, it doesn't make sense..... Dear Internet Users, Someday u will regret not reading me. Sincerely, Terms & Conditions....
Start Discussion

Total Avg Compensation

September 2020 Investment Banking

  • Director/MD (17) $704
  • Vice President (45) $323
  • Associates (255) $228
  • 3rd+ Year Analyst (37) $203
  • 2nd Year Analyst (141) $153
  • Intern/Summer Associate (133) $141
  • 1st Year Analyst (561) $129
  • Intern/Summer Analyst (544) $82

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.3
2
Jamoldo's picture
Jamoldo
98.3
3
Secyh62's picture
Secyh62
98.2
4
CompBanker's picture
CompBanker
97.8
5
Addinator's picture
Addinator
97.6
6
redever's picture
redever
97.6
7
Edifice's picture
Edifice
97.6
8
frgna's picture
frgna
97.5
9
NuckFuts's picture
NuckFuts
97.5
10
bolo up's picture
bolo up
97.4