This is an example of a simple banner
☀️ It's summer at ITTA! Enjoy a 10% discount until July 31st on a selection of courses 🌴 ×

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

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 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

mer17juil(juil 17)09:00jeu18(juil 18)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-42

mer17juil(juil 17)09:00jeu18(juil 18)17:00VirtuelVirtual Etiquettes de sessionMOE-42

lun05Aoû(Aoû 5)09:00mar06(Aoû 6)17:00VirtuelConfirméVirtual Etiquettes de sessionMOE-42

lun05Aoû(Aoû 5)09:00mar06(Aoû 6)17:00Genève, Route des Jeunes 33B, 1227 CarougeConfirmé Etiquettes de sessionMOE-42

mer21Aoû(Aoû 21)09:00jeu22(Aoû 22)17:00VirtuelAnnuléeVirtual Etiquettes de sessionMOE-42

mer21Aoû(Aoû 21)09:00jeu22(Aoû 22)17:00Lausanne, Avenue Mon repos 24, 1005 LausanneAnnulée Etiquettes de sessionMOE-42

mer25Sep(Sep 25)09:00jeu26(Sep 26)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-42

mer25Sep(Sep 25)09:00jeu26(Sep 26)17:00VirtuelVirtual Etiquettes de sessionMOE-42

mer30Oct(Oct 30)09:00jeu31(Oct 31)17:00VirtuelVirtual Etiquettes de sessionMOE-42

mer30Oct(Oct 30)09:00jeu31(Oct 31)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-42

mer04Déc(Déc 4)09:00jeu05(Déc 5)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-42

mer04Déc(Déc 4)09:00jeu05(Déc 5)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