Microsoft Excel Logo

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