Module VI· Excel Setup & Best PracticesIntermediate
Question

Which Excel functions do you use most often in daily modeling?

Answer

Common functions include SUM, AVERAGE, MIN, MAX, IF, IFERROR, ROUND, INDEX/MATCH or XLOOKUP, SUMIF/SUMIFS, COUNTIF/COUNTIFS, CHOOSE, EOMONTH, YEARFRAC, NPV, XNPV, IRR, and XIRR. In banker models, simple transparent formulas are usually better than clever formulas that are hard to audit.