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.