Microsoft® Excel VBA Level 2 TrainingBy TED Integrated
Microsoft Excel Series:
Microsoft® Excel VBA Level 2: Developing Macro Applications
“Learn to develop practical Macro Applications with Microsoft Excel VBA!”
By TED Integrated
PSMB Certified Training Provider
 Request for In-house Training
|
Public program not yet
available
|
[email protected]
|
+603-2386-7788
|
Course Title:
Microsoft® Excel VBA Level 2: Developing Macro Applications
Training Category:
Information Technology
Target Audience:
Those who have completed Microsoft Excel VBA Fundamentals of Macro. Participants must possess good understanding on Excel object structure, looping and decision making statement, variable declaration and comfortable to work with Visual Basic Editor.
Duration:
2 Days
Microsoft® Excel VBA Level 2: Developing Macro Applications
Training Category:
Information Technology
Target Audience:
Those who have completed Microsoft Excel VBA Fundamentals of Macro. Participants must possess good understanding on Excel object structure, looping and decision making statement, variable declaration and comfortable to work with Visual Basic Editor.
Duration:
2 Days
Public Training Events
Apr 2017 ›
Venue:
TED Integrated, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 17 Apr 2017 - Tue 18 Apr 2017
9:00AM - 5:00PM
Fee Per Person:
RM1,400.00
Promotions:
* Other terms & conditions apply.
TED Integrated, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 17 Apr 2017 - Tue 18 Apr 2017
9:00AM - 5:00PM
Fee Per Person:
RM1,400.00
Promotions:
- 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!
* Other terms & conditions apply.
Aug 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 28 Aug 2017 - Tue 29 Aug 2017
9:00AM - 5:00PM
Fee Per Person:
RM1,500.00
Promotions:
* Other terms & conditions apply.
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 28 Aug 2017 - Tue 29 Aug 2017
9:00AM - 5:00PM
Fee Per Person:
RM1,500.00
Promotions:
- 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!
* Other terms & conditions apply.
Nov 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 27 Nov 2017 - Tue 28 Nov 2017
9:00AM - 5:00PM
Fee Per Person:
RM1,500.00
Promotions:
* Other terms & conditions apply.
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 27 Nov 2017 - Tue 28 Nov 2017
9:00AM - 5:00PM
Fee Per Person:
RM1,500.00
Promotions:
- 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!
* Other terms & conditions apply.
For In-house Training
|
|
Request for Quotation |
For Other Inquiries
Contact TED Integrated
|
|
+603-2386-7788 |
|
|
[email protected] |
Delivery Methods
- Language: English
- Computer Lab Work
- Case Studies
- Certificate of Participation
Ad by Google™
*Terms & Conditions
Course Introduction ›
This course touches on aspects of developing macros for practical applications. New and advanced tools have been included in this course. At the end of the day, two simple applications will be built using techniques covered in the Fundamental level.
Course Objectives ›
After completing this 2-day Macro VBA application development training, participants should be able to:
- Write advanced VBA Programming.
- Develop practical Macro applications.
- Learn new and advanced tools such as custom function, working with user forms, creating custom menus and building Add-Ins.
Prerequisites ›
Completion of Microsoft Excel VBA (Fundamentals of Macro). Participants must possess good understanding on Excel object structure, looping and decision making statement, variable declaration and comfortable to work with Visual Basic Editor.
Course Outline ›
DAY 1
Module 1: Building User Interactive Applications
- Introduction
- Message Box
- Input Box
- The Excel Inputbox Method
Module 2: More VBA Programming Fundamentals
- With...End Statement
- GoTo Statement
- Select Case Statement
- Using Arrays
- Creating Multi-Dimensional Array
Module 3: Creating Custom Functions
- Introduction
- Function examples
- Categorising & Adding Function Description
Module 4: Working with User Forms
- Introduction
- Inserting a New Userform
- Adding controls to a Userform
- Setting A Control's properties
- Creating a Userform: An Example
- Adding More Controls to the Toolbox
DAY 2
Module 5: Creating Custom Menus
- Userform "Menu"
- Tool Bar "Menu"
- Command Bar Menu
- Creating A Short Cut Key
- Adding & Deleting Menu Automatically
Module 6: Building Add-Ins
- What Is An Add-In?
- Creating An Add-In
Module 7: Exercises
- Loan Calculator Application
- Data Entry Application
Contact us now ›
|
|
|
Call : +603-2386-7788
|
|
E-mail : [email protected]
|
Related Courses ›
- Microsoft® Excel VBA for Non-Programmers
- Introduction to PowerPivot 2010
- Maximizing Microsoft® Excel Tools for Fast & Accurate Business Reporting
- Introduction to Power Business Intelligence with Excel 2010
- Microsoft® Excel for Intermediate/Advance User
- More other Information Technology related courses
