Archives: Resources

VBA Do Loop

What is Do Loop in VBA? A VBA Do Loop is a subsection within a macro that will “loop” or repeat until some specific criteria are met. The coder can set the loop to repeat a specified number of times until a certain variable exceeds a threshold value or until a specific cell is activated….

Continue reading

VBA For Loop

What is a VBA For Loop? A VBA Loop is a portion of the process that will repeat until the specified criteria are met. The criteria depend on the type of loop used. Loops generally begin with a specific statement describing what type of loop it is. It will end with an ending statement that is…

Continue reading

Find and Replace in Excel

How to Search in Excel Find and Replace in Excel allows you to quickly search all cells and formulas in a spreadsheet for all instances that match your search criteria. This guide will cover how to search in Excel and use find and replace in Excel. Examples of what you might use the Excel Find function to search…

Continue reading

Excel Current Date and Time

How to Insert the Current Date and Time in Excel For anyone working as a financial analyst, it can be useful to insert the current time and date into an Excel spreadsheet. This guide will break down how the Excel current date and time function works and outline situations where it will be helpful in…

Continue reading

#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
0 search results for ‘