Afficher la pageAnciennes révisionsLiens de retourAjouter au livre.Exporter en PDFHaut de page Cette page est en lecture seule. Vous pouvez afficher le texte source, mais ne pourrez pas le modifier. Contactez votre administrateur si vous pensez qu'il s'agit d'une erreur. =====Course unit: VBA===== * Title in French: VBA * Course code: tba * ECTS credits: 1 * Teaching hours: 25h * Type: elective course * Language of instruction: French * Coordinator: 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** - 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: 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 : 2019/01/10 17:13de cpouet