Archives: Resources

Correlation Matrix

What is a Correlation Matrix? A correlation matrix is simply a table that displays the correlation coefficients for different variables. The matrix depicts the correlation between all the possible pairs of values in a table. It is a powerful tool to summarize a large dataset and to identify and visualize patterns in the given data….

Continue reading

VBA Quick Reference

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…

Continue reading

VBA Glossary

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…

Continue reading

Goal Seek

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…

Continue reading

MIRR Guide

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…

Continue reading

Excel Consolidate

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…

Continue reading

VBA Cell References

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…

Continue reading

Excel VBA Examples

Excel VBA Examples – Macros The best way to learn to design your own Excel macro in VBA is just to jump right into it. Naturally, you’ll need to know how to enter the VBA editor and set up the macro, how to declare variables, and how to reference data. This guide will use Excel…

Continue reading

ROUNDUP Excel

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,…

Continue reading

VBA Methods

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…

Continue reading
0 search results for ‘