Excel VBA Course Duration: This is a 3 full day Excel 2007 / 2010 VBA Course. Course starts at 09:00 and runs until 17:00, with a one hour break for lunch, and two short snack breaks.
Miminum Requirements: You must have good Excel skills and understand key concepts of spreadsheets, or equivalent. It is not necessary to have programming knowledge.
Intended Audience: This course is aimed at experienced Excel users who wish to automate repetitive tasks or simplify more complex tasks using Excel macros and Visual Basic for Applications (VBA) programming language.
After attending the VBA Excel Tutorial, you will be able to:
- Record and Run Macros
- Write VBA Code Manually
- Perform Loops, Controls and Error Handling
- Create User forms and Sheet Controls in Excel
- Use Events to trigger specific VBA code
Detailed Outline for 3 Day VBA Excel Tutorial
Lesson 1:
Lesson2:
Lesson3:
Lesson 4:
Lesson 5:
|
Lesson6:
Lesson 7:
Lesson 8:
Lesson 9:
Lesson 10:
Lesson 11:
|
After attending the VBA Excel Tutorial, you will be able to:
- Record and Run Macros
- Write VBA Code Manually
- Perform Loops, Controls and Error Handling
- Create User forms and Sheet Controls in Excel
- Use Events to trigger specific VBA code
Detailed Outline for 3 Day VBA Excel Tutorial
Lesson 1:
Lesson2:
Lesson3:
Lesson 4:
Lesson 5:
|
Lesson6:
Lesson 7:
Lesson 8:
Lesson 9:
Lesson 10:
Lesson 11:
|
Intended Audience: This course is aimed at experienced Excel users who wish to automate repetitive tasks or simplify more complex tasks using Excel macros and Visual Basic for Applications (VBA) programming language.
Claim SDF Grant
Companies sponsoring their staff for training can Claim SDF Funding, subject to SSG Eligibility Criteria.
Applicable for Company Sponsored Singaporeans & PRs.
Learn By Doing
You learn best when you Do It Yourself.
We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!
SkillsFuture Ready
Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.
Contact us for advise on how to go about claiming your SkillsFuture.
Get Started Today!
How To Register
This course is scheduled to run at our VBA Training center at Fortune Centre in Singapore. View our Training Calendar for available dates.
Simply Register Online, and book your seat today. Or send an online enquiry if you have any questions. You can call us at +65 6250-3575.
SDF funding is available to ALL companies registered in Singapore. The funding is NOT AVAILABLE TO INDIVIDUALS – only to Company Sponsored Singaporeans/PRs.
Custom In-House / Corporate Training
The course can also be run on specific dates that suits you.
Call us at Corporate Training Hotline at +65 6250-3575 if you have a group of 5 or more participants.
You can email to training@intellisoft.com.sg for Corporate Training Rates.