News
Our Degree Programs
Establishment
Language of instruction
English
Teaching content
MANAGEMENT OF INFORMATION SYSTEMS
This course occurs in the following program(s)
IESEG Degree - Programme Grande École
- Crédits ECTS: 2.00
Training officer(s)
G.MOURMANT
Stakeholder(s)
K.MOHAJERI, Gaëtan MOURMANT
Présentation
Prerequisite
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
Goal
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.
Presentation
***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
Organization
| 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 | ||
Evaluation
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
Bibliography
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. -
Internet resources