Fiche détaillée d'un cours


Voir la fiche établissement



IESEG School of Management ( IÉSEG )

Code Cours :



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

Pré requis

Basic knowledge of MS Excel :
- The different components of a workbooks
- Cell formatting
- Named range
- $ in a formula
- basic functions : IF, SUM, AVERAGE

Objectifs du cours

At the end of the course, the student should be able:
To create a solid, robust and well-designed application for MS Excel. In addition, the following functions would be mastered : pivot table, sumproduct, sumifs, index, match, vlookup, advanced techniques for interactive and dynamic charts and reports.

Create a VBA application displyaing a userform linked to the excel workbook

Contenu du cours

The following questions will be treated :
Excel tools and Functions :
- Advanced usage of data validation
- Sumifs
- Sumproduct
- Most powerful tips and tricks
- vlookup vs Index/Match
- Interactive and dynamic chart and report
- Conditional formatting
- Pivot table
Excel programming langage (VBA) :
- Variables,
- Loop,
- Conditions,
- Userforms

During the course, the structure of the workbook, the best practices and the methodological points will also be discussed.

Modalités d'enseignement

Organisation du cours

TypeNombre d'heuresRemarques
Face to face
Interactive class16,00  
Independent work
Independent study
Group Project12,00  
Charge de travail globale de l'étudiant38,00  

Méthodes pédagogiques

  • Project work
  • Interactive class


The exam will be a full project to complete.

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


  • Pivot table – Data crunching – Bill Jelen and Michael Alexander – Business solutions, 2013 -

  • All the books from Walkenbach -

  • Online video, either recorded during the course or before the course, will be provided - A full online VBA course will also be provided -

Ressources internet

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