Visual Basic for Application - Excel (VBA Excel)
Short Course by
Concept
Inquire Now
On-Site
/ Short Course
Details
Course Description
In this course, students will examine the Visual Basic for Applications Environment and created custom procedures to enhance the functionality of Excel.
Course Objective
At the end of this course, the participant will be able to:
In this course, students will examine the Visual Basic for Applications Environment and created custom procedures to enhance the functionality of Excel.
Course Objective
At the end of this course, the participant will be able to:
- Create recorded macros in Excel
- Use the macro recorder to create a variety of macros
- Understand the Excel object model and VBA concepts
- Work with the three main components of the VBA Editor window
- Create procedures in VBA
- Create and use variables
- Create and work with user-defined functions
- Write code to manipulate Excel objects
- Use a range of common programming techniques
- Create a custom form complete with controls
- Code to drive a user form
- Create procedures that start automatically
- Write a variety of error handling routines
Reviews
Be the first to write a review about this course.
Write a Review
Concept Computer Educational Development System Inc, “Concept” is an Information Technology (I.T.) Training company located in 12 Congressional Avenue, Quezon City. It was registered and approved by Philippines’ Securities Exchange Commission (SEC) as a Corporation under SEC Reg. No.:CS201420008.
Concept was established in 2014 by a former Informatics franchisee and its top management officers (upon 2012 Franchise expiry) who aim to provide highest quality and a needs-based I.T. Training for clients nationwide. Initially focused in I.T. training for students, teachers and professionals, we quickly diversified and continued I.T training and education to the corporate world.
Today, our diverse expertise and combined years of experience has provided us the skills and passion for I.T. education, training and development and pure commitment to service.
Concept was established in 2014 by a former Informatics franchisee and its top management officers (upon 2012 Franchise expiry) who aim to provide highest quality and a needs-based I.T. Training for clients nationwide. Initially focused in I.T. training for students, teachers and professionals, we quickly diversified and continued I.T training and education to the corporate world.
Today, our diverse expertise and combined years of experience has provided us the skills and passion for I.T. education, training and development and pure commitment to service.
Related Courses
GCSS, Inc.
Insights Training
JTR Services PH
JTR Services PH
