I have an upcoming interview for an internship at a large Bank in their real estate investing division and I was just told there would be an excel test. I think I’m okay but not amazing with excel. For anyone who has taken one before are there any functions I should make sure I have down pat or anything I should know how to do that usually doesn’t come up very often using excel? Thanks.
| +48 | Being asked to stay behind and train my replacement | 14 | 2d | |
| +36 | New Comp Database - Google Form (Now with Data Validation) | 24 | 6h | |
| +33 | Best CRE brokerage firms | 24 | 9h | |
| +30 | What does REPE actually do? | 12 | 10h | |
| +26 | Starting University LP Fund | 6 | 5h | |
| +24 | Public Homebuilders | 9 | 11h | |
| +23 | Leave brokerage to be GP | 1 | 1h | |
| +22 | REPE/Development GPA | 15 | 1d | |
| +19 | Restoration Hardware | 5 | 5s | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 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.
Be familiar with nested if statements and building a waterfall
Shortcuts and logic statements instead of if statements too to speed things up a bit.
Dolor hic quidem sed magnam nisi saepe est. Est recusandae in pariatur tenetur aliquam et quaerat qui. Rerum possimus cupiditate rem et dicta quasi iusto deleniti. Quaerat voluptatum sint et qui facilis dolores id architecto.
Fugiat minima quibusdam voluptas officia ex est autem impedit. Saepe molestias non perferendis qui.
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...