Excel VBA 2003 / 2007 (Beginner, Intermediate and Advanced Level)
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
Data handling on the Excel interface (functions, forms…) Management of interface development and execution (menus, customized tool bars, form)
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
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 |
Dev Training
.
.
.
Finance Training
.
.
.
Opinion Poll
.
.
.