Presentation of VBA
Interest of the VBA language
Design of a program
Principle of operation of a macro

Create a first macro (Sub)
Use the macro recorder
View the code of a recorded macro
Language syntax

Workshop: Practice with the macro recorder

What is an object?
The interest of objects in Office
Use the Object Explorer and Office Help

Access the cells (Range)
Access the sheets (Worksheet)
Access the workbooks (Workbook)
Access the software (Application)

Workshop: Perform operations on a workbook using Excel objects

Understand and use variables
Assign data types to variables (text, number, date, etc.)
Operators (arithmetic, comparison, logic, etc.)
Save a list of information with arrays
Create and use constants

Insert buttons in a sheet
Add shortcuts in the Office ribbon
Use event macros
Nest macros in others (Private / Public)

Presentation and interest of conditions
Conditions If
Tests Select Case
Nesting conditional tests

Workshop: Complete a table differently depending on several scenarios

Presentation and interest of loops
Perform a loop following a counter (For Next)
Adapt a loop to a condition (Do While)
Retrieve all the elements of a group (For Each)

Workshop: Creating a summary at the start of an Excel workbook

Presentation of forms
Add controls (text fields, drop-down lists, check boxes, etc.)
Customize the graphical interface of a form
Define the actions to be performed

Workshop: Create a form to automatically fill in a table