Skip Main Navigation
Page Content

Save This Event

Event Saved

MICROSOFT EXCEL MACRO/VBA COURSE

Creativewise Sdn Bhd

MICROSOFT EXCEL MACRO/VBA COURSE
Available Dates

Ticket Information

Ticket Type Sales End Price Fee Quantity
Normal 1 hour before event starts RM1,380.00 RM34.50
Early Bird   more info 1 hour before event starts RM698.00 RM0.00

Share MICROSOFT EXCEL MACRO/VBA COURSE

Event Details


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.


Learning outcome:

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

Prerequisite:
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
And more..

Module #2: Understand the new VBA Environment
The Visual Basic Editor
The 4 Windows
Running Macros
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
Exercise

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
Demo:
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.**

 

FAQs
Is my registration/ticket transferrable?
Yes.

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?
No refund.

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:
http://www.ugrowit.net


Please sign up today. Limited seats (4 seats only for each batch)


Have questions about MICROSOFT EXCEL MACRO/VBA COURSE? Contact Creativewise Sdn Bhd

Save This Event

Event Saved

When & Where


3, Jalan Puteri 5/20
3 Jalan Puteri 5/20
Puchong, Selangor 47100
Malaysia

Organizer

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

  Contact the Organizer
MICROSOFT EXCEL MACRO/VBA COURSE
Things to do in Puchong Class Business

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.