Ects : 2

Enseignant responsable :

• ANDRE ROSSI

Volume horaire : 27

Description du contenu de l'enseignement :

Using the R1C1 reference style for the cells in an Excel Worksheet.

Basic concepts in macro programming: variables, Boolean conditions, loops, recursive functions.

Applications using VBA for the Excel Workbook.

Pré-requis recommandés :

Elementary skills in maths, and the ability to use a computer.

Coefficient : 0.75

Compétence à acquérir :

Mastering the functions of Microsoft Excel and the macros that operate on the workseet. Writing macros in Microsoft Visual Basic for Application (VBA).

Mode de contrôle des connaissances :

A test during the lab sessions, and a final table exam.