I have an interview coming up, which includes a 15 minute Excel test. I am told that if I dont pass the excel test, there will be no interview. Now, I am OK on Excel but I'm not feeling too great about the interview.
Anyone have any tips on how to improve on Excel? Or what consists of these interviews and tests? Anyone done any?
Would really appreciate the help.
| +23 | Layoff Stigma | 12 | 22h |
| +18 | Don’t underestimate how risky joining a startup is | 3 | 1d |
| +18 | Advice for incoming freshman @ target | 5 | 5h |
| +17 | Down bad for career advice | 3 | 1d |
| +14 | How to approach moving offices within a national brokerage? | 3 | 2d |
| +13 | Feeling pigeonholed due to past internships | 3 | 2d |
| +10 | Low Tiew Consulting vs Middle Office at an mid-size Investment Firm | 2 | 3d |
| +9 | Startup offer as a graduate | 1 | 2d |
| +9 | Feeling behind | 1 | 6h |
| +9 | 2027 FT IB Recruiting from Private Credit | 3 | 22h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Take WallstreetPrep's Excel crash course online, its $40, really good.
just did it, its trivial,
data entry, focussing on accuracy, formatting cells (2dp, bold, borders), making a graph from a table, sum formulae, saving (yes, seriously), and if/else/then/while loops in vba.
Interview is tell me about a time when questions, typically around teams and managers, so when you disagreed with someone, when you had to lead someone, had to get a job done with the scope unclear, when you made a mistake, what would you do differently.
gl
Hi there,
I had an Associate asset management interview today and aced it but after I had to do a quick excel test/basic data formula's/manipulation for 15mins, I unfortunately got way too nervous and only completed half of it and just froze, as I did really well on the interview, would they pass me regardless? OR would they pass me and weigh the interview more than the test result? Or would they need a certain benchmark result for the test in order to pass me/even consider the interview?
Also, should I ask them if I can re-do it or shall I wait for them to come back to me and see what they say?
Please let me know your thoughts below.
Thanks
I don't know about PWC, but any excel test I've ever seen has to do with hlookup, vlookup, pivot tables, sumif, if, and formatting.
Where would you recommend to brush up on shit like that? Like on the internet. I've had a look in my local bookshop and there isnt a whole lot there.
I just did a search for excel tutorial and this popped up and seems like it's free.
http://www.excel-easy.com/
That's going to cover a lot of basic stuff. I think the best way to learn is to get the basics down from something like the above, and then play with stuff in excel to try and get down what different formulas are doing, how to create tables, etc. Anytime you have an actual issue you can't figure out, check out a forum like mr.excel.com or something and there is likely a topic there that is applicable to your question (or post one). That really helped me learn a lot of vba coding.
I don't know about the guides being mentioned as I've never used them, but I'm sure they would do a good job as well.
Hi there,
I had an Associate asset management interview today and aced it but after I had to do a quick excel test/basic data formula's/manipulation for 15mins, I unfortunately got way too nervous and only completed half of it and just froze, as I did really well on the interview, would they pass me regardless? OR would they pass me and weigh the interview more than the test result? Or would they need a certain benchmark result for the test in order to pass me/even consider the interview?
Also, should I ask them if I can re-do it or shall I wait for them to come back to me and see what they say?
Please let me know your thoughts below.
Thanks
Curious as to where this was at? Thanks.
Hi there,
I had an Associate asset management interview today and aced it but after I had to do a quick excel test/basic data formula's/manipulation for 15mins, I unfortunately got way too nervous and only completed half of it and just froze, as I did really well on the interview, would they pass me regardless? OR would they pass me and weigh the interview more than the test result? Or would they need a certain benchmark result for the test in order to pass me/even consider the interview?
Also, should I ask them if I can re-do it or shall I wait for them to come back to me and see what they say?
Please let me know your thoughts below.
Thanks
PWC, what position in PWC doode?
Sequi beatae quasi omnis repudiandae iusto harum numquam ut. Est aperiam doloremque et temporibus in laboriosam. Veritatis aut laborum odio assumenda ut quia. Accusamus eius sunt ullam voluptatem quia. Soluta fugit beatae sequi et aut beatae id. Qui aut qui ratione qui porro.
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...