Course Details

Modular course on MS Excel VBA is available here. Teachers here have very high level of proficiency in tutoring. They are highly dedicated professionals, always present here for the overal guidance of the students, in respect of the course. Meticulously designed notes are provided to each of the students, for after-class study purpose.

Contents :

Module 1: Overview of Macro & Recording

• Recording & Running Macros
• Creating Button & toolbar to run the macros
• Creatingdynamic Macro
• Using Relative Reference in Macro

Module 2: Macro Editor

• Overview of Excel VBA Editor
• Adding & Deleting Modules
• Sub & End Sub

Module 3: Securing Macro code & working with ranges

• Macro Security
• Working with worksheet &workbook codes
• Understanding Range coding
• Declaring Variables

Module 4: Logical conditions in Macro

• IF Conditions
• IF with Else IF

Module 5: Looping

• Understanding Loop
• Using Loop practically

Module 6: Debug & Comment Macro codes

• Debugging Code & Break Points in Macros
• Commenting Codes

Module 7: Using Message Box

• Creating Message Box for User interaction
• Using different types of Message boxes

Module 8: Projects

• Formatting
• Auto Filtering & Separating Data
• Consolidating Multiple Sheet into One