The following is a standard lesson content as an example. It is highly recommended to carry out a good target group/needs analysis before proposing a real lesson content.

An advanced course is also possible – it is recommended to make this a workshop in which the participants bring their projects (and send them in advance).

Macros

• Recording a macro
• Attaching a macro to a button

Visual Basic

• The VBE (Visual Basic Editor)
• Modules
• Variables
• Procedures and functions
• Inputbox and Msgbox
• Decision-making structures
• Loops
• Error Handling

Excel Objects

• The Excel Object Model
• Properties, Methods, and Events
• The application object
• The workbook(s) object
• The worksheet(s) object
• The range object

Forms

• Working with form objects (buttons, drop-down list, checkbox, etc.)
• Working with forms in Excel