Have you ever wondered whether it’s better to use OFFSET or INDEX? Or how about SUMIFS or SUMPRODUCT, which is faster? Should you be using the new XLOOKUP or sticking with INDEX-MATCH (or even VLOOKUP).
Join us to hear from modelling expert, Jonathon Power, CEO of JPA Financial Modelling for this practical presentation to look at many of the Excel functions that are commonly used by financial modellers and explain why some are better than others and why some should never be used in a financial model!
Please visit us here for a list of other webinars and virtual meetups happening over the next few weeks.