Course
Creating templates and forms with Excel («ME6»)
In this half-day workshop you will learn to design and create Excel forms on your own. Thereby you will work with ActiveX control elements. Programming knowledge is not required.
Duration
0.5 days
Price
360.–
Course facts
- Designing an Excel form
- Learning about the main ActiveX controls and their features
- Creating Excel forms on your own
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.