Excel : VBA et Passage de la certification TOSA

How long does the training course last?

2,00 day(s)

In which language(s) is the training course taught?

EN FR

When will the next session take place?

Who is organising this training course?

Dawan is a training organisation that offers more than 2000 training courses in IT, management, project management and sales in instructor-led live online or on-site trainings. We have 11 centres in France and we have developed partnerships with local structures in Brussels, Luxembourg and Geneva. Our catalogue includes hundreds of topics: Java, PHP, Webmaster, E-Marketing, Linux, Windows Server, Vmware, Autocad, Photoshop, IA etc. Our courses have been created and designed by in-house trainers who have over 20 years of teaching experience. Constantly renewed, they are adapted to the requirements of our customers and to the evolution of technologies.

The content of this page is not available in English

Who is the training course aimed at?

Utilisateurs avancés d'Excel

What are the prerequisites?

Bonnes connaissances de Excel

What are the aims or the skills being targeted?

Introduction à VBA - Connaître les objets Excel.

What does the training course cover?

VBA

Objectifs du langage VBA
Présentation du VBA
Quelques définitions
Utilisation du VBA
Principe de fonctionnement d'une macro

Premiers pas avec VBA

Modifier le code d'une macro
Syntaxe du langage
Variables
Tableaux
Constantes
Opérateurs

VBA pour Excel

L'objet Application
L'objet Workbook
L'objet Worksheet
L'objet Range

Structures de contrôles et boucles

Principes de fonctionnement
Les structures de conditions (If, Select Case)
Les conditions multiples (And / Or)
Présentation des boucles
Boucler suivant un compteur (For Next)
Boucler suivant une condition (Do Loop)