Établissement
Langue d'enseignement
English
Matières
MANAGEMENT OF INFORMATION SYSTEMS
Ce cours apparaît dans les formation(s) suivante(s)
Diplôme IÉSEG (Bac +5) Programme Grande École
- Crédits ECTS: 2.00
Responsable(s)
G.MOURMANT
Intervenant(s)
Gaetan MOURMANT
Présentation
Prérequis
Intermediate level of Excel :
- Named range, $ in a formula
- Match Index, Vlookup formula
- Pivot tables
- Named range, $ in a formula
- Match Index, Vlookup formula
- Pivot tables
Objectifs
At the end of the course, the student should be able to:
• Briefly review the main functions of MS Excel
• Learn VBA syntax and how to use it in interaction with Excel to develop an efficient and user-friendly application.
• Use or improve their skills in data management for their programs.
• Take part in the management of a programming team.
• Briefly review the main functions of MS Excel
• Learn VBA syntax and how to use it in interaction with Excel to develop an efficient and user-friendly application.
• Use or improve their skills in data management for their programs.
• Take part in the management of a programming team.
Présentation
This course provides a managerial perspective on programming, teaching the fundamentals of a well-known programming language: VBA for Excel. Although it is not the only language in use, its concepts are sufficiently simple for students at beginner level to be able to grasp them. Moreover, as part of MS Excel, this language will be extremely useful for the fields of marketing, finance and management.
The course will be highly oriented towards practical applications and will provide, through examples, an introduction to programming languages in general, and VBA in particular. The focus will not be oriented towards complex programs, but on managing a development project.
Classes will consist of standard lectures about programming first, and then will be oriented towards exercises and projects.
The course will be highly oriented towards practical applications and will provide, through examples, an introduction to programming languages in general, and VBA in particular. The focus will not be oriented towards complex programs, but on managing a development project.
Classes will consist of standard lectures about programming first, and then will be oriented towards exercises and projects.
Modalités
Organisation
Type | Amount of time | Comment | |
---|---|---|---|
Présentiel | |||
Cours interactif | 16,00 | ||
Autoformation | |||
E-Learning | 5,00 | ||
Lecture du manuel de référence | 5,00 | ||
Recherche | 5,00 | ||
Travail personnel | |||
Group Project | 19,00 | ||
Overall student workload | 50,00 |
Évaluation
The assessment will be a full project to complete. If you work for a company and if you can bring a real-life project, this is even better.
A grid with student's evaluation will be available.
A grid with student's evaluation will be available.
Ressources
Bibliographie
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, 2009, by Rob Bovey (Author), Dennis Wallentin (Author), Stephen Bullen (Author), John Green (Author) -
Alexander, M., & Kusleika, D. (2016). Excel 2016 power programming with VBA. Wiley. -
Alexander, M., & Kusleika, D. (2016). Excel 2016 power programming with VBA. Wiley. -
Ressources Internet
IESEG Online
Another set of online ressources will be provided to the students.
Another set of online ressources will be provided to the students.
Another set of online ressources will be provided to the students.