Course Duration

24 hours, 3-day training workshop

Delivery

Face to face training or online training

Course Inclusive

Training materials & certificate of completion

Description

If you have already have a strong background on Pivot, you are ready to take this course.

Course Content

• Module I: Macro Overview
  1. Macro and Security
  2. Macro
  3. Running Macro
  4. Assigning a Macro to an Image/Button
  5. Relative References


• Module II: Programming Basics
  1. The VBA Interface
  2. Essential VBA Codes and Programming Principles
  3. Declaring Variables
  4. Constants
  5. Creating Your Own Functions
  6. Editing VBA Codes


• Module III: Control Structures
  1. Decision Structures
  2. Loop Structures
  3. Essential VBA Codes + Control Structures


• Module IV: Userforms
  1. Creating Userforms
  2. Basic Userform Codes
  3. Events
  4. Sending Data from Userform to Excel (and Vice Versa)
  5. Other Userform Proramming


• Module V: Debugging and Error Handling
  1. Errors
  2. Debugging tools


• Module VI: Securing VBA Codes


• Module VII: More VBA Practice


• Module VIII: Advance Excel Exercises


• Module IX: Time for Participant’s