Retour

Computer Sciences : Excel/VBA

ECTS : 2

Volume horaire : 18

Description du contenu de l'enseignement :

1. Introduction: algorithms and programs 2. Values, types and variables 3. Assignment and expression 4. Reading instruction 5. Program structure:¿ Decision making 6. Program structure: Loops 7. Functions 8. Consolidation week 9. Writing own functions 10. String and String methods 11. List: Creation, access and traversal 12. List: Operators and methods 13. Character strings and lists in function 14. Files  

Compétence à acquérir :

Introduce computational logic and programming syntax Explore various ways of writing a program solution for a given problem statement Develop the essential technological background for students' work life. 

Mode de contrôle des connaissances :

Midterm Examination : 50% Final Examination : 50%

Bibliographie, lectures recommandées :

Core Sources

  1. Excel 2019 Power Programming with VBA by Michael Alexander (Author), Dick Kusleika (Author)
  2. https://support.office.com/
Supplementary and Secondary Sources 
  1. https://www.excel-easy.com/vba.html
  2. https://www.homeandlearn.org/

Document susceptible de mise à jour - 01/04/2026
Université Paris Dauphine - PSL - Place du Maréchal de Lattre de Tassigny - 75775 PARIS Cedex 16