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 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
  • Evaluation of your level before and after the training
  • Training provided by a certified trainer
  • Complete documentation in digital format
  • Skills report showing your progress

lun26Juin(Juin 26)09:00mar27(Juin 27)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-41

lun26Juin(Juin 26)09:00mar27(Juin 27)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun31juilmar01AoûVirtuelAnnuléeVirtual Etiquettes de sessionMOE-41

lun07Aoû(Aoû 7)09:00mar08(Aoû 8)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-41

lun07Aoû(Aoû 7)09:00mar08(Aoû 8)17:00Virtuel Etiquettes de sessionMOE-41

lun04Sep(Sep 4)09:00mar05(Sep 5)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-41

lun04Sep(Sep 4)09:00mar05(Sep 5)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun09Oct(Oct 9)09:00mar10(Oct 10)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun09Oct(Oct 9)09:00mar10(Oct 10)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-41

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

lun13Nov(Nov 13)09:00mar14(Nov 14)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun18Déc(Déc 18)09:00mar19(Déc 19)17:00VirtuelVirtual Etiquettes de sessionMOE-41

lun18Déc(Déc 18)09:00mar19(Déc 19)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne 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