MY ACCOUNT

IT Pro

>

MS Office

>

Management

>

Multimedia

>

Development

>

Collaborative tools

>

Soft skills

>

Digital Marketing

>

ALL TRAININGS

Training: Excel – VBA Advanced

Ref. MOE-42

Download PDF

Duration:
2
 days
Exam:
Not certifying
Level:
Advanced
Funding:
Temptraining

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
  • An online skills assessment test before and after your course so that you can evaluate your progress

lun03apr(apr 3)09:00mar04(apr 4)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-42

lun03apr(apr 3)09:00mar04(apr 4)17:00VirtuelVirtual Etiquettes de sessionMOE-42

lun15may(may 15)09:00mar16(may 16)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-42

lun15may(may 15)09:00mar16(may 16)17:00VirtuelVirtual Etiquettes de sessionMOE-42

  • ITTA
    Route des jeunes 33 Bis, Entrée B,
    1227 Carouge, Suisse

Horaires d’ouverture

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

Contactez-nous

  • ITTA
    Route des jeunes 33 Bis, Entrée B,
    1227 Carouge, Suisse

Votre demande

Opening hours

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

Contact us

  • ITTA
    Route des jeunes 33B,
    1227 Carouge, Suisse

Your request

X
X
X
X