What are Investment-Grade Bonds? An investment-grade bond is a bond classification used to denote bonds that carry a relatively low credit risk compared to other bonds. There are three major credit rating agencies (Standard & Poor’s, Moody’s, and Fitch) that provide ratings on bond. Each credit rating agency sets a minimum bond rank to be…
How to Alphabetize in Excel? This guide will show you how to alphabetize in Excel using the Sort and Filter functions to organize your data from A to Z. This feature is particularly useful for large datasets where it would take a very long time to alphabetize information in Excel manually. Before you go on…
How to Count Words in Excel The guide below will teach you how to count words in Excel with step-by-step instructions and screenshots. If you’re a fan of the word counting function in MS Word, you will, unfortunately, be disappointed to know that standard Excel Functions do not have the same feature. There is, however,…
What is Excel Solver? Excel Solver is an optimization tool that can be used to determine how the desired outcome can be achieved by changing the assumptions in a model. It is a type of what-if analysis and is particularly useful when trying to determine the “best” outcome, given a set of more than two…
Why Merge Cells in Excel? The most common reason to merge cells is for formatting and centering headings. This guide will show you how to merge cells in Excel, even though it is highly recommended that you don’t merge them unless you absolutely need to. As an alternative, we recommend using the Center Across Selection…
What are the Best Financial Modeling Books? The best way to learn financial modeling is through practice. But how can you practice if you don’t know where to start? Many people start with video-based training (which we offer extensively), while others still prefer good old-fashioned books. For anyone who prefers to learn by reading and…
What is an Excel Drop Down List? An Excel drop down list is a data validation function that allows users to select an option from a list of choices. It can be particularly useful in performing financial modeling and analysis by incorporating scenarios and making a spreadsheet more dynamic. Learn to build dropdowns into models…
What are Error Bars in Excel? Error bars in Excel are graphical representations of data variability. They show the precision of a measurement. The bars usually represent standard deviation and standard error. They indicate how far from the determined value the true value is. Error bars on charts provide a more comprehensive view of the…
VBA If Else statements Building a VBA If Else statement is quite similar to building a nested if formula inside Excel. The benefit of using VBA instead is that it’s much easier to follow, since nested IFs tend to complicate with multiple parenthesis enclosures. In a VBA if statement, each IF clause is separate from…
