Fiche détaillée d'un cours


 


Voir la fiche établissement

EXCEL VBA

2016-2017

IESEG School of Management ( IÉSEG )

Code Cours :

1617-IÉSEG-M1S1-MIS-MA-EI53UE

MANAGEMENT OF INFORMATION SYSTEMS


Niveau Année de formation Période Langue d'enseignement 
Master1S1English
Professeur(s) responsable(s)G.MOURMANT
Intervenant(s)Gaetan MOURMANT


Pré requis

Intermediate level of Excel :
- Named range
- Match formula
- Pivot tables

Objectifs du cours

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.

Contenu du cours

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.


Modalités d'enseignement

Organisation du cours

TypeNombre d'heuresRemarques
Face to face
Interactive class16,00  
Independent work
E-Learning6,00  
Independent study
Group Project15,00  
Charge de travail globale de l'étudiant37,00  

Méthodes pédagogiques

  • Project work
  • Interactive class


É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.

Type de ContrôleDuréeNombrePondération
Others
Group Project0,001100,00
TOTAL     100,00

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 2013 Power Programming with VBA Paperback – Apr 5 2013 by John Walkenbach (Author) -


Ressources internet



 
* Informations non contractuelles et pouvant être soumises à modification
 
 
Vidéo : Un campus à vivre
Notre chaîne Youtube