cours-website

VBA Course | Continuing Education | Montreal, Quebec, Gatineau

Classes in: Classes in : Montreal, Blainville, Saint-Jerome, Quebec, Sherbrooke

Visual Basic for Applications (VBA) is the built-in language in all Microsoft Office applications,
VBA that will allow you to extend the functionality of Excel.

This VBA Excel training is for Excel users or developers who want to create spreadsheet applications. At the end of this course, participants will have a mastery of Visual Basic for Application (VBA) basics and will be able to create VBA applications for Excel.

Course details

image_pdfimage_print

Macros

Basic principles
Programming methodology
Automatic macros

 

The basics of programming

Publisher VBE
Variables, constants
Conditional instructions
Loops for next
Loop loops
While wend
Links between macros
Workshop: Realization of a first project

 

VBA Excel Object

The Excel object model
Objects and collections of objects
Application Object

 

The forms

Create a form
customize a form
Events of form objects
Executing / closing a form
Custom forms
Validate programmatically with basic VBA commands

 

Create custom functions

the creation of functions.
The notion of arguments
Create, save a custom function
Use a custom function

 

Manage the procedures properly

Create a private procedure
Call a procedure with or without arguments
Make optional arguments
Use ByRef and ByVal

 

The basics of object programming

Define the notions of class and object
Composed variables
Module and class module
Class creation in programming
Define the notions of private and public

 

Advanced object programming concepts

Create custom classes
Parameterized class method
Discover class functions
Add events to our objects
Create objects
Use collections
Understand the relationship between classes


Benefits:

  • A course material for each participant
  • Support of the trainer after the training
  • We offer you in public session:
    • Tea, coffee
    • Dinner at a nearby restaurant
    • Parking (only in some cities)
    • Wireless internet connection

Objectifs :

Automate data processing in Excel with macros Know Visual Basic for Application Acquire advanced notions in procedural programming Discover VBA Object Oriented Programming

Nos formations se font présentement en classe virtuelle(à distance), nous proposerons des formations en classe physique seulement si la situation sanitaire le permettra

Montréal (en ligne) :

Québec (en ligne) :

Gatineau / Ottawa (en ligne) :

Classes in : Montreal, Blainville, Saint-Jerome, Quebec, Sherbrooke
Preferential*

1021 $

per participant

Duration : 3 day(s), is 21 hours.
Hours: 9 am-5pm, 2 coffee breaks, dinner offered at 12 noon.

See the lesson plan in PDF

Locations: Montreal, Gatineau / Ottawa, Quebec City.

See customer reviews

Regular price: 1202 $

*The preferential rate applies if you register at least two participants in the same session.

details_cours

Interested in this training?

Also available in private session.
offer is valid from 01/01/2020.

Get some information

Receive this training in your company

Company training

Free and non-binding quote

Mark Plouffe, Gouvernement du Canada/ Government of Canada

“ I want to thank you both for providing my resources some excellent training(Cobol) over the past 3 days. Mamadou, thank you for being so accommodating on such short notice and for sending your facilitator to Gatineau for this customised and personalised training course. We’ll look forward to continuing our partnership for future training needs. “

Maryse Duguay - Analyste fonctionnelle Base de donnée - Montréal

“J’ai grandement apprécié les méthodes d’enseignement du prof. Le fait que nous soyons un petit groupe a grandement facilité les apprentissages. Il s’adapte à son audience et les exercices sont formateurs. Je recommande fortement. “

Martin Côté - Analyste Assurance Qualité - Travailleur autonome – Montréal

“ Ce fut un plaisir de faire affaires avec Doussou Formation. Ce qui fait LA différence est le service personnalisé totalement à l'écoute des participants ainsi que l'adaptation aux besoins de formation. Flexibilité/Adaptabilité/Professionnalisme/Courtoisie. Merci!“