Formation/Cours

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

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

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