Actualités et agenda
Nos formations
Établissement
Langue d'enseignement
English
Matières
MANAGEMENT OF INFORMATION SYSTEMS
Ce cours apparaît dans les formation(s) suivante(s)
MSc in Accounting, Audit & Control
- Crédits ECTS:
MSc in Business Analysis & Consulting
- Crédits ECTS:
Responsable(s)
G.MOURMANT
Intervenant(s)
G.MOURMANT
Présentation
Prérequis
Intermediate level of Excel :
- Named range
- Index/Vlookup/Match formula
- Pivot tables
- Named range
- Index/Vlookup/Match formula
- Pivot tables
Objectifs
• Given a specific problem, find the appropriate solution by breaking down a problem into smaller steps, write the appropriate algorithm, then transform it into VBA. Out of the box thinking is required to choose among various solutions.
=> Related learning objective: 3.A Breakdown complex organizational problems using the appropriate methodology
• Use and improve their skills in data management.
• Acquire general and specific knowledge of a programming language. This is key in regards the development of AI and machine learning.
• In addition, the recent development of Excel (e.g. Dynamic array, PowerQuery, PowerPivot) are placing VBA as a great tool for the analysis of large sets of data and the building of complex models.
=> Related learning objective: 5.B Construct expert knowledge from cutting-edge information
• Use general professional VBA syntax
• Use specific professional VBA syntax in interaction with the objects of Excel.
=> Related learning objective: 7.A Demonstrate an expertise on key concepts, techniques and trends in their professional field
=> Related learning objective: 3.A Breakdown complex organizational problems using the appropriate methodology
• Use and improve their skills in data management.
• Acquire general and specific knowledge of a programming language. This is key in regards the development of AI and machine learning.
• In addition, the recent development of Excel (e.g. Dynamic array, PowerQuery, PowerPivot) are placing VBA as a great tool for the analysis of large sets of data and the building of complex models.
=> Related learning objective: 5.B Construct expert knowledge from cutting-edge information
• Use general professional VBA syntax
• Use specific professional VBA syntax in interaction with the objects of Excel.
=> Related learning objective: 7.A Demonstrate an expertise on key concepts, techniques and trends in their professional field
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.
As this module gives mostly basic knowledge on programming project management, there will be no need for an exam. 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.
As this module gives mostly basic knowledge on programming project management, there will be no need for an exam. 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 | |||
| Lecture du manuel de référence | 1,30 | ||
| E-Learning | 1,30 | ||
| Travail personnel | |||
| Group Project | 15,00 | ||
| Overall student workload | 33,00 | ||
Évaluation
This will be a group project to develop an Excel-VBA application
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) -
Excel 2016 Power Programming with VBA Paperback – by Michael Alexander, Richard Kusleika -
Excel 2016 Power Programming with VBA Paperback – by Michael Alexander, Richard Kusleika -