Course Duration

16 hours, 2-day training workshop

Delivery

Face to face training or online training

Course Inclusive

Training materials & certificate of completion

Course Content

• Module I: Recording Macros
  1. Exploring Macro Security
  2. Recording and Running a Macro
     1. Using Relative Reference
  3. Assigning a Macro to an Image or Button


• Module II: VBA Programming
  1. Essential VBA Codes
  2. Using IF in VBA
  3. Creating Loops and Other Decision Structures
  4. Interactive Elements
  5. Other Object Programming


• Module III: Functions
  1. Designing Own Functions
  2. Writing Formulas in VBA
  3. Using Excel Functions in VBA
  4. VBA Functions


• Module IV:Userforms
  1. Designing Userforms
  2. Adding Operations on Userform 


• Module V: Creating Module
  1. Design Strategies
  2. Error Handling