FORMATIONS |
Fiche détaillée d'un cours
EXCEL : EXPERT LEVEL | |||
2018-2019 | FrIESEG School of Management
(
IÉSEG
)
| ||
Code Cours : | 1819-IÉSEG-M1S2-MIS-MA-FI56UE | MANAGEMENT OF INFORMATION SYSTEMS |
Niveau | Année de formation | Période | Langue d'enseignement |
---|---|---|---|
Master | 1 | S2 | FrEnglish |
Professeur(s) responsable(s) | G.MOURMANT |
---|---|
Intervenant(s) | Gaëtan MOURMANT |
- Ce cours apparaît dans les formations suivantes :
- IÉSEG > IESEG Degree - Programme Grande École > Semester 1 > 2,00 ECTS
- IÉSEG > IESEG Degree - Programme Grande École > Semester 2 > 2,00 ECTS
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
Type | Nombre d'heures | Remarques | |
---|---|---|---|
Independent study | |||
Group Project | 1,00 | ||
Independent work | |||
E-Learning | 10,00 | ||
Face to face | |||
Interactive class | 16,00 | ||
Charge de travail globale de l'étudiant | 27,00 |
Méthodes pédagogiques
- Interactive class
- Project work
- Seminar
- Tutorial
Évaluation
Type de Contrôle | Durée | Nombre | Pondération |
---|---|---|---|
Others | |||
Group Project | 12,00 | 1 | 100,00 |
Group Project | 100,00 | 1 | 100,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