AlephSys

Excel VBA 2003 / 2007 (Beginner, Intermediate and Advanced Level)

Training objectives and Expertise outcome:

Automation of intensive, long and repetitive processes.

Develop of robust and optimized applications in VBA and/or using Excel functions.

 Customize your working environment and create forms to limit data entry errors

Teaching method 

Case study:

 Create a tool for asset management, using the Markowitz portfolio theory

Content details:

Data handling on the Excel interface (functions, forms…)

Management of interface development and execution (menus, customized tool bars, form)

Programming in VBA

Structuring a program

Creating a test sample

 Debugging

Other language elements

Variables

Decision structures

Loop structures

Event object-oriented language

Classes and objects

Concepts of properties and methods

Events

Practical information

 Training location: At our premises or the Client’s premises

2-day course dates: throughout the year, contact us

 Enrolment method:

Minimum number of participants: 7

Maximum number of participants: 11

Cost per participant: Contact us to arrange a costing according to your needs