Based on years and years of experience, we have compiled the most important and advanced Excel formulas that every world-class financial analyst must know. INDEX MATCH. ... IF combined with AND / OR. ... OFFSET combined with SUM or AVERAGE. ... CHOOSE. ... XNPV and XIRR. ... SUMIF and COUNTIF. ... PMT and IPMT. ... LEN and TRIM. More items...