This course will help you see how some of your time-consuming daily task in Excel can be automated using a tool named - Visual Basic for Application (VBA).
This course will help you discover the wonder of Excel Visual Basic for Applications from recording macros to advanced automation technique.
At the end of the training, the participants will able to:
• Understand the fundamentals of Excel VBA
• Understand the Visual Basic Editor environment.
• Understand and use basic Excel Objects
• Understand variables concept
You must be a Microsoft Excel user on a day-to-day basis to take full advantage of Excel VBA.
Note: You may not know any programming language, and that is completely ok.
Module #1: Introduction to macro/Visual Basic for Application (VBA)
Developing wonders in a whole new world.
Understand and using new command
It’s simple, just record it
Understand what you have recorded
Module #2: Understand the new VBA Environment
The Visual Basic Editor
The 4 Windows
Learn to comment fast
Module #3: Save your hard work
Save your macro.
Module #4: Accessing Excel Cell’s Value
Navigate within a worksheet
How to access a particular cell
Selecting entire current range
Module #5: Object
What is Object?
What is OOP?
Module #6: Variable Concept
What is variable?
How to use a variable
The different type of variables
Declare a Constant
Module #7: Working with Text
Essential task: Joining words
Finding the length of a text
Getting part of a text
See how fast VBA turns all selected text to uppercase or lowercase
Module #8: Examples & Demos
Highly useful VBA Examples
Easy to follow VBA exercises
Demo related to converting PDF
Demo related to currency
WHY LEARN WITH CREATIVEWISE SDN BHD?
-Small class size. Only 4 pax, Before you decide, just ask other training providers, how many students per class?
-PSMB Approved Training Provider. We deliver only the excellent Excel training you want.
-Highly creative and experienced. We are the expert in applying various Excel functions and feature. We have trained more than 200 corporate clients including batches of finance staffs for Bank Negara Malaysia, TESCO, Maybank and etc.
-Ongoing learning. You can further deepen your Excel skill and understand by purchase videos tutorial after the training session. It’s great and excellent tool for you to revise what you learned and help you enhance your skill to next level, all this - on your own pace.**
-Carefully designed course material and exercise. Easy to understand and practical example for various job functions.
-Excel Peak Performance Coaching. We are committed 100% to your success in applying Excel to master level within 3 - 5 months or less through one to one coaching.**
Is my registration/ticket transferrable?
Do I have to bring my printed ticket to the event?
No, just show us your ticket on your mobile phone will do. Let us go green.
What is the refund policy?
The name on the registration/ticket doesn't match the attendee. Is that okay?
It is OK. As long as you can explain logically.
Will a certificate be given?
Yes, E-certificate will be issued upon completion of the program, you will receive it 1 day after the training.
For practical Excel tips, please visit us here:
Please sign up today. Limited seats (4 seats only for each batch)
When & Where
3, Jalan Puteri 5/20
3 Jalan Puteri 5/20
Creativewise Sdn Bhd
Creativewise Sdn Bhd (formerly UGROW IT Solutions)
- 15 yrs experience in IT industry
- 8 yrs corporate training experiences
We provide all level of Microsoft Excel training for senior management and executive. We has successfully trained LB Aluminium Berhad, Nokia Siemen Network, ThaiExpress Sdn Bhd, SGS Malaysia Sdn Bhd, DataStream Solution (Brunei) Sdn Bhd, 3ntity Berhad, SGS Labuan (Group of Oil & Gas Chemists), AVNET Malaysia Sdn Bhd, SOMFY Sdn Bhd, KTC , New Horizons Malaysia, Nota Asia, Tunku Abdul Rahman College, Kawan Food Berhad, Merge Energy Berhad, PUMA, Syngenta, Ntritex Sdn Bhd and etc
"Kent has helped my staff to reduce data analysis time in calculating staff overtime." ~ LB Aluminium Berhad