MS Excel: Macro Recording and VBA Programming - 2 Days by Insights Training - SpeedyCourse Philippines
We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

MS Excel: Macro Recording and VBA Programming - 2 Days

ENDED
Inquire Now
In-Person / Training
Ended last Oct 06, 2018
PHP  3,199.00 (VAT inclusive)

Details

This is a 2-day Training:
Sept 20-21, 2018 (CEBU - 10AM-5PM)
Sept 29 and Oct 6 (QC, 9AM-4PM)

Knowledge of Macros and VBA Programming allows you to automate reports in MS Excel. Generate reports in one click, create tools that will eliminate the manual tasks in your workplace. Know how to record macros, and create modules with Logical, Loop, and Userform structures!

The course requires just at least a basic understanding of MS Excel in order to be appreciated.

Email: [email protected]

SMS: 0977.103.1800

Facebook: www.facebook.com/InsightsManila

IMPORTANT DETAILS:

  • Certificates will be provided.
  • Handouts and workfiles included.
  • Bring your own laptop. Practice files will be emailed before the training. (You can ask us about our laptop rental service if you cannot bring a laptop.)
  • Coffee, PM snacks, and candies included.
  • Lunch included.
  • Tax included.

Outline

  • Topics:

    1. Macros

    • Recording Macros
    • Assigning Macros to Objects
    • Relative References
    • Making Macros Permanent

    2. Introduction to Visual Basic for Applications

    • The Visual Basic Editor
    • Essential Codes: ACTIVECELL, SELECTION, MSGBOX, RANGE, SHEETS
    • Essential Actions: ACTIVATE, CLEAR, VALUE, COPY, PASTE, INSERT, DELETE

    3. Decision Structures

    • IF
    • ELSEIF
    • AND and OR
    • Resolving Case Sensitivity of Codes
    • Using IF Structures in  resolving different scenarios

    4. Loop Structures

    • Creating Conditional Stops with DO UNTIL
    • Creating Absolute Loops  with FOR NEXT
    • Looping Objects with FOR EACH NEXT
    • Combining Loop Structures

    5. Userforms

    • Creating basic userforms
    • Automating userform actions
    • UNLOAD, TEXTBOX, CHECKBOX, USERFORM SHOW

    6. Functions

    • Using VBA Functions
    • Using Excel Functions in VBA
    • Creating Your Own Functions with VBA

    7. Error Handling

Reviews
Be the first to write a review about this course.
Write a Review
Sending Message
Please wait...
× × We have updated our Privacy Policy. Please click here to learn more. This site also uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.