VBA Training Courses

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

★★★★★
★★★★★

VBA Course Outlines

Title
Duration
Overview
Title
Duration
Overview
21 hours
Overview
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
Overview
Course is intended for those familiar the basics of VBA who want to develop their knowledge and greater use of language capabilities.
21 hours
Overview
The course is designed for users of Excel for creating analyzes and reports.
28 hours
Overview
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?

If you can answer YES to one of the questions then it's time stop this nightmare. This training is for you.

Find out how you can speed up your daily operations and get most out of MS Excel.

WARNING

After the training, your life will change dramatically. Activities, which occupied the whole day will take just a few moments. Are you ready for this?
21 hours
Overview
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.
21 hours
Overview
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
Overview
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
14 hours
Overview
The course reveals the secrets of effective writing advanced applications in VBA application MsExcel.

After the course you can:

- Write an advanced object-oriented application
- Convert text files
- Use of external data sources
- Use external libraries
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

Course Discounts

No course discounts for now.

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Australia!

As a Business Development Manager you will:

  • expand business in Australia
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!