ECTS : 2
Volume horaire : 27
Description du contenu de l'enseignement :
Searching and filtering data in a worksheet, cell formating, production of graphs.
Basic concepts in macro programming: variables, Boolean conditions, loops, recursive functions.
Applications using VBA for the Excel Workbook.
Compétence à acquérir :
Being able to use the functions of Microsoft Excel and the macros that operate on the worksheets to perform elementary data processing. Writing macros in Microsoft Visual Basic for Applications (VBA).
Mode de contrôle des connaissances :
A test during the lab sessions, and a final table exam.