Online or onsite, instructor-led live VBA training courses demonstrate through interactive discussion and hands-on practice how to use VBA in applications such as Word, Excel and Access.
VBA training is available as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. Onsite live VBA training can be carried out locally on customer premises in Macao or in NobleProg corporate training centers in Macao.
VBA training courses are available for beginners and advanced users.
NobleProg -- Your Local Training Provider
Testimonials
The instructor's method of writing the code and finding solutions provided a good example of how to approach things in VB. Recording a macro to access its code, intentionally leaving some items incorrect to show how that impacted the result, etc. Finding errors and solutions in code can be difficult but his training approach showed his VB problem solving methodology
Manson Construction Co.
Course: Excel VBA Introduction
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie Longridge - Environment, Marine and Fisheries
Course: Excel VBA Introduction
practical application using my data and how I can use VBA to process and produce my reports
Environment, Marine and Fisheries
Course: Excel VBA Introduction
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Course: Access VBA
A lot of exercise. Trainer doesn't need to have support for his course. He has a really great knowledge for his subject.
Quentin Demeyere
Course: Visual Basic for Applications (VBA) in Excel - Introduction to programming
It was really nice from the trainer that he took a lot of time to answer our questions and helped us improve or gave us hints on how to improve some macros we were already using without fully understanding the code.
David Trieu - CD Projekt SA
Course: Visual Basic for Applications (VBA) in Excel - Introduction to programming
short excersises
Mateusz Podsiadlo
Course: Visual Basic for Applications (VBA) in Excel - Introduction to programming
Training agenda was well thought out
Przemek Zalasinski
Course: Visual Basic for Applications (VBA) in Excel - Introduction to programming
I like the hands on training and seeing us solve for issues on the spot.
Jon Matrille - LocumTenens.com
Course: Visual Basic for Applications (VBA) in Excel - Advanced
well structured.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
I really enjoy the training. Huge and practical! knowledge of the trainer combined with his skill to conduct the training made the training time very efficient. The trainer recognized the level of participant's experience in VBA and provided exercises relevant to that experience which made the training very useful.
Barbara Peek - UBS Business Solutions Poland Sp. z o.o.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
I was benefit from the trainer knowledge, explanation and tips.
Kornel Tymcio - UBS Business Solutions Poland Sp. z o.o.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
I liked the trainer, nice guy with great attitude.
Lukasz Kanior - UBS Business Solutions Poland Sp. z o.o.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
I generally enjoyed the knowledge and sense of humor.
Łukasz Rózga - UBS Business Solutions Poland Sp. z o.o.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
Fitted training to peoples needs
Robert Solek - UBS Business Solutions Poland Sp. z o.o.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
The whole topic is interesting - everything was ok.
Bartosz Wierzewski - UBS B
Course: Visual Basic for Applications (VBA) in Excel - Advanced
Examples from different area of VBA programing.
UBS Business Solutions Poland Sp. z o.o.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
The instructors knowlege
US Bank
Course: Visual Basic for Applications (VBA) in Excel - Advanced
Content and the way it was provided.
Marcin Samborski
Course: Visual Basic for Applications (VBA) in Excel - Advanced
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.
Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.
Course: Visual Basic for Applications (VBA) in Excel (intermediate level)
The trainer had in depth knowledge of the course presented.
BMW
Course: Visual Basic for Applications (VBA) for Analysts
The specialist knowledge was amazing! The way that you took that and broke it up, so we could understand was awesome. I think i just have to start with the simple stuff. the Last Subject was a bit high level and I struggled to keep up but will get there :)
Zaskia Stanz - BMW
Course: Visual Basic for Applications (VBA) for Analysts
Detailed examples & training material.
KAREN LOUW - BMW
Course: Visual Basic for Applications (VBA) for Analysts
He was prepared and also give good pointers
Annemarie Van Aardt - BMW
Course: Visual Basic for Applications (VBA) for Analysts
No certain (VBA Environment and Macros). Otherwise, too much information for a Beginner without basic knowledge Coding/Programming
BMW
Course: Visual Basic for Applications (VBA) for Analysts
The content is useful and the trainer gave us information on what to do in the future if we encounter problems and questions
International Trading Fashion & Apparel Supply Limited
Course: Visual Basic for Applications (VBA) for Analysts
Kamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.
Christine Weiler
Course: VBA For Access & Excel
The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions
Daria Rudin
Course: VBA For Access & Excel
examples and the way he explained
Sandeep Parashar
Course: VBA For Access & Excel
well structured.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
VBA Course Outlines in Macao
Course Name
Duration
Overview
Course Name
Duration
Overview
14 hours
This instructor-led, live training in Macao (online or onsite) is aimed at data analysts who wish to use advanced VBA in Excel for automating tasks.
By the end of this training, participants will be able to:
- Write an advanced object-oriented application
- Convert text files
- Use of external data sources
- Use external libraries
21 hours
This instructor-led, live training in Macao (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks.
By the end of this training, participants will be able to:
- Record and edit macros as required.
- Write procedures using data from the sheet.
- Create your own functions.
- Handle an event (opening worksheet cell update etc.) by means of the handler.
- Create a form.
14 hours
This instructor-led, live training in Macao (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks.
By the end of this training, participants will be able to:
- Record and edit macros as required.
- Write procedures using data from the sheet.
- Create your own functions.
- Handle an event (opening worksheet cell update etc.) by means of the handler.
- Create a form.
21 hours
The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel.
21 hours
Participants will be able to excel themselves, in the most optimal way to create, consolidate and manage data. A number of tools designed to streamline the work often significantly reduces the time to activities carried out so far and can help you design an application that could perform new tasks.
14 hours
Course is intended for those familiar the basics of VBA who want to develop their knowledge and greater use of language capabilities.
21 hours
The course is designed for users of Excel for creating analyzes and reports.
28 hours
Please answer the following questions:
- Is your daily work in Excel is a never-ending string of commands copy-paste?
- Are you wasting time on repetition of similar operations to prepare the data for analysis?
- Do you know all the keyboard shortcuts in Excel, but you are not satisfied with the results?
- Rather than deal with data analysis and preparation of wasting time?
- Do you have to manually verify the correctness of such data obtained from different systems?
- Do you have to stay at work after hours or Excel to take books home because not doing during the day?
- Is Your job is to prepare reports based on a large data set?
- Do you feel that working in Excel, you come to a roundabout way of results?
Last Updated:
Other regions in Macao
Other countries
Online VBA courses, Weekend VBA courses, Evening VBA training, VBA boot camp, VBA instructor-led, Weekend VBA training, Evening VBA courses, VBA coaching, VBA instructor, VBA trainer, VBA training courses, VBA classes, VBA on-site, VBA private courses, VBA one on one training
