1- Understand, record and edit simple macros. Discover the VBA environment.
Introduction to VBA and macros
Security, registration, macro modification
Structure of Sub
Navigation in the VBE environment
Bases on objects, properties, methods
Cell handling, beaches
First automations (copy-paste, formatting, simple transfers)

2- Write simple VBA code, manage conditions, loops, interact with user.
Variable Reporting
Conditional structures and loops
MsgBox, InputBox, user logic
Handling of several sheets and binders
Modular organization of the code
Simple Debugging
Small custom automated tools

3- Create functions, UserForms, manage events, structure automated applications.
Custom Functions
Creating Interfaces (UserForms)
Event programming
Interactions interapplications (Outlook, Word)
Optimization, modularity
VBA project structure
Advanced business use: reporting, extraction, consolidation