Ignore Title, what excel functions do you actually use (e.g. Index Match > XLookup, VLookup, etc.)?
I'm an intern btw, trying to figure out what funcs are most useful/time-efficient
Using this information I hope to become a finalist in Excel World Cup 2029
| +19 | How do we get as sharp as possible? | 9 | 1d |
| +18 | Q&A | Analyst | 8 | 3d |
| +14 | Best way to kill time? | 9 | 23h |
| +12 | Upselling yourself when you’re unqualified | 1 | 2d |
| +12 | How Are Cornell 7 / GC Members Affecting Your Bank or Firm? | 5 | 11h |
| +5 | Deciding what Keyboard is the best | 12 | 1d |
| +2 | NYC Froyo Spots as Investment Banks | 1 | 5h |
| 0 | Analyst Y1 - Messed up In First Week | 0 | 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.
Index match is most used at my firm, probably the best use of your time to learn.
Index match, offset, sumif, complex unique(filter(), sumproduct (rarely), indirect (very rarely)
INDEX-MATCH > VLOOKUP, but XLOOKUP’s cleaner if your firm uses 365. Other big ones: SUMIFS, IFERROR, TEXT, LEFT/RIGHT/MID, EOMONTH, and some combo of OFFSET + INDIRECT if you're feeling spicy. Also, get stupid fast with shortcuts—functions matter, but speed wins.
Hic ducimus ea illo dolorem fugit. Ut voluptatibus est voluptatem est quidem porro et. Quae magni minus est magnam. Dolorum rerum distinctio est et quisquam nobis.
Ut ut nobis non. Eos dolores natus quae sunt et officia. Atque fugiat tenetur aut ducimus error ipsam molestiae. Inventore eaque molestiae impedit neque incidunt cum. Sed architecto quaerat cum et aperiam corrupti.
In voluptate tenetur atque repellat molestias. Alias laboriosam quae ullam. Aut sit laborum et odio.
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...