The most important Excel functions, formulas and best practices.

Excel Modeling Best Practices

What do you need to know about Excel Modeling Best Practices? Microsoft Excel is an extremely robust tool. Learning to become an Excel power user is almost mandatory for those in the fields of investment banking, corporate finance and private equity. With that being said, the sheer strength of Excel also presents certain difficulties. When...

Advanced Excel Formulas Must Know

10 Advanced Excel Formulas You Must Know Every financial analyst spends more time in Excel than they may care to admit.  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.   1. INDEX MATCH Formula: =INDEX(C3:E9,MATCH(B13,C3:C9,0),MATCH(B14,C3:E3,0)) This is an...

Index Match Formula (Excel)

What is INDEX MATCH? The INDEX MATCH MATCH function is the combination of two formulas in Excel: INDEX and MATCH. =INDEX() returns the value of a cell in a table based on the column and row number. =MATCH() returns the position of a cell in a row or column. Combined the two formulas can look...

XNPV Function

Why use the XNPV function in Excel? The XNPV function in Excel uses specific dates that correspond to each cash flow being discounted in the series, whereas the regular NPV function automatically assumes all the time periods are equal.  For this reason, the XNPV function is far more precise and should be used over the...

All Self Study Excel A-Z