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!
We also look at some of the issues that can cause your model to become bloated or sluggish and how to fix it.
All those who register will receive a copy of the recording.