Training: Excel – VBA Advanced

Ref. MOE-42
Duration:
2
 days
Exam:
Not certifying
Level:
Advanced

Description

This course teaches the more advanced features of VBA with a focus on automating tasks and processes in Excel.

Participant profiles

  • Office experts who already know VBA and wish to improve their practices

Objectives

  • Work with objects
  • Automate tasks in Excel
  • Create dialog boxes
  • Debug their VBA code

Prerequisites

To have the equivalent knowledge or to have followed the training: Excel – VBA Fundamentals

Course content

Module 1: Presentation of the Excel object model

  • Referencing objects
  • Properties and methods of objects
  • Different ways to reference a range
  • Useful properties and methods of the Range object

Module 2: Automating with Excel

  • Simple commands
  • ActiveX commands
  • Managing Excel and dialog boxes
  • Save user settings in the Registry
  • Merging data from several tables
  • String functions

Module 3: Creating UserForms

  • Form controls
  • Adding event handling procedures

Module 4: Debugging Techniques

  • Intercepting errors
  • Using the Visual Basic testing tools

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

lun19Juin(Juin 19)09:00mar20(Juin 20)17:00VirtuelVirtual Etiquettes de sessionMOE-42

lun19Juin(Juin 19)09:00mar20(Juin 20)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-42

lun24juil(juil 24)09:00mar25(juil 25)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-42

lun24juil(juil 24)09:00mar25(juil 25)17:00VirtuelVirtual Etiquettes de sessionMOE-42

lun28Aoû(Aoû 28)09:00mar29(Aoû 29)17:00VirtuelVirtual Etiquettes de sessionMOE-42

lun28Aoû(Aoû 28)09:00mar29(Aoû 29)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-42

lun02Oct(Oct 2)09:00mar03(Oct 3)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-42

lun02Oct(Oct 2)09:00mar03(Oct 3)17:00VirtuelVirtual Etiquettes de sessionMOE-42

lun06Nov(Nov 6)09:00mar07(Nov 7)17:00VirtuelVirtual Etiquettes de sessionMOE-42

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

lun11Déc(Déc 11)09:00mar12(Déc 12)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-42

lun11Déc(Déc 11)09:00mar12(Déc 12)17:00VirtuelVirtual Etiquettes de sessionMOE-42

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