ECTS : 2
Lecturer in charge : Denis CORNAZ (https://www.lamsade.dauphine.fr/~cornaz/)
Language of instruction : French
Teaching hours : 18
Course content:
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.
Skills to be acquired:
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).
Recommended prerequisites
Elementary skills in maths, and the ability to use a computer.
Assessment:
A test during the lab sessions, and a final table exam.
Weighting : 0.75