Outils pour utilisateurs

Outils du site


en:vba

Course unit: VBA

  • Title in French: VBA
  • Course code: tba
  • ECTS credits: 1
  • Teaching hours: 25h
  • Type: elective course
  • Language of instruction: French
  • Responsible: Daniel Roux
  • Instructor(s): Daniel Roux

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

  1. Excel: basic elements (graphics, formulas, solver).
  2. VBA programing: Visual Basic editor, manipulating tables and cells, creating formulas
  3. Add-Ins: using complementary external macros
  4. Modeling: the structure of model; explicit, implicit and stochastic models
  5. Interfacing: creation of userforms and menu bars

Bibliography

  • Billo, E. J., “Excel for scientist and engineers: Numerical Methods”, Ed. John Wiley & Sons (2007)
en/vba.txt · Dernière modification: 2016/06/06 17:53 par rbourles