Archives: Resources

#REF Excel Errors

What are #REF Excel Errors? An #REF error (the “ref” stands for reference) is the message Excel displays when a formula references a cell that no longer exists, usually caused by deleting cells that a formula is referring to.  Every good financial analyst knows how to find and fix #REF Excel errors, which we will…

Continue reading

Documenting Excel Models Best Practices

Documenting Excel Models Best Practices When working on large and complicated financial models in Microsoft Excel, it can be quite challenging to document them clearly for ease of use and understandability. We will discuss several Excel model best practices and other useful tips and tricks that users can apply to maintain and audit their models…

Continue reading

Histogram

What is a Histogram? A histogram is used to summarize discrete or continuous data. In other words, it provides a visual interpretation of numerical data by showing the number of data points that fall within a specified range of values (called “bins”). It is similar to a vertical bar graph. However, a histogram, unlike a…

Continue reading

VBA Variables, Data Types and Dim

Declaring VBA Variables using Dim This guide breaks down VBA variables, Data Types, and Dim. Typically, the very first step after naming your macro is declaring your variables. Variables are names for different pieces of the data that the macro will be working with. However, this sometimes proves difficult since it’s hard to plan ahead how…

Continue reading

Fortune 500

What is the Fortune 500? The Fortune 500 is an annual list of the top 500 United States companies by total revenues – public and private included. The list is compiled and published by Fortune Magazine, which is based in New York, USA. History of Fortune Magazine Founded in 1929 by Henry Robinson Luce, Fortune…

Continue reading

Types of Graphs

Top 10 Types of Graphs Any good financial analyst knows the importance of effectively communicating results, which largely comes down to knowing the different types of charts and graphs and when and how to use them. In this guide, we outline the top 10 types of graphs in Excel and what situation each kind is…

Continue reading

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…

Continue reading

VLOOKUP

The VLOOKUP guide below explains how to use the VLOOKUP function in Excel to search for a value in the first column of a table and return a value in the same row from a specified column. The formula is structured as =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). Key steps include organizing data, specifying lookup and table…

Continue reading

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…

Continue reading

Excel for Finance

Guide to Excel for Finance – Functions & Formulas If you want to learn Excel for finance, then you’ve come to the right spot.  At CFI, we’re on a mission to help you advance your career as a financial analyst…and being an expert at Excel is a big part of that. In this guide, we’ve…

Continue reading
0 search results for ‘