Lesson details


Voir la fiche établissement



IESEG School of Management ( IÉSEG )

Class code :



Level Year Period Language of instruction 
MSc in Big Data Analytics for Business1S1English
Academic responsibilityG.MOURMANT


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
Independent study
Group Project26,00  
Estimated personal workload22,00  
Total student workload100,00  

Teaching methods

  • Research
  • Project work
  • Interactive class


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

Type of controlDurationNumberPercentage break-down
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