This course is conducted in English and PC/Windows operating system

1-Day Create Fill-In Form In Word And Import Form Data From Excel
Course In Singapore

Learn to create digital fill-in form in MS Word and automate the importing form data to MS Excel

Create Fill-In Form In Word And Import Form Data From Excel Course Overview

Course Description

Gathering information from others can be quite a task and time consuming. Have you ever thought of the following?

How to gather information from people?
How to gather digital information?
How to create digital fill-in form?
How to transfer the digital form into tabular format without entering manually?
How to batch transfer all digital forms into tabular format like Excel automatically?
How to gather information more efficiently?

The above questions are commonly asked by many people without a single clue on solving them and they continue to collect and enter information manually. If you are one of them, this course is specially created for you.

Course Objectives

At the end of the course, learners are able to:

- create digital fill-in form in MS Word.
- fill Word form.
- automate the importing of Word forms in batch into Excel using VBA.
- make their work more efficient and save tones of time without entering the collected data manually.

Who Should Attend?

This course is recommended for anyone who required to collect data, e.g. sales and marketing, business development, human resource, marcom, market surveyors, educator and more…

Methodology

This is a hands-on practical course. Trainer will walk through the topic step-by-step. Learners will be provided with exercise files on every topic to effectively apply what have been taught. A short Q & A session will be available after each topic.

Pre-requisites

Must possess basic working knowledge on Microsoft Word and Microsoft Excel
Programming and VBA knowledge are NOT required

Things To Bring

PC/Windows operating system laptop (personal laptop is preferred as some company laptops may have restriction in accessing internet and USB thumb drive)
Laptop power adaptor
A USB mouse
A USB thumb drive or hard-disk
Software requirement: Microsoft Word and Excel version 2010-2019 or Office 365

Course Outline

1. Microsoft Word

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

2. Microsoft Excel

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

3. Test the Import

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

Our Dedicated Trainer

Mr Alaster Leong

Alaster has been training adult learners in IT in both the private and public sectors since 1986. Alaster’s career before training centred around IT for over 12 years, as he held various roles within software development. He has earned himself a Microsoft Office Specialist (MOS) certification and he is an existing Trainer approved by People’s Association (PA). He was also a former Associate Trainer with the Civil Service College.

He specialises on training Microsoft Applications and Adobe Photoshop. Based on his vast experience and keeping abreast with the emerging trends, tools and technologies with the IT industry, especially software, he has extensively involved in developing several course outlines and course materials and conducting training to equip learners with skills in-demand or likely to be most important in the jobs of the future work.

Alaster constantly explore innovative and effective ways in imparting knowledge and engaging his learners at the same time. He also focuses his training on providing practical solutions to real-life problems, especially Excel. He is more than willing to help overcome various problems faced by his learners that arise in their workplace in applying their newly-acquired knowledge and skills any time after the course. He is well-known for his dedication, commitment and passion to training that makes him well-liked and appreciated by his learners.

Online Registration

Organisations with more than 2 learners, click here to download registration form.

All registration forms should be submitted at least 2 weeks before course commencement. Many courses have pre-requisites, which are intended to foster a learner’s success in the course. Be sure to check the necessary pre-requisites before registering.

Apply Online

Company-Sponsored Form

Company Registration Form – Create fill-in form

Course Title*

Create Fill-In Form In Microsoft Word And Import Form Data From Microsoft Excel Course

Course Date*

Part A: Company Information (optional)

Company Name*

Company Address*

Postal Code*

Part B: Training Coordinator / Contact Person (optional)

Title* (optional)

TC First Name*

TC Last Name*

Contact Number*

🇸🇬

Email*

Department*

Designation*

Part C: Billing Information (optional)

SUB-BU Code (for Govt. Agencies using e-invoice system) (optional)

Part D: Learner(s) Information (optional)

Learner 1 (optional)

Title*

Learner 1 First Name*

Learner 1 Last Name*

Citizenship*

Designation*

Contact Number*

🇸🇬

Email*

Printed Name on Certificate*

Dietary Requirements*

Learner 2 (optional)

Title (optional)

Learner 2 First Name (optional)

Learner 2 Last Name (optional)

Citizenship (optional)

Designation (optional)

Contact Number (optional)

🇸🇬

Email (optional)

Printed Name on Certificate (optional)

Dietary Requirements (optional)

How did you hear about us?*

Others, please specify (optional)

Promo Code (optional)

Legal

I have read, understood and agree to the Terms and Conditions

Self-Sponsored Form

Self Registration Form – Create Fill-in Form

Course Title*

Create Fill-In Form In Microsoft Word And Import Form Data From Microsoft Excel Course

Course Date*

Part A: Learner Information

Title*

First Name*

Last Name*

Residential Address*

Postal Code*

Contact Number*

🇸🇬

Email*

Citizenship*

Printed Name on Certificate*

Dietary Requirements*

How did you hear about us?*

Others, please specify (optional)

Promo Code (optional)

Legal

I have read, understood and agree to the Terms and Conditions

Course Information

Course Code:

ALSIT-CFF

Course Fee:

S$385.00 (Nett)

Inclusive of 2 coffee breaks with refreshments and catered/buffet lunch

Call us for a group rebate when you register in a group of 6 or more

Absentees will be charged the full course fee

Course Dates:

1 day, 9:00am – 5:00pm
(7 hrs, exclude lunch break)

If you have a group of 6 or more preparing for the same course, you can opt for your own “closed” class. Closed classes are perfect for corporate team training where group learning can make a difference.

Please note that closed class is not customised class.

Registration:

For Company-Sponsored Learners: Click here to download registration form

For Self-Sponsored Learners:
Click here to download registration form

You can also register online here

For Government Ministries / Agencies on HRMS / ACE, you are unable to see our courses on the list. Please inform your Training Coordinator the Course Code, Course Title, Course Date and the Training Provider is Advanced Learning Singapore to upload into the system for registration

Click here to download 2020 Training Calendar

Course Venue:

Details of hotel will be confirmed nearer the course start date

Others:

Note:

ALS reserves the right to reschedule, postpone or cancel any course, change the trainer and venue at short notice and at its absolute discretion, due to insufficient enrolment, class size, availability and circumstances outside our control