Excel: Macro and VBA Training

Understanding macros and the 2 different ways to create a Macro. Learn how to record and run a Macro without the Visual Basic Editor (VBA) Learn how to modify a macro With VBA.

Target audience

Excel user who needs to automate repetitive tasks.

Objectives

After Excel: Macro and VBA, participants master the following:

  • Understand macros
  • The developer Tab
    Set up Excel to allow Macros
    Record and Run a Macro
  • What's VBA
    The VBA Editor
    Modify a Macro with VBA
    The Structure of a procedure
    Example of VBA Statements
    IF  Condition and LOOPs 
  • Practical Cases

Requirements

Windows, Excel basics and Excel advanced

Methodology

Excel Macro and VBA training is based on theoretical Excel manual, but main part of the training is dedicated to practical exercises with personalized assistance from the trainer.

Content

  • Understand macros
  • The developer Tab
    Set up Excel to allow Macros
    Record and Run a Macro
  • What's VBA
    The VBA Editor
    Modify a Macro with VBA
    The Structure of a procedure
    Example of VBA Statements
    IF  Condition and LOOPs 
  • Practical Cases

Diploma / Certificate

A certificate is awarded upon completion of training "Excel: Macro and VBA"

Print version

Format PDF

Duration and Price

Durée: 2 séances (8 périodes)
Prix: CHF 1200.-
(group price)

Questions ?

Contact us
Tél. +41 22 732 51 11
Lu-Ve 8h30 to 17h00

Contactez nous

Pour nous contacter, veuillez remplir le formulaire ci-dessous.

Loading map...

Formulaire de contact

Entrez votre nom.
Veuillez entrer une adresse email correcte.
Veuillez entrer votre numéro de téléphone
Veuillez entrer votre message.