Ce cours apparaît dans les formations suivantes :
• IÉSEG > MSc in Finance > Semester 1 > 2,00 ECTS
• IÉSEG > MSc in Finance > Semestre 2 > 2,00 ECTS

Pré requis

XLS ADVANCED SKILLS
Good working knowledge of Microsoft Excel;
No prior programming experience is expected.

Objectifs du cours

Understand and write a structured code
Know to debug
Rationalize basic interactive tasks and repetitive functions
Build a userform
Breakdown complex organizational problems using the appropriate methodology
Construct expert knowledge from cutting-edge information
Demonstrate an expertise on key concepts, techniques and trends in their professional field
Be a reference point for expertise-related questions and ambiguities

Contenu du cours

VBA language
VBA code
Objects properties, functions, methods,routines
Interactive dialog boxes
Advanced xls functionalities coupled with vba programming

Modalités d'enseignement

Organisation du cours

Méthodes pédagogiques

• Case study
• Coaching
• Interactive class
• Project work

Évaluation

Students will be assessed through the realization of a deliverable constituted by a presentation of theeir work, a xls file with macro-enabling capabilities and a detailed macro descriptions.
Individual written feedback will be given to each group alongside with the grade assigned to it.