Dear All,
This 1 Hour course shows how to create a Visual Basic coding using Microsoft Excel, During Training the following topics will be covered.
1. How to enable developer tool.
2. How to write a basic VBA Macro.
3. Record VBA Macro.
4. Basics of VBA debugger and execution.
5. Sections of VBA program.
6. How to add Library reference on the VBA Macro.
7. How to create a Link on the runtime excel using Macro designer.
8. How to save a Macro file.
9. Basic datatypes used.
10. Conditional branching statement.
11. Loop and its different types.
12. Dimentioning an array.
13. Difference between loop and the Function.
14. Revision of basic concepts of an High level language.
15. Basic of what is OOPS.
16. Dimension of External objects to VBA Excel Macro.
17. Basic concepts of How Arithmetic and Logical operations were used in the VBA Macro.
18. Example application to show how external text document was loaded on the Excel sheet using VBA Macro coding.
19. basic concepts of debugging the errors.
Certified
You have successfully registered
