VBA Quick Reference Guide This VBA quick reference guide provides a list of functions for VBA in Excel. This guide will help you prepare for CFI’s VBA Modeling Course. A workbook Workbooks(“MyBook.xls”) A worksheet Worksheets(“Sheet1”) or Sheets(“Sheet1”) A cell or range in A1 convention Range(“A1”) or Range(“A1:C5”) Several cells or ranges Range(“A1,C5,D11”) or Range(“A1:C5,F6,D2:E5”) A…
VBA Dictionary This VBA dictionary is a useful guide for anyone wanting to learn how to use VBA in Excel modeling. Review each of the terms and definitions in the VBA dictionary below to learn the fundamentals before taking CFI’s VBA Financial Modeling Course. Download our ultimate VBA cheat sheet for a comprehensive list of…
What is the Goal Seek Excel Function? The Goal Seek Excel function (often referred to as What-if-Analysis) is a method of solving for a desired output by changing an assumption that drives it. The function essentially uses a trial and error approach to back-solving the problem by plugging in guesses until it arrives at the…
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…
