Goals
- Know how to integrate a macro in Excel
- Know the VBA objects linked to Excel
Program
Objectives of the VBA language
Presentation of the VBA
Use of the VBA
Principle of operation of a macro
Modifying the code of a macro
Language syntax
Variables
Operators
The Application object
The Workbook
object
The Worksheet object The Range object
Principle of conditions
Presentation of the If condition
Principle of loops
Presentation of For and Do loops
Revisions on Excel
Questions / Answers
Passing the PCIE or TOSA certification
Passing of the certification (if foreseen in the financing).
Duration
1 day
Price
£ 2495
Audience
All
Prerequisites
Have followed the course « Excel: Initiation + Deepening » or have equivalent knowledge
Reference
BUR1226-F
Sessions
Contact us for more informations about session date