Creating templates and forms with Excel («ME6»)

1 Concept of form structure

2 The different controls

• Form controls
• ActiveX controls

3 The main properties of controls

4 Structuring the spreadsheet with output cells

5 Evaluating the selected option of a control

6 Structuring a form (custom selection)

• Quote form
• Newsletter/registration form

7 Create and save Excel templates

This course is aimed at people who want to create forms (such as invoice forms).

Profound knowledge of Excel and knowledge of the following functions: IF, VLOOKUP, HLOOKUP, INDEX, OFFSET.