Excel: Macros and VBA Programming
Price:
$9.00
Description:
<p id="isPasted">It’s fairly universal that anything that can make work quicker and easier is considered a good thing. Macros and VBA (visual basic for applications) let you automate tasks in Excel to save your time and effort. This is especially helpful when you’re working with large amounts of data. </p><p><br></p><p>This course will show you how to use macros and VBA in Excel to perform functions and automate tasks. It’ll focus on how to get started with them, how to automate basic tasks, analyze data, and create models. Each video will cover a specific function you can perform, 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>• Recording macros in Excel </p><p>• Editing macros in VBA </p><p>• Writing simple VBA code </p><p>• Looping constructs </p><p>• Conditional statements </p><p>• Error handling </p><p>• User-defined functions </p><p>• Interacting with Excel objects </p><p>• Debugging and testing macros </p><p><br></p><p><strong>Why take this course? </strong></p><p><br></p><p>Most people can benefit from being able to automate tasks and quickly perform functions when working with large amounts of data. This course is ideal for anyone who’s familiar with Excel and wants to use it at a more advanced level to perform certain functions. To get the best out of this course, you’ll need access to a computer and Microsoft Excel. </p><p><br></p><p>45 mins | SCORM |<strong id="isPasted"> </strong>Transcript</p>