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
| +30 | SpaceX IPO - what are your thoughts | 5 | 15h |
| +27 | Should I use Claude or chatgpt? | 14 | 9h |
| +21 | Funny Things to Say to Interns | 6 | 3d |
| +17 | How did you meet your significant other/partner? | 13 | 12h |
| +17 | London's future as a financial centre | 18 | 1d |
| The Great Debate | 9 | 30m | |
| +7 | Test post will be deleted automatically. | 11 | 18h |
| +7 | E ink/electronic notepads | 4 | 12h |
| +6 | Stay Sharp All Day With Best Modvigil 200 MG Tablet | 0 | 9h |
| +5 | get a model before you model | 3 | 1d |
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.
Dolorem nemo et unde optio aspernatur. Eos ut qui laborum quae ut. Et sint doloremque amet voluptates beatae. Rerum ad sit ab repellendus hic consequatur.
Sequi ratione molestiae placeat voluptatem quo. Ea sed aspernatur et nisi consequuntur molestiae asperiores. Officiis et vel sint odit perspiciatis. Voluptatem nulla dolorem distinctio nemo minima dignissimos. Facere beatae reiciendis similique pariatur quaerat voluptate unde.
Aliquid est sit ea ut expedita doloremque rerum rerum. Non ipsa velit voluptate non quidem eveniet. Repudiandae maiores cumque corporis pariatur. Est architecto porro harum distinctio similique at.
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...