CTG
CTG Academy

Introduction Visual Basic for Applications with Excel

In this introductory course, you will learn how to program Microsoft Excel using VBA macros. You will learn how VBA in combination with Microsoft Excel can help you take your Microsoft Excel capabilities to another level by automating routine tasks, managing large quantities of data…

Upcoming

Currently no (other) upcoming dates are planned for this course

course-details

Course Objectives

  • You will obtain a first insight in the possibilities of using Visual Basic for Applications as it applies to Microsoft Excel
  • You will learn to automate and extend excel by adding VA projects to your workbooks
  • You will learn how to respond to workbook, worksheet and application events to automate macro execution

Typical Audience

Anyone having experience with Microsoft Excel who wants to extend his or her capabilities.


People having a first experience with VBA in Microsoft Excel wanting to refresh their knowledge.


People who had a first experience with VBA in Microsoft Word, Access or Powerpoint who want to apply their knowledge in Microsoft Excel.

Course Prerequisites

Everyone is free to take the course, however basic knowledge of Microsoft Excel is advised.

Course Delivery

Throughout the course, an experienced trainer and software testing expert provides lectures and gives exercises based on real world projects.


Courses can be given in English, Dutch or French. Course material is in English.

Course Venue

The course duration is 1 day.
This course can be given at the client’s site or at CTG.

Course Outlines


  • Excel programming – an introduction
  • The VBA language
  • Procedures and Functions
  • Events
  • Error handling & debugging
  • Workbook & Worksheet Objects
  • Built-In Functions

Meet our trainers

CTG's trainers are experts in their domain and bring the course content based on their experience. Meet some of our trainers below.

26023
Trainings Done
4954
Happy People
192354
Hours of Training
32460
Cups of Coffee

Contact

Europe

CTG Belgium NV

Culliganlaan 1D
1831 DIEGEM
Belgium
phone: +32 2 720 51 70
fax: +32 2 725 09 20

North-America

Buffalo,New York
300 Corporate Parkway
Suite 214N
Amherst, NY 14226
phone: +1 716 882 8000
fax: +1 716 887 7464

Cookie Settings