Excel VBA - Programming

- Macros vs Excel VBA - Basics: Development environment VBA editor, VBA conventions - VBA language elements and control structures: variables, operators, data fields, statements, loops & branches, procedures, functions, parameters, scopes - Programming aids and error handling - Excel Objects: Object Model, Methods and Properties, Object Variables - Dialogs: Standard dialogs, custom dialogs, use of ActiveX controls - Application examples: programming calculations - Data analysis - Cross-program work - Handling of events