MS Excel 2010 VBA

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


 
Student Community Apply online FAQ Course Calendar
  • Will be updated soon...

  • Will be updated soon...

  • Will be updated soon...

  • Will be updated soon...


+971 4 396 44 55