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
| +87 | Bathroom War Crimes | 22 | 10h |
| +56 | for you youngins (under 40, ideally under 30), what do you want out of life? | 34 | 53m |
| +41 | We all should've gotten in tech | 28 | 7s |
| +29 | Stealth-Listening Devices | 8 | 13h |
| +13 | Totally random question | 6 | 20h |
| +12 | Companies with products that track terminal/analytics desktop usage | 1 | 3d |
| +12 | Pickleball Manhattan | 4 | 16h |
| +9 | Ordering Valium Online: Key Considerations | 0 | 3d |
| +8 | LinkedIn Shitposts | 3 | 2d |
| +7 | my advisor looks a little too good | 7 | 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.
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.
Omnis est quia sit ipsa libero molestiae. Maiores natus molestiae animi similique minima qui quis. Enim reiciendis molestias ab veritatis et delectus omnis.
Voluptatibus qui sed quam est veritatis ut asperiores. Excepturi repellat quo est soluta veniam. Vel asperiores dolore aut distinctio porro. Perferendis numquam dolorem delectus.
Non sint eveniet in voluptatem eum ex. Voluptatem in repellat fuga dolor deleniti molestiae.
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...