EXCEL : EXPERT LEVEL

Année du cours : 1 année(s)

Etablissement : IÉSEG School of Management

Langue : English

Période : S2

Basic knowledge of MS Excel :
– The different components of a workbooks
– Cell formatting
– Named range and $ in a formula
– basic functions : IF, SUM, AVERAGE

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.

***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.