Microsoft Excel VBA & Macro Training

Microsoft Excel VBA Training Course Microsoft® Excel VBA Training
By ComSystem Solutions
Microsoft Office Family:

Microsoft® Excel 2010: Task Automation with VBA Using Macro

“Discover the greater potential of Microsoft Excel...”

By ComSystem Solutions


PSMB Certified Training Provider • Comptia Authorized Delivery Partner • Pearson Vue Certified Test Centre • Registered with Ministry of Finance
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Email Customer Service [email protected]
[email protected]
Contact Customer Service +603-5162-8254 , +603-2201-4622
Course Title:
Microsoft® Excel 2010: Task Automation with VBA Using Macro
Training Category:
Information Technology
Target Audience:
Personnel who uses automation with excel.
Duration:
2 Days
Public Training Events
Jul 2017 ›
Venue:
ComSystem Solutions Training Centre, Wisma Goshen, Plaza Pantai, Kuala Lumpur, Malaysia
Schedule:
Mon 17 Jul 2017 - Tue 18 Jul 2017
9:00AM - 5:00PM

Fee Per Person:
RM950.00
Promotions:
  • Register before 07 Jul 2017 for only RM750 per person.
  • For 3 paxs registration, the 3rd person will receive a complimentary seat.
  • For 2 paxs registration, the 2nd person will be entitled to 20% discount.
Register Now!

* Other terms & conditions apply.
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact ComSystem Solutions
Contact customer service +603-5162-8254
+603-2201-4622
Email customer service [email protected]
[email protected]
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Workshop
  • Computer Lab Work
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

This 2-day Microsoft Excel VBA training shows you how to automate tasks by writing Macro. Learning to write Macros in VBA is a time-saving approach while on the other hand helping you to discover the greater potential of Microsoft Excel.

To request for in-house training, click on the Request for In-house Training link as displayed above for quotation. For a complete course cotent and more information about this course, feel free to contact the training provider as shown above. If the public program is available, you can request for a registration online by clicking on the Register for Public Training link. If the link is disabled, it simply means it has yet to be available for public. You can contact the training provider for further inquiry.

Course Objectives ›

Upon completion of this VBA course, you should be able to:

  • Create procedures to control the behaviour and appearance of an Excel spreadsheet,
  • Create procedures that run in response to specific events
  • Create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code

Course Outline ›

DAY 1

Recording a Macro

  • Recording a macro
  • Running a macro
  • Editing a macro

VBA terminology

  • Start the VBA editor
  • Work with:
    • Object properties
    • Methods
  • Attach code to events and buttons
  • Use the object browser
DAY 2

Programming basics

  • Variables and data types
  • Expressions
  • Manipulating data
  • Getting input from the user in Input and Message boxes
  • Variables and scope
  • Procedures
  • Calling one procedure from another

Using loops

  • Do / while
  • For / Next

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-5162-8254, +603-2201-4622
Email Customer Service E-mail : [email protected], [email protected]

Related Courses ›

More Other Training Courses ›

Published by: ,