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 maler@comsystemsolutions.com
comsystem@comsystemsolutions.com
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
Nov 2019 ›
Venue:
ComSystem Solutions Training Centre, Wisma Goshen, Plaza Pantai, Kuala Lumpur, Malaysia
Schedule:
Wed 20 Nov 2019 - Thu 21 Nov 2019
9:00AM - 5:00PM

Fee Per Person:
RM1,000.00
Promotions:
  • Register before 10 Nov 2019 for only RM800 per person.
  • 20% Discount for the 2nd seat registration.
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 maler@comsystemsolutions.com
comsystem@comsystemsolutions.com
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 : maler@comsystemsolutions.com, comsystem@comsystemsolutions.com

Related Courses ›

Published by: ,
online learning icon Request for Online Training
Contact Us
Animated Progress Icon

Contact Assistant