Fiche détaillée d'un cours


 


Voir la fiche établissement

ADVANCED SPREADSHEET ANALYSIS

2017-2018

IESEG School of Management ( IÉSEG )

Code Cours :

1718-IÉSEG-MBD1S1-MIS-MBDCI01UE

MANAGEMENT OF INFORMATION SYSTEMS


Niveau Année de formation Période Langue d'enseignement 
MSc in Big Data Analytics for Business1S1English
Professeur(s) responsable(s)G.MOURMANT
Intervenant(s)G.MOURMANT


Pré requis

• Intermediate level in Excel
- Named range
- Basic knowledge of Index, Match, SUM, IF formula
- Pivot tables
• Basic level of VBA (recording a macro, variables, loop, conditions)

Objectifs du cours

At the end of the course, the student should be able to:
• Use Excel for advanced analysis
• Use tools including
- Advanced use of spreadsheet functions (sumifs, index/match,sommeprod, matricial functions)
- Analytical tools in Excel (Pivot table, Powerpivot, DAX)
- Intermediate and advanced use of Visual Basic for Applications

Contenu du cours

• Advanced use of excel functions
- Quick overview of the basics : Sumifs, Index/Match,Sumproduct, matricial functions, conditional formatting
- Combination of functions in power-formulas
- Reporting & Dashboards
• Analytical tools in Excel
- Pivot Tables
- Powerpivot and DAX
• Intermediate and advanced use of VBA
- Quick overview of the basics : variables, loops and conditions.
- Intermediate : arrays, user-defined functions, userforms.
- Advanced : add-ins, class modules, events procedures, ribbon.
• During the course, we will also cover best practices for designing robust applications using spreadsheets.


Modalités d'enseignement

Organisation du cours

TypeNombre d'heuresRemarques
Face to face
Interactive class32,00  
Independent work
E-Learning5,00  
Independent study
Group Project13,00  
Charge de travail globale de l'étudiant50,00  

Méthodes pédagogiques

  • E-learning
  • Research
  • Interactive class


Évaluation

Students will be asked to develop a fully functional data-analysis application to solve an existing problem.

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

Bibliographie

  • Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, 2009, by Rob Bovey (Author), Dennis Wallentin (Author), Stephen Bullen (Author), John Green (Author) -

  • Excel 2013 Power Programming with VBA Paperback – Apr 5 2013 by John Walkenbach (Author) -


Ressources internet



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