Need some help ? Call us:+352 20 30 10 60
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:

Visio 2016/2019/365

In this course students will get acquainted with an overview of the features and functions of Microsoft Office Visio 2016.

MS Project 2016/2019 - Level 1

In this Introduction to Microsoft Project 2013/2016: Getting Started class, students will spend time getting comfortable with the Project 2013/2016 user interface, including project views and the ribbon. They will also learn to enter, organize, and link tasks, work with resources, create basic reports, and create projects independently. The course allows time to practice fundamental basic skills essential for efficient use of this
program.

Excel 2016/2019/365 - Level 1

Being able to create tables and manage the tables’ calculations, formatting and page layout. The new Office interface, Using the File tab (“Backstage”). Managing the Quick Access Toolbar. New tricks and techniques. One window per workbook...