Hey everyone,
I have a supderday coming up with one of the big 4 for transactions. HR told me that there will be an excel assessment test. Anybody know what it is? Has anyone taken one before? What should I expect? It would be really helpful if you guys could shed some light.
Thanks
| +18 | Final round interview with CEO | 2 | 19h |
| +18 | Feel like an underdog and can't seem to break into IB | 3 | 10h |
| +17 | Quant Position or a PhD Offer? | 3 | 1h |
| +16 | Do I Still Keep Trying to Land FT? | 12 | 2d |
| +15 | Quitting and Foregoing PE Offer | 0 | 3h |
| +12 | freshman: what to do to get ahead? | 2 | 3d |
| +10 | PJT Superday Questions London | 8 | 1d |
| +10 | Reneging 1–2 weeks after accepting FT offer, with nine months until start? | 3 | 5h |
| +10 | Need help with confidence - networking | 4 | 5d |
| +9 | Senior Off Season Recruiting vs. SA 2027 Internship | 1 | 3d |
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.
just some basic macro scripting, collections, hash tables etc. you'll be fine.
Yeah you'll definitely be asked about sorting, like the algorithmic nuances between tree sort, merge sort, and bubble sort, and how they're applied when you click the "sort" button in Excel.
You should also be strong to quite-strong with objects (Meet the Parents, anyone?), because you'll use those a lot too.
Excel Assessment (Originally Posted: 11/21/2013)
Next week I have an interview at McLagan consulting. They said they are going to give me a excel assessment. What should I expect on this test?
V-look up, H-look up, Pivot table? anything else?
thanks
Personally like Index(Match) better than either of v look or h look up, i would learn that. Sumifs, pivot tables, paste specials, etc are all probably fair game. Also learn to format quickly, probably a part of the test.
And dont use the mouse
Excel Assessment Test (Originally Posted: 02/01/2012)
I have an interview coming up soon and in the e-mail I received I was told that I may be given an excel assessment test....In the job listing "intermediate to advanced" excel skills are expected.
My first question is: How common are excel assessments for analyst hires?
2nd: If I am somewhat proficient in lookups, if statements, and pivot tables, but have no experience in macros...should I be nervous about this test in the chance that I do end up being asked to take one?
Did you state a level of proficiency with excel on your resume?
no..i just have it listed under skills.
Nihil perspiciatis officia itaque maxime sint. Sunt quos voluptatem eum dolorem aut consectetur. Voluptates qui officia rerum.
Doloribus aliquid quas est et est. Facere iste error beatae iure voluptas. Voluptas rerum iste veritatis in. Quam rerum iste temporibus id. Ex saepe quod aut quaerat et ex minus minus. Saepe fuga deserunt iste assumenda accusantium ex perspiciatis.
Perferendis dolor quo voluptatem recusandae natus placeat. Non nostrum autem error laboriosam expedita voluptas. Voluptatem saepe rem aliquam cupiditate unde ipsam sequi et. Sint ut tempore quia dolorem dolorum.
Saepe quidem officiis sint rerum. Non eius deleniti sed. Sit quis repudiandae in sunt quas. Ea possimus quidem qui deserunt nam quibusdam ipsam.
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...