Creating Digital MS Word Forms and Importing Data Automatically from MS Excel New

Course Code: ASKWF8

Creating Digital MS Word Forms and Importing Data Automatically from MS Excel

At the end of this course, participants will be able to:

  • Creating digital fill-in form in MS Word
  • Filling Word form
  • Automating the importing of Word forms in batch into Excel using VBA
  • Eventually, making your work more efficient and saving tones of time entering the collected data manually
Creating Digital MS Word Forms and Importing Data Automatically from MS Excel
  • Course Date and Venue

    Course Duration: 1 day (8 hours), 9:00a.m. – 5:00p.m.

    CourseVenueFeb-20Mar-20Apr-20May-20Jun-20Jul-20
    Creating Digital MS Word Forms and Importing Data Automatically from MS ExcelJTC Summit--30-08-
    Mountbatten Square-09-06-30

    September 2015

    SMTWTFS
    30
    31
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    1
    2
    3
  • Course Outline:

    Section 1: Microsoft Word

    1. Developer tab
    2. Introduction to Content Controls
    3. Which Content Controls should be avoided
    4. Building the structure of the form using Table
    5. Inserting the Content Controls into the form structure
    6. Setting the properties of the Content Controls
    7. Save the document as the master copy
    8. Protecting the document so that only form filling is allows
    9. Save the document as another name for distribution

    Section 2: Microsoft Excel

    1. Create a workbook for collecting the data from the Word document form
    2. Create the VBA Sub procedure for importing form data from Word document in the Personal Macro Workbook
    3. Place the macro in Excel QAT

    Section 3: Test the Import

    1. Duplicate a few copies of the Word document that contains the form
    2. Save all duplicated copies in the same path as the Excel workbook
    3. Open all duplicated copies and fill the form
    4. Open the workbook and start the importing
  • Anyone who required to collect data such as;

    1. Sales people
    2. Human resource
    3. Marketing & communication
    4. Business development
    5. Educator
    6. and more…

Fees and Grants

$299.60 per participant (Inc. GST)

Click here for UTAP Fundings

Registration

Click here to download registration form.

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

Apply Online

Creating Digital MS Word Forms and Importing Data Automatically from MS Excel (ASKWF8)


All registration should be submitted at least 1 week before course commencement. Please call us directly to check on the class status.

A. Company Particulars

Company Name*

Company Address*

Postal Code*

B. Training Coordinator / Contact Person

TC / Contact Person Name*

TC / Contact Person Email*

Contact Number*

Fax Number

C. Billing Information


Billing Contact Person Name*

Billing Contact Person Email*

Billing Contact Number*

Billing Fax Number

Business Unit (BU / SBU)

For Businesses or Government Agencies using the e-invoice system only.

Are you applying for SDF Grant?

Applicable to some select IT and Softskills Courses.

D. Participants

Participant 1*

Course Start Date*

Course End Date*

Participant 2

Course Start Date*

Course End Date*

Participant 3

Course Start Date*

Course End Date*

Have more than 3 participants?

Attach their particulars here (PDF, Word .doc, Excel .xls)

I have Read and Agree to the Terms and Conditions


We do not sell or share your information with anyone else.

Share this course