ASK Training

Course Description

This course is designed for Organisation who are not allowed to use Google forms to collect data due to security reasons. To overcome data collection and collating into meaningful reporting formats, you only need to have Basic Microsoft Word and Excel knowledge. This course allows Organisation to create surveys, questionnaires or application forms and after which the information can be collated for analysis by a few simple steps. You can increase your work productivity without having any programming knowledge to achieve exactly what Google forms can do.

Course Objectives

At the end of this course, you should be able to:

Use word processing features to create and manage output of documents

Create digital fill-in form in MS Word

Use the necessary tools to shape your writing

Fill Word form

Understand how Excel programming environment works

Automate the importing of Word forms in batch into Excel using VBA

Save precious time usually spent entering the collected data manually and have greater work productivity

Save precious time usually spent entering the collected data manually and have greater work productivity

Use word processing features to create and manage output of documents

Create digital fill-in form in MS Word

Use the necessary tools to shape your writing

Fill Word form

Understand how Excel programming environment works

Automate the importing of Word forms in batch into Excel using VBA

Save precious time usually spent entering the collected data manually and have greater work productivity

Save precious time usually spent entering the collected data manually and have greater work productivity

Course Outline

You will be learning the following:

  • Developer tab
  • Introduction to Content Controls
  • Which Content Controls should be avoided
  • Building the structure of the form using Table
  • Inserting the Content Controls into the form structure
  • Setting the properties of the Content Controls
  • Save the document as the master copy
  • Protecting the document so that only form filling is allows
  • Save the document as another name for distribution
  • Duplicate a few copies of the Word document that contains the form
  • Save all duplicated copies in the same path as the Excel workbook
  • Open all duplicated copies and fill the form
  • Open the workbook and start the importing
  • Create a workbook for collecting the data from the Word document form
  • Create the VBA Sub procedure for importing form data from Word document in the Personal Macro Workbook
  • Place the macro in Excel QAT

Course Fees And Grants

S$299.60 per participant (Incl. GST)

 

Click here for UTAP Fundings

SDF Subsidy for Company Sponsored Individuals: S$2 per training hour. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

 

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

Course Schedule

CourseCodeVenueMay-21Jun-21Jul-21Aug-21Sep-21Oct-21Nov-21Dec-21
Creating Digital MS Word Forms and Importing Data Automatically from MS ExcelTGS-2020503209JTC Summit-29-10-28-30
TGS-2020503209Mountbatten Square07-19-21-23-

Registration

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Our Corporate Partners

What Our Students Say

COURSE FEES AND GRANTS

S$299.60 per participant (Incl. GST)

 

Click here for UTAP Fundings

SDF Subsidy for Company Sponsored Individuals: S$2 per training hour. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

 

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

REGISTRATION

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Browse Courses

Learning Paths

Master Microsoft Office

Master Microsoft Office

Become a Web Designer

Become a Web Designer

Become a Digital Marketer

Become a Digital Marketer

Become a Video Producer

Become a Video Producer