Fiche détaillée d'un cours


 


Voir la fiche établissement

EXCEL : EXPERT LEVEL

2017-2018

IESEG School of Management ( IÉSEG )

Code Cours :

1718-IÉSEG-M1S1S2-MIS-MA-FI56UE

MANAGEMENT OF INFORMATION SYSTEMS


Niveau Année de formation Période Langue d'enseignement 
Master1S1S2English
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, powerpivot, powerquery, 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, PowerQuery and PowerPivot
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
E-Learning10,00  
Independent study
Group Project1,00  
Charge de travail globale de l'étudiant27,00  

Méthodes pédagogiques

  • Tutorial
  • Seminar
  • Project work
  • Interactive class


Évaluation

Type de ContrôleDuréeNombrePondération
Others
Group Project100,001100,00
Group Project12,001100,00
TOTAL     200,00

Bibliographie

  • 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