Excel: Advanced Formulas and Functions (Part 2)
Price:
$4.00
Description:
<p id="isPasted">There’s a lot that Excel can do, but it’s not all about clicking buttons. There are hundreds of formulas and functions you can use. But knowing the correct formatting of these is crucial to making them work. And the more you know, the more you can get out of your data and Excel. </p><p><br></p><p>This course will show you some advanced formulas and functions that you can use in Excel, so you can more easily manipulate your data. It’ll focus on lookups, text strings, and numerical manipulations. Each video will cover a specific formula or function, so you can choose exactly what you want to learn, at a pace that suits you. </p><p><br></p><p><strong>This course contains useful information on: </strong></p><p><br></p><p>• Lookups: LOOKUP and XLOOKUP </p><p>• Lookups: VLOOKUP and HLOOKUP </p><p>• LEN and LENB functions </p><p>• Max and Min Offsets </p><p>• Substitute and Replace functions </p><p>• Index and Match functions </p><p>•<strong> </strong>Text functions including the Left, Right, Mid, Upper, Lower, and Proper functions </p><p><br></p><p><strong>Why take this course? </strong></p><p><br></p><p>There are lots of formulas and functions in Excel, and the more you know, the quicker and easier it is to work with your data. This course is perfect for anyone who knows Excel and wants to use it to work with and understand their data more quickly and easily. To get the best out of this course, you’ll need access to a computer and Microsoft Excel.</p><p><br></p><p>20 mins | SCORM |<strong id="isPasted"> </strong>Transcript</p>