What is MIRR? The Modified Internal Rate of Return (MIRR) is a function in Excel that takes into account the financing cost (cost of capital) and a reinvestment rate for cash flows from a project or company over the investment’s time horizon. The standard Internal Rate of Return (IRR) assumes that all cash flows received…
What is Excel Consolidate? The Consolidate Function in Excel allows an analyst to combine information from multiple workbooks into one place. The Excel consolidate function lets you select data from its various locations and creates a table to summarize the information for you. Before you go on to learn more about Excel consolidation, you may…
What are VBA Cell References? After creating the macro and declaring the variables, the next step is to create VBA cell references, which actually refer to each variable and can then be used to manipulate the data within the Excel sheet. Performing actions on variables for data reference are known as VBA methods. To do…
How to Use Excel ROUNDUP The Excel ROUNDUP function allows a user to round a number up in Excel, to a certain number of decimal points. For anyone who performs financial analysis in Excel it can frequently be important to round a number to a specific decimal place or to a whole number. In this session,…
What is a VBA Method? A VBA method is a piece of code attached to a VBA object, variable, or data reference that tells Excel what action to perform in relation to that object. Copying, pasting, and selecting are just some examples of VBA methods that can be performed. (VBA stands for “Visual Basic for…
What is Data Validation in Excel? Data validation in Excel is an existing and accessible tool to ensure data integrity while building a financial model. Although it is only an easy extra step, data validation in Excel is an extremely useful tool to secure your model inputs and outputs. This article is intended to provide…
What is a Pivot Table in Excel? A pivot table allows you to organize, sort, manage and analyze large data sets in a dynamic way. Pivot tables are one of Excel’s most powerful data analysis tools, used extensively by financial analysts around the world. In a pivot table, Excel essentially runs a database behind the…
Learn about the ten essential advanced Excel formulas for financial analysts, including INDEX MATCH, IF combined with AND/OR, OFFSET with SUM or AVERAGE, CHOOSE, XNPV and XIRR, SUMIF and COUNTIF, PMT and IPMT, LEN and TRIM, CONCATENATE, and CELL functions. These Excel formulas are crucial for performing complex data analysis, financial modeling, and enhancing spreadsheet…
Common Confusions in Excel When working on financial models within Excel, it is quite common to come across some of the following confusions. It may seem like Excel is bugging, but in reality, there are some easy fixes to common Excel confusions. Check out our FREE Excel crash course to avoid making these easy mistakes. Common…
