EXCEL : EXPERT LEVEL
Année du cours : 1 année(s)
Etablissement : IÉSEG School of Management
Langue : English
Formation(s) dans laquelle/lesquelles le cours apparait :
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.