Training: Excel – The macro recorder and introduction to VBA

Ref. MOE-31
Duration:
0.5
 day
Exam:
Not certifying
Level:
Expert

Description

This course will give participants a first introduction to VBA, and will allow them to automate their work using simple macros.

Participant profiles

  • Advanced users who need to automate their work procedures

Objectives

  • Create simple macros
  • Edit their VBA code
  • Manage the use of their macros

Prerequisites

  • Expert knowledge of Excel

Course content

Module 1: The Macro Recorder

  • Displaying the Developer tab
  • Creating a macro through the macro recorder
  • Running recorded macros
  • Saving macros in the personal macro folder

Module 2: The Visual Basic Editor

  • Using the Visual Basic Editor in Excel
  • Using relative references
  • Deleting macros

Module 3: Using your macros

  • Creating a new ribbon
  • Adding a Macro to a Ribbon
  • Adding a macro to the Quick Access Toolbar
  • Assigning a macro to an object, a button or a control

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

ven14apr09:00ven12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-31

ven14apr09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-31

ven26may09:00ven12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-31

ven26may09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-31

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