by Nate Moore | Mar 23, 2011 | Functions
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...
by Nate Moore | Mar 21, 2011 | 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,...
by Nate Moore | Mar 16, 2011 | Functions
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...
by Nate Moore | Mar 14, 2011 | Functions
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...