Target audience

Excel user who needs to automate repetitive tasks.

Objectives

After Excel: Macro and VBA, participants master the following:

• Understand macros
• The developer Tab
  Set up Excel to allow Macros
  Record and Run a Macro
• What's VBA
  The VBA Editor
  Modify a Macro with VBA
  The Structure of a procedure
  Example of VBA Statements
  IF  Condition and LOOPs 
• Practical Cases

Requirements

Windows, Excel basics and Excel advanced

Methodology

Excel Macro and VBA training is based on theoretical Excel manual, but main part of the training is dedicated to practical exercises with personalized assistance from the trainer.

Content

• Understand macros
• The developer Tab
  Set up Excel to allow Macros
  Record and Run a Macro
• What's VBA
  The VBA Editor
  Modify a Macro with VBA
  The Structure of a procedure
  Example of VBA Statements
  IF  Condition and LOOPs 
• Practical Cases

Diploma / Certificate

A certificate is awarded upon completion of training "Excel: Macro and VBA"

Print version

Format PDF

Duration and Price

2 séances de 3h (8 périodes)
CHF 1200.- (group price)

Satisfaction Index

5.78 on 6 (157 reviews)

Questions ?

Contact us
Tél. +41 22 732 51 11
Lu-Ve 8h30 to 17h00