Select Page

Excel Video 142 PV Present Value

Excel Video 142 starts our discussion of financial functions in Excel with a function called PV. PV stands for present value, the total amount that a series of future payments is worth today. The financial functions I’m discussing in these videos are the subject of an...

Excel Video 141 Basic Excel Functions

Excel Video 141 launches our discussion of Excel functions with five basic functions. Most Excel users will be familiar with SUM, COUNT, MIN, MAX, and AVERAGE. I’ll walk through a brief example using those 5 functions. Even if you’re familiar with those functions,...

Excel Video 140 Insert Function Window

Excel Video 140 helps you use the Insert Function Window to use an Excel function. The Insert Function Window is a great way to find new or recently used functions. Once you find the function you need, the window will help you enter the right data in the right order...

Excel Video 139 The Formulas Tab

Excel Video 139 provides an overview of the Formulas tab in Excel 2010. For the next set of Excel Videos, we’ll cover a wide variety of functions that will do everything from statistics to finances to telling you what time it is. I won’t go through every single...