MODULE 1: UNDERSTANDING SECURITY LEVELS

• Why security
• Security levels and their meaning

MODULE 2: FUNCTIONS

• What is a Function and a Subroutine
• Writing Functions using VBA Editor
• Calling a function in another workbook

MODULE 3: RECORDING MACROS

• Recording and running macro
• Storing macros in different books
• Creating buttons and assigning a macro to it
• Creating My Menu

MODULE 4: THE VISUAL BASIC EDITOR

• Editing macros using VBA Editor
• Understanding the project explorer
• Exploring Windows properties
• Modifying code in the code window
• Debugging code

MODULE 5: PROGRAMMING FUNDAMENTALS

• Variables, data types and constants
• Arrays
• Object Variables
• Conditional structures (If I. Then, Select Case)
• Logical Operators
• Looping constructs (For loops, Do loops, while Wend)
• Built-in functions, Creating Subroutines

MODULE 6: EXCEL OBJECT MODEL

• Working with object properties, events and methods
• Application objects
• Workbook objects, Worksheet objects and Range objects
• Charts objects
• Pivot table objects

MODULE 7: USER FORMS

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

Module 8: Working with other applications

• Working Word, PowerPoint and other applications.