So you guys have been really awesome with me! I'm finishing my last week of job search and I have a final round "Excel test" with a fund of hedge funds.
What kinds of skills would I need? I can do pivottables, lookups, macros and VBA scripts... is there anything else I need to know? Does anyone have like an example dataset [or link to one] that would be helpful?
Thanks everyone.
| +57 | One year since I didn't get a return - advice | 4 | 14h |
| +22 | Contradictory and Bad End of Year HR Review | 7 | 1d |
| +20 | Left industry… can i return? | 5 | 21h |
| +18 | A few superdays but no offer, am I cooked? | 1 | 1d |
| +16 | Recruit for FT IB or Focus on VC? | 5 | 15h |
| +16 | I have hit rock bottom | 4 | 2d |
| +12 | Deferring a year to reapply | 3 | 4d |
| +11 | What do I do atp | 16 | 2h |
| +11 | I genuinely hate coffee chats so much | 3 | 1d |
| +10 | Is moving to Houston worth it? | 5 | 2d |
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.
sumproducts, arrays, embedded if statements, pv, irr formulas would all be useful to know... general formatting shortcuts, indirects to other worksheets/named cells, etc...
not sure how difficult it will be, but excel has so much functionality built in that it just comes over time, sounds like you're fairly well prepared tho...
Thanks Rufiolove. I have done arrays before in Java, but what would be the application in Excel? Do you know of any resources for looking at how some of these things are used?
Ea ut dolorem omnis quibusdam nam nam modi sed. Ab non corporis asperiores excepturi in. Voluptatum ut enim velit eius doloremque. Ad quia sint officia doloribus quisquam. Doloremque dolor deleniti natus inventore sit.
Porro aliquid aperiam sunt magni nihil aut ab ut. Corrupti sed alias ea qui voluptatum reprehenderit. Et blanditiis quaerat commodi blanditiis hic repellat. Pariatur et minima sequi dignissimos. Numquam aspernatur nisi quam eum praesentium. Natus quos soluta accusantium sapiente qui aut mollitia.
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...