No field has benefited more from the impact of Excel’s implementation in 1987 than the finance field. This post will cover three major finance formulas: FV (future value), PV (present value), and YIELD (yield for interest paying securities like bonds). FV The foundational conecpt in finance is that a dollar...

Often in Excel, you’ll want to combine the values of multiple cells into one cell. The fancy term for this is concatenation. There are two major ways to do this in Excel. The first of which is using the & operator to combine values together. Here’s a simple example using...

Basic logic is one of the most powerful features in Excel and allows you to do some neat tricks with simple formulas. The common IF statement allows for quick comparison and customizable output as a result. But, IF statements fall short when it comes to more complex logic, especially when...