Fiche détaillée d'un cours


 


Voir la fiche établissement

ADVANCED SPREADSHEET ANALYSIS

2016-2017

IESEG School of Management ( IÉSEG )

Code Cours :

1617-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
Tools will include
- Advanced use of spreadsheet functions (sumifs, index/match,sommeprod, matricial functions)
- Analytical tools in Excel (Solver, 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
- Solver
- 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-Learning20,00  
Independent study
Group Project26,00  
Estimated personal workload22,00  
Charge de travail globale de l'étudiant100,00  

Méthodes pédagogiques

  • Research
  • Project work
  • 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