Enquiry Form

VBA Training Courses

Local, 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 "onsite live training" or "remote live training". Onsite live VBA trainings in Denmark can be carried out locally on customer premises or in NobleProg corporate training centers. Remote live training is carried out by way of an interactive, remote desktop.

VBA training courses are available for beginners and advanced users.

NobleProg -- Your Local Training Provider

Testimonials

★★★★★

★★★★★

The trainer has demonstrated excellent training skills and communication with the group.
I was very pleased with the training - no suggestions.

Michał Szymankiewicz - NIIT Limited

Course: Visual Basic for Applications (VBA) in Excel - Advanced

I liked the examples and the way he explained.

Sandeep Parashar

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

Tamil 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.

It was really nice of 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.

I was benefit from the examples from different area of VBA programming.

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

I mostly was benefit from the fitted training to people needs.

Robert Solek - UBS Business Solutions Poland Sp. z o.o.

Course: Visual Basic for Applications (VBA) in Excel - Advanced

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

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

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

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 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 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

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

VBA Course Outlines

The course topics cover maximum automation. The student will learn how to use VBA effectively, how to use cell names to be copied, which are useful properties of objects only available in Excel VBA code and how to create your own control library. Finally, participants will learn how to create a complete application and how to secure it.

This course has been created for anyone who works with Excel and wants to automate most of their tasks.

The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions, debug programs and write complete applications using VBA forms.

This course can also be run in more depth, and with more practical examples, as a three day course.

It is an introduction to procedural programming in VBA. Training allows you to gain a strong foundation for further learning and VBA environment.

After the course you can:

- Record and edit the macro as required,- Write procedures using data from the sheet,- Create your own functions- Handle the event (opening worksheet cell update etc) by means of the handler,- Create form