VBA Macro 2010

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
    • MAKATI
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines

    • Contact No.
    • +63 2 8891 0713
      +63 2 8751 6482

    • Email Address
    • inquiries@mapua.edu.ph

    • INTRAMUROS
    • 658 Muralla St., Intramuros, Manila 1002, Philippines

    • Contact No.
    • +63 2 8524-5572


    • Email Address
    • ccesc@mapua.edu.ph