Need some help ? Call us:+32 2 503 40 40
Back

Programming with VBA Excel

In this hands-on course, you learn the fundamentals of programming and VBA from the ground up. You gain the skills you need to automate repetitive tasks, build user interfaces and increase performance in order to improve user productivity.

On this 3-day course, participants will learn how to

  • Develop customized solutions using Visual Basic for Applications (VBA)
  • Apply the object models to program effectively in the Microsoft Office System
  • Take full advantage of extensive built-in VBA functionality
  • Exploit ActiveX controls to create functional and familiar user interfaces
  • Retrieve data from PC and server databases
  • Troubleshoot code using VBA's debugging tools
  • Secure your code and protect your users from macro viruses
  • Use Visual Basic to control Excel, and to automate processes to speed up and simplify their work with Excel data.

Course benefits

They will also learn how to create interactive procedures using message boxes, and custom dialog boxes using Visual Basic controls. By the end of the course participants will have a good understanding of the Visual Basic language and the main elements of Excel that are referenced when using VBA.

This course is valuable for anyone who wants to automate tasks through VBA programming. Some experience using the products in the Microsoft Office System is assumed. No previous programming experience is required.

You might also be interested in:

Outlook 2016/2019 Productivity

The course teaches participants how to stop "living in their inbox" and start prioritizing tasks, messages, and appointments to achieve what's most important to the organization and themselves.

Word 2016/2019 - Level 1

Microsoft Word is a very powerful word processing application designed to save you time and make creating letters, CVs, reports and other documents easy. This is an introductory Microsoft Word training course that will provide you with a working understanding of the basic features of MS Word. Like being able to create and format documents.

Word 2016/2019 - Level 2

Microsoft Word is a very powerful word processing application designed to save you time and make easy work of creating forms, address labels, merging data into form letters and other tasks. This is an advanced Microsoft Word training course that will provide you with an understanding of the most advanced features of MS Word. Like creating and managing complex documents.