Lesson details


 


Voir la fiche établissement

ADVANCED SPREADSHEET ANALYSIS

2016-2017

IESEG School of Management ( IÉSEG )

Class code :

1617-IÉSEG-MBD1S1-MIS-MBDCI01UE

MANAGEMENT OF INFORMATION SYSTEMS


Level Year Period Language of instruction 
MSc in Big Data Analytics for Business1S1English
Academic responsibilityG.MOURMANT
Lecturer(s)G.MOURMANT


Prerequisites

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)

Learning outcomes

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

Course description

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.


Class type

Class structure

Type of courseNumbers of hoursComments
Face to face
Interactive class32,00  
Independent work
E-Learning20,00  
Independent study
Group Project26,00  
Estimated personal workload22,00  
Total student workload100,00  

Teaching methods

  • Research
  • Project work
  • Interactive class


Assessment

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

Type of controlDurationNumberPercentage break-down
Others
Group Project13,001100,00
TOTAL     100,00

Recommended reading

  • 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) -


Internet resources



 
* This information is non-binding and can be subject to change
 
 
Vidéo : Un campus à vivre
Notre chaîne Youtube