Établissement
Langue d'enseignement
English
Matières
MANAGEMENT OF INFORMATION SYSTEMS
Ce cours apparaît dans les formation(s) suivante(s)
Diplôme IÉSEG (Bac +5) Programme Grande École
- Crédits ECTS: 2.00
Responsable(s)
G.MOURMANT
Intervenant(s)
K.MOHAJERI, Gaëtan MOURMANT
Présentation
Prérequis
Basic knowledge of MS Excel :
- The different components of a workbooks
- Cell formatting
- Named range and $ in a formula
- basic functions : IF, SUM, AVERAGE
- The different components of a workbooks
- Cell formatting
- Named range and $ in a formula
- basic functions : IF, SUM, AVERAGE
Objectifs
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.
- 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.
Présentation
***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.
*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
Organisation
Type | Amount of time | Comment | |
---|---|---|---|
Présentiel | |||
Cours interactif | 16,00 | ||
Autoformation | |||
E-Learning | 20,00 | ||
Travail personnel | |||
Group Project | 14,00 | ||
Overall student workload | 50,00 |
Évaluation
MCQ and one project in group of 2 maximum. Regarding the project, a detailled grid of feedback is availble for the students.
Control type | Duration | Amount | Weighting |
---|---|---|---|
Autres | |||
Projet Collectif | 14,00 | 1 | 60,00 |
Contrôle continu | |||
QCM | 1,00 | 1 | 40,00 |
TOTAL | 100,00 |
Ressources
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. -
All the books from Walkenbach -
Online video, either recorded during the course or before the course, will be provided. -
Ressources Internet