1 : How VBA works with Excel

2 : Functions

• What is Function and Subroutine
• Writing Functions using VBA Editor
• Calling function in other workbook
• Relative & Absolute Macros

3 : Recording Macros

• Recording and running macro
• Storing macro in different books
• Creating buttons & assigning macros

4 : Working in The Visual Basic Editor

• Editing macros using VBA Editor
• Understanding the project explorer
• Exploring windows properties
• Modifying code & Debugging code

5 : Programming Fundamentals

• Variables, Data types & Constants
• Arrays ,Object , Variables
• Conditional structures (If Then,Select Case)
• Logical Operators / Looping constructs
• (For loops, Do loops, While)
• Built-in functions, Creating Subroutines

6 : Automatic Procedures and Events

7 : User Forms

• Creating forms, Form events
• Creating custom menus & toolbars
• Creating Add-ins