Différences
Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentes Révision précédente | |||
en:vba [2016/06/06 17:53] – ↷ Nom de la page changé de en:mefvba à en:vba rbourles | en:vba [2019/01/10 17:13] (Version actuelle) – cpouet | ||
---|---|---|---|
Ligne 1: | Ligne 1: | ||
+ | =====Course unit: VBA===== | ||
+ | |||
+ | * Title in French: VBA | ||
+ | * Course code: tba | ||
+ | * ECTS credits: 1 | ||
+ | * Teaching hours: 25h | ||
+ | * Type: elective course | ||
+ | * Language of instruction: | ||
+ | * Coordinator: | ||
+ | * Instructor(s): | ||
+ | |||
+ | **Brief description** | ||
+ | |||
+ | This course is an elective course. It will be useful for anyone involved in Excel intensive use. | ||
+ | |||
+ | **Learning outcomes** | ||
+ | |||
+ | * Being able to use Excel and VBA to create scientific-based utilities | ||
+ | |||
+ | **Course content** | ||
+ | |||
+ | - Excel: basic elements (graphics, formulas, solver). | ||
+ | - VBA programing: Visual Basic editor, manipulating tables and cells, creating formulas | ||
+ | - Add-Ins: using complementary external macros | ||
+ | - Modeling: the structure of model; explicit, implicit and stochastic models | ||
+ | - Interfacing: | ||
+ | |||
+ | |||
+ | **Bibliography** | ||
+ | * Billo, E. J., "Excel for scientist and engineers: | ||
+ | |||
+ | |||