Functions like SUMIF, INDEX, MATCH, and IFERROR make it possible to create models that are dynamic and easily adaptable. Where appropriate, use cell references rather than hard-coding values: this will make your model more adaptable. https://finxl.in/financial-modelling-online-classes-courses-training.html