What is a Formula vs Function in Excel? A Formula is an equation designed by a user in Excel, while a Function is a predefined calculation in the spreadsheet application. This guide will walk you through Formula vs Function in Excel so you know exactly what the similarities and differences are. Excel enables users to…
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…
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…
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…
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…
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…
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…
