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

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…