Training: Excel – Forms and ActiveX controls

Ref. MOE-32

Download PDF

Duration:

0.5

day

Exam:

Not certifying

Level:

Expert

Funding:

Temptraining

ITTA | Trainings | Office Automation | Spreadsheet | Excel – Forms and ActiveX controls

Description

This training will enable participants to create forms in Excel.

Participant profiles

Users who need to set up files used by others, and restrict them through the use of forms

Objectives

Set up a form
Retrieve data from the form and rework it

Prerequisites

Good knowledge of Excel

Course content

Module 1: Forms

Create a simple form
Inserting form controls
Inserting ActiveX controls
Initialize a form control
Knowing the different form controls (button, drop-down list, checkbox, etc.)
Formatting form controls

Module 2: Retrieving data from a form

Interactions between form controls and Excel worksheets
Interactions between form controls and Excel macros

Documentation

Digital courseware included

Lab / Exercises

Practice exercises will be given at the end of each module

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress