This class exists in these courses :
• IÉSEG > MSc in Finance > Semester 1 > 2,00 ECTS
• IÉSEG > MSc in Finance > Semestre 2 > 2,00 ECTS

Prerequisites

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

Learning outcomes

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

Course description

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

Class type

Class structure

Teaching methods

• Case study
• Coaching
• Interactive class
• Project work

Assessment

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.