Excel: Macro and VBA Training

Understanding macros and the 2 different ways to create a Macro. Learn how to record and run a Macro without the Visual Basic Editor (VBA) Learn how to modify a macro With VBA.

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

Durée: 2 séances (8 périodes)
Prix: CHF 1200.-
(group price)

Satisfaction Index

5.74 on 6 (348 reviews)

Questions ?

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

Contact us

To contact us, please fill out the form below.

Loading map...

Contact Form

Enter your name.
Please enter a valid email address.
Please enter your phone number
Please enter your message.