VBA Macro 2010

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
    • +63 2 8891 0722
    • +63 2 8891 0713
    • +63 2 8751 6482
    • Intramuros
    • +63 2 8524-5572
    • Intramuros
    • 658 Muralla St., Intramuros, Manila 1002, Philippines


    • Makati
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines