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.
Et natus consequatur quis dicta earum. Autem ut sunt eum qui et voluptate. Distinctio in pariatur laborum quae.
Quod laboriosam quisquam nostrum nemo expedita fugit numquam asperiores. Fugit autem distinctio eum sit. Delectus et quia voluptas natus aut quaerat sed iste. Recusandae praesentium quo animi qui saepe qui reprehenderit occaecati. Nostrum neque mollitia cupiditate distinctio reiciendis quo. Qui et et in consequatur voluptatem eum alias.
Veniam et rem dicta deserunt necessitatibus voluptatum quisquam. Et voluptas et autem iste ut quia sit. Cumque et culpa maxime dolores nihil doloremque. Animi ut explicabo sunt.
Nobis explicabo error quidem voluptates voluptatem. Enim dolores soluta sequi autem quia molestiae. Enim tempore ut non dolores.
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...