Training: Excel – VBA Fundamentals

Ref. MOE-41
Not certifying


This course is ideal as an introduction to VBA programming for Excel. It will allow participants to automate their tasks, from simple recorded macros, to creating procedures and managing variables.

Participant profiles

  • Office experts who need to automate tasks and enrich the catalog of functions in Excel


  • Create a macro and edit it
  • Work in the Visual Basic editor
  • Work with variables
  • Create custom functions


  • Expert knowledge of Excel

Course content

Module 1: First steps with Excel VBA programming

  • Introduction to VBA
  • When to use VBA
  • Recording a macro
  • Saving a macro
  • Analyzing a macro

Module 2: Working in the Visual Basic Editor

  • Presentation of the Visual Basic Editor
  • Essential elements of the VBA language
  • Creating and using functions and sub-processes

Module 3: Working with variables

  • Declaration and scope of variables
  • Types of variables
  • Working with constants
  • Assigning values to variables
  • Retrieving values from variables

Module 4: Using VBA functions and Excel

  • Using VBA functions
  • Using Excel functions (WorksheetFunction)
  • Creating custom functions


  • Digital courseware included

Lab / Exercises

  • Practice exercises will be given at the end of each module

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

  • As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress
Prix de l'inscription
CHF 1'200.-
Inclus dans ce cours
  • An online skills assessment test before and after your course so that you can evaluate your progress

jeu13apr(apr 13)09:00ven14(apr 14)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-41

jeu13apr(apr 13)09:00ven14(apr 14)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun22may(may 22)09:00mar23(may 23)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-41

lun22may(may 22)09:00mar23(may 23)17:00VirtuelVirtual Etiquettes de sessionMOE-41

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.


Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request