Excel Questions in Interviews?
Should you know Excel cold for your interviews? How much do they expect you to know? Do they ask you specific questions within Excel, how do you do so and so function on Excel, etc? Just want to know how much of Excel do you have to know to get by your full time interviews?
I've never asked (or been asked) an Excel question. There's no need for that, as you will pick it up very quickly.
But I have heard in some interviews, they ask you how familiar you are with Excel... Should you tell them you know Excel or is it too risky because they will start drilling you if you say that?
Extremely unlikely, unless your interviewer is a total prick.
My friend told me of a small MM firm which gave all candidates a computer based Excel test after the interview. Most people failed, so from what he told me, they used it mainly in conjunction with the interview to highlight exceptional candidates.
no real point in asking in excel questions. whats more important is that you understand concepts such as the links between the financial statements and so forth.
I actually got rather arbitrarily asked if I was proficient in Excel. They followed that up with asking about macros. This was in the Deutsche IBD 1st round on campus (for summer, not full-time)
One of my friend got a question about pivot table in her interview with ML.
I've heard about people getting quizzed on pivot tables too. It's most likely the same scenario as anything else in the interview; if you claim any sort of proficiency on it, they won't hesitate to fire up the Foreman.
what a stupid question.
some of the elite teams at some banks give you a modeling interview - you are put in front of a station, given a set of assumptions and have to build a dcf model in two hours. as long as you haven't claimed you are a pro they won't expect you to do anything too complex.
After I told them I have built models in Excel, I was asked what my favorite shortcut is and that's it.....
If you haven't dealt with excel much, say so. Even if you have, don't think you know as much as you think. Nothing pisses me off more than interviewees saying they have experience building models (as an undergrad). You don't have shit and if you do, I'll make sure to grill you to put you in your place.
I was asked how well I knew Excel in an interview once. In the same interview I was also asked how bankers help society at large and what were my thoughts on off shore outsourcing. I'm guessing the interviewer was just being an prick as LB Banker was saying.
I said I had spent two summers making models (valuation and contract pricing) on Excel at a large utility company. Of course I was asked about the models (generally how I'd approached them because I had no experience before, how they were laid out and how they worked). Was also asked about how to reach FCF, because I said I knew how to find it. And the interviewer kept asking, "Are you sure? Are you sure?" to see how sure I was. But no excel-specific questions, because I didn't claim to be an excel expert. I'd taught myself on the job, so I'm not great, but it worked for me.
Like everyone else says, if you say you have experience, you better know you're talking about. Just to make sure I could still do it (after 9 months of doing no finance at all), I did a quick FCF calculation on my laptop in my hotel room before my interview.
Oh, and I was asked how I had estimated CAPEX for certain industrial companies. I said that I'd made the model as a freshman, with no financial experience, and I wasn't concerned with estamating numbers. My job was to make the model. I knew what CAPEX was, but it was my boss and his boss and his boss that would pull numbers out of the hat. I just put in HUGE RED NUMBERS in any model to show that I'd just put a random value to ensure the model worked.
He then asked how I'd use depreciations to estimate CAPEX. I didn't know, but I did, however, make a argument for how it could be used. It was a decent answer, but definitely not what the interviewer was looking for. He then told me the answer, we talked about it for a bit, and that was that. I got the job in the end, and I learned something in the interview.
Haha, I had one interview where the guy asked me how good I was at excel, to which I responded, "I think I know my way around it pretty well".
He had me spend the next 5 minutes reciting shortcuts for things like how to draw a border around a selection, and how to hide and unhide rows. Never made that mistake again..
StreetLuck- how would you have answered that question next time?
"I'm comfortable using Excel, as I've used it for a lot of our projects in school and at some past internships, but I understand that an analyst works in Excel the majority of the time, and has an intimate working knowledge of the program, much more so than I could claim to have at this point. However, I am confident that I will be able to climb up the learning curve quickly once I start."
Something along those lines..
Streetluck - that is some good B.S. I could've used that line on the interview I had last week......I interviewed for a lev-fin position and had listed on my resume that I'd developed financial models. I'm in Corporate Finance at "The World's Local Bank." Training program was mediocre, credit culture is conservative, but unsophisticated. I got drilled on excel and modelling (past experience did not prep me for LBO Models). Needless to say, did not get an offer. I would've been better offer using a modified (since I'm not in school) version of your answer.
Essential Excel skills for Asset Mgt / Interview Prep (Help needed) (Originally Posted: 12/18/2014)
Dear all,
I've an entry-level asset mgt (Fixed Income) job interview coming up next week. How should I prepare for the technical interview qns? I would definitely read up on the Fixed income market. How can I impress the Head of Fixed Income who will be my interviewer?
Apart from that, what are the essential computing skills needed for bond fund mgt? What aspect of VBA? What type of excel skills?
Thank you!
I wouldn't worry too much about the excel if this is entry level...though could be wrongs. Just say you have a strong base in excel and will get better with practice. not sure on this.
Make sure you have an opinion on what's attractive. High yield vs investment grade vs treasuries vs munis vs mbs vs short duration vs long duration. Know that yellen just hinted at not raising rates for 2 more fed meetings. Know what the possible implications of the fed raising rates mid next year are. Know that most bond managers have been wrong in holding shorter duration for the past few years. Have a view on foreign bonds and emerging market bonds. Have an opinion on oil prices and high yield debt, oil companies make up ~17% of the high yield market. We saw high yield spreads widen as oil has gotten real low, is this a buying op as the spread got over 550 bps? Though now i believe it has come in a little.
Know this stuff. Be familiar with where spreads are at. Show you understand the fixed income market. Definitely know what kind of fixed income shop you are interviewing at and read everything recent from the PM / strategist. Be able to explain what duration is and the inputs used in calculating it. Be prepared to be asked about the yield curve, flattening vs steepening.
I haven't worked in fixed income, but rather wealth management, so this is my best guess and what you would want to know at a minimum.
I'll echo the above -- for many Asset Management skills they are more concerned with your handle on the markets and your thought where opportunities lie vs if you can do vloookup. Unless you're gonna be a security analyst drilling down into a balance sheet you should be fine. I'm a client portfolio strategist type on a uhnw team and most complex things I do are making formulas that pull from factset etc
If they ask you excel questions then its not a place you want to work. having said that, just do what MTMW said.
Agree with other posters, I don't know what area of the bond market the team you're interviewing with focuses on: gov't, corporates, agencies... but always have an opinion if they ask you a macro/specific market question, has issuance been light? what part of the curve looks overvalued/why and should it be, explain how convexity influences duration... With what's going on in FI there are dozens of timely things you could bring up (highly levered shale plays and crude vol blowing out high yield spreads..). As for excel, I don't think you have to buy the VBA crash course manual but I would be comfortable with vlookups, index/match, offset... nothing insanely difficult. If you already know some VBA I would assume rudimentary excel functions aren't an issue for you. Best of luck with the interview.
Review any Stiffel comments or Jones Trading; check Bloomberg for highlights.
Excel knowledge for interviews (Originally Posted: 02/05/2009)
So I am an undergrad and as interviews are coming up I was wondering how well should I know excel for an interview. Now I know the basics of it and use it when doing dcf valuation models but I would not say I am great at it. Now I am trying to improve my skills by a lot. What would you guys recommend I do to get really good at excel, especially with what you need it for with banking annnd is it common to get excel questions or have to take an excel test for an internship?
I've never been asked an Excel question in an interview.
Agreed, I have never been asked about excel in a banking interview. I wouldn't worry about it unless you specifically claimed to be an expert or something on you resume or you have years of experience in banking.
NEVER lose your BlackBerry www.conveniencesoftware.com
yeah I can't imagine asking someone what Alt E S T does....
they key is knowing why you are doing what you do in excel
...I've never been asked excel questions in interviews.
If you're looking to improve though you could just use excel to do some things you'd do anyway, or think up projects you'd be interested in modeling. For instance, I used excel to automate my personal budget, set up a calendar, and made a model of the NFL season to see if I could spot any interesting trends. You'll get more comfortable in general, and while it's not advanced financial modeling, it is a good bit more interesting
Ctrl + 1 that b*tch!!
Agreed. You will very quickly become an expert in excel on the job. It is hardly a basis for hiring decisions.
~~~~~~~~~~~ CompBanker
never been asked, but learning about macros will make your job a hell of a lot easier
Quas enim nisi a et eos ut. Et dolor quibusdam sed corporis.
Distinctio consequatur omnis earum non nihil harum. Perferendis iure quis voluptas rerum odit quos. Recusandae at quos qui quae alias et provident. Id vel occaecati corporis nihil blanditiis labore quam ut.
Dicta possimus eius optio at totam. Ea in quam consequatur facere tempora deserunt voluptas. Magnam ea minus quas vitae ad consequatur ex. Possimus dolorum dolor dolor illo et blanditiis quia.
Quis eos odit omnis omnis officiis quidem incidunt. Adipisci asperiores et at maxime nulla possimus aliquid. Minima dolore nam autem sit minus consequatur.
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...
Deleniti excepturi repudiandae enim enim. Ipsa expedita praesentium rerum voluptatem. Sit aut rerum beatae nesciunt dolor error expedita sit. Illo est qui et exercitationem.