by Nate Moore | Mar 30, 2011 | Functions
Excel Video 144 takes a quick break from functions to show you how to get Excel to read to you. There’s a text to speech feature in Excel that can come in handy when you’re trying to enter data from Excel into a different program on a second monitor. You may also find...
by Nate Moore | Mar 28, 2011 | Functions
Excel Video 143 continues our discussion of financial functions in Excel. This time, I’ll introduce the PMT function that will calculate the amount of a periodic (monthly, annual, etc.) payment due on a loan or a lease. The PMT function requires the same type of...
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...
