Actualités et agenda
Nos formations
Établissement
Langue d'enseignement
English
Matières
FINANCE
Responsable(s)
P.DAGUET
Intervenant(s)
P.DAGUET
Présentation
Prérequis
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.
Objectifs
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
Présentation
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
Organisation
| 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 | ||
É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.
Individual written feedback will be given to each group alongside with the grade assigned to it.