Establishment
Language of instruction
English
Teaching content
FINANCE
Training officer(s)
P.DAGUET
Stakeholder(s)
P.DAGUET
Présentation
Prerequisite
XLS ADVANCED SKILLS
Good working knowledge of Microsoft Excel;
No prior programming experience is expected.
Good working knowledge of Microsoft Excel;
No prior programming experience is expected.
Goal
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
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
Presentation
VBA language
VBA code
Objects properties, functions, methods,routines
Interactive dialog boxes
Advanced xls functionalities coupled with vba programming
VBA code
Objects properties, functions, methods,routines
Interactive dialog boxes
Advanced xls functionalities coupled with vba programming
Modalités
Organization
Type | Amount of time | Comment | |
---|---|---|---|
Présentiel | |||
Cours magistral | 16,00 | ||
Travail personnel | |||
Charge de travail personnel indicative | 12,30 | ||
Group Project | 4,30 | ||
Overall student workload | 32,00 |
Evaluation
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.
Individual written feedback will be given to each group alongside with the grade assigned to it.