Count Words in Excel
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,…
Excel Solver
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…
Merge Cells in Excel
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…
Best Financial Modeling Books
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…
Excel Drop Down List
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…
Error Bars in Excel
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
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…
How to Create a Debt Schedule with PMT, IPMT and IF Formulas
Dynamic Financial Analysis
Dynamic Financial Analysis This guide will teach you how to perform dynamic financial analysis in Excel using advanced formulas and functions. INDEX, MATCH, and INDEX MATCH MATCH Functions 1. The INDEX function works similarly to the VLOOKUP function by returning a value in a table based on the intersection of a row and column position…
