VBA & Macros — Beginner

Objectives

• Optimise repetitive tasks
• Understand object programming
• Retrieve and run a macro
• Edit a macro
• Build a small program

Programme

1. 01Introduction to VBA
2. 02Macros and programs
3. 03The VBE editor
4. 04Object programming
5. 05Reading and editing a macro
6. 06Properties, methods and events
7. 07Hierarchy, collections and classes
8. 08Excel procedures and functions
9. 09Operators and variables
10. 10Loops
11. 11Running and debugging
12. 12Excel case studies

Who is it for

Developers, project managers, coordinators and anyone wanting to optimise their tasks.

Teaching approach

Delivered by an engineering-office professional, BIM and project-management expert. Theory, production methods and hands-on practice on real professional cases. Tailor-made after a call to target your needs.

Training formats

• Live 1-to-1 personalised lessons: a programme adapted to your needs and pace, with an expert trainer just for you.
• Groups for a school or company: sessions organised for your teams or students, with an indicative number of days that can be adjusted.

Plans purchased online give access to the course content as e-learning, with online support through video meetings (screen sharing) depending on the plan. Course lessons are delivered in French.