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: | ||
| + | |||
| + | |||