Introduction Visual Basic for Applications with Excel 09-01-2019

Summary

Course:
Introduction Visual Basic for Applications with Excel
Language:
English
Start Date:
09-01-2019
Location:
CTG Belgium ( be )
Price:

day 1
09-01-2019

Google Maps

Upcoming

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

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.
2025
Trainings Done
3075
Happy People
19048
Hours of Training
4000
Cups of Coffee

Contact

Europe

CTG Belgium NV

Woluwelaan 140A
1831 DIEGEM
Belgium
phone: +32 2 720 51 70
fax: +32 2 725 09 20

North-America

Buffalo, New York

800 Delaware Ave

Buffalo, NY 14209-2094

phone: +1 716 882 8000

fax: +1 716 887 7464