Visual Basic for Applications (VBA) for Microsoft Excel Video

Visual Basic for Applications (VBA) for Microsoft Excel Video

Objectives:

1. Learn what needs to be in place before using VBA such as the Developer tab in Microsoft Excel.
2. Create a function in Visual Basic for Applications (VBA) in Microsoft Excel.
3. Create a loop in Visual Basic for Applications (VBA) in Microsoft Excel.
4. Leverage loops within loops (known as nested loops), in Visual Basic for Applications (VBA) in Microsoft Excel.
5. Leverage summary statistics in Visual Basic for Applications (VBA) in Microsoft Excel.
6. Learn how to write to multiple Microsoft Excel sheets using functions such as Sum, Variance, and Average.
7. Create macros in Visual Basic for Applications (VBA), which work across multiple Microsoft Excel sheets.
8. Export modules, ranges, and functions to be used across Microsoft Excel files.
9. Create a conditional statement in Visual Basic for Applications (VBA) for Microsoft Excel.
10. Create a user form in Visual Basic for Applications (VBA) for Microsoft Excel.

Instructor: Hassan Khan

Length: 3 hours

Access period: For one year starting from purchase date