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 launches our discussion of Excel functions with five basic functions. Most Excel users will...

Excel Video 142 starts our discussion of financial functions in Excel with a function called PV. PV stands...

Excel Video 143 continues our discussion of financial functions in Excel. This time, I’ll introduce the...

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 wraps up our discussion of financial functions in Excel. There are many, many more financial...

Excel Video 146 introduces the IF function, a powerful tool to add versatility to your formulas. We’ll...

Excel Video 147 nests IF functions. By nesting, I mean we’ll put an IF function inside of another IF...

Excel Video 148 adds the AND function to our collection of logical tests in Excel. The AND function simply...

Excel Video 149 continues our discussion of logical functions by introducing OR. In Excel Video 148, all of...

When you’re done with Excel Video 150, you might be thinking that NOT is a lot like the devil, always...

Excel Video 151 explains how to use IFERROR to replace all of Excel’s error messages with something more...

Excel Video 152 describes two ways to concatenate functions in Excel. Even if concatenate didn’t have my...

Excel Video 153 might be EXACTly what you need to make your life easier. EXACT is a simple Excel function...

Excel Video 154 is short and easy. I’ll introduce two functions, FIND and LEN. FIND looks for a text...