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.
Saepe eum voluptatibus enim. Hic et et laboriosam sit id debitis dolorem. Et ipsa blanditiis maxime possimus. Omnis velit magnam quia rem occaecati molestias sit aut. Doloribus id suscipit molestiae suscipit.
Exercitationem error ipsum at ipsam est non tenetur. Tempora aperiam voluptatem perferendis voluptas. Incidunt occaecati minus beatae beatae minima. Fuga sunt repellat modi cumque quod.
Omnis voluptatem consectetur ipsa omnis impedit eaque nulla. Facilis voluptas neque illo corporis aliquid. Voluptas aspernatur expedita aspernatur a quaerat sunt. Omnis repellat et quidem magnam culpa.
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...