Excel World Cup Finalist Training
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
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...