Training: Excel – VBA Fundamentals

Ref. MOE-41
Duration:
2
 days
Exam:
Not certifying
Level:
Intermediate

Description

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

Objectives

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

Prerequisites

  • 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

Documentation

  • Digital course material 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
  • Explore all our Microsoft Office courses by clicking here
Prix de l'inscription
CHF 1'200.-
Inclus dans ce cours
  • Evaluation of your level before and after the training
  • Training provided by a certified trainer
  • Documentation in digital format
  • Achievement Badge

lun01Avr09:00mar02(Avr 2)17:00Lausanne, Avenue Mon repos 24, 1005 LausanneAnnulée Etiquettes de sessionMOE-41

lun01Avr09:00mar02(Avr 2)17:00VirtuelAnnuléeVirtual Etiquettes de sessionMOE-41

jeu04Avr(Avr 4)09:00ven05(Avr 5)17:00VirtuelVirtual Etiquettes de sessionMOE-41

jeu04Avr(Avr 4)09:00ven05(Avr 5)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-41

lun06Mai(Mai 6)09:00mar07(Mai 7)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun06Mai(Mai 6)09:00mar07(Mai 7)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-41

lun10Juin(Juin 10)09:00mar11(Juin 11)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-41

lun10Juin(Juin 10)09:00mar11(Juin 11)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun15juil(juil 15)09:00mar16(juil 16)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun15juil(juil 15)09:00mar16(juil 16)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-41

lun19Aoû(Aoû 19)09:00mar20(Aoû 20)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-41

lun19Aoû(Aoû 19)09:00mar20(Aoû 20)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun23Sep(Sep 23)09:00mar24(Sep 24)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun23Sep(Sep 23)09:00mar24(Sep 24)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-41

lun28Oct(Oct 28)09:00mar29(Oct 29)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-41

lun28Oct(Oct 28)09:00mar29(Oct 29)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun02Déc(Déc 2)09:00mar03(Déc 3)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun02Déc(Déc 2)09:00mar03(Déc 3)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-41

Horaires d’ouverture

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

Contactez-nous

Votre demande

Opening hours

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

Contact us

Your request

X
X
X
X