# Self Study Excel

The most important Excel functions, formulas and best practices.

#### Excel Modeling Best Practices

Guide to Excel Modeling Best Practices CFI’s list of top 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...

#### 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 advanced...

#### Index Match Formula

What is INDEX MATCH in Excel? The INDEX MATCH formula is the combination of two functions 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...

#### XNPV Function in Excel

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 instead of...