Select Page

Excel Video 144 Text to Speech for April Fools

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...

Excel Video 143 PMT to Calculate Payments

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...

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...