Functions Basics Playlist
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,...
Excel Video 140 Insert Function Window
Excel Video 140 helps you use the Insert Function Window to use an Excel function. The Insert Function...
Excel Video 141 Basic Excel Functions
Excel Video 141 launches our discussion of Excel functions with five basic functions. Most Excel users will...
Excel Video 142 PV Present Value
Excel Video 142 starts our discussion of financial functions in Excel with a function called PV. PV stands...
Excel Video 143 PMT to Calculate Payments
Excel Video 143 continues our discussion of financial functions in Excel. This time, I’ll introduce the...
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...
Excel Video 145 Rate and Future Value
Excel Video 145 wraps up our discussion of financial functions in Excel. There are many, many more financial...
Excel Video 146 IF
Excel Video 146 introduces the IF function, a powerful tool to add versatility to your formulas. We’ll...
Excel Video 147 Nesting IF Functions
Excel Video 147 nests IF functions. By nesting, I mean we’ll put an IF function inside of another IF...
Excel Video 148 AND
Excel Video 148 adds the AND function to our collection of logical tests in Excel. The AND function simply...
Excel Video 149 OR
Excel Video 149 continues our discussion of logical functions by introducing OR. In Excel Video 148, all of...
Excel Video 150 NOT
When you’re done with Excel Video 150, you might be thinking that NOT is a lot like the devil, always...
Excel Video 151 Using IFERROR to Trap Errors
Excel Video 151 explains how to use IFERROR to replace all of Excel’s error messages with something more...
Excel Video 152 CONCATENATE
Excel Video 152 describes two ways to concatenate functions in Excel. Even if concatenate didn’t have my...
Excel Video 153 EXACT
Excel Video 153 might be EXACTly what you need to make your life easier. EXACT is a simple Excel function...
Excel Video 154 FIND and LEN
Excel Video 154 is short and easy. I’ll introduce two functions, FIND and LEN. FIND looks for a text...
