• 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

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

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

Testing the Import of Form Data

• 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

This is a one-day hands-on course. The trainer will walk through the topic step-by-step. You will be provided with exercise files on every topic to effectively apply the tips and techniques taught. A short Q & A session will be available after each topic.

Anyone who required to collect data such as;

• Salespeople
• Human resource
• Marketing & communication
• Business development
• Educator
• and more…

Prerequisite:

• Must have basic skill on MS Word
• Must have basic skill on MS Excel
• Programming and VBA knowledge is NOT required

Things to bring during the course:

• A laptop (preferable your personal laptop)
• Laptop MUST NOT restrict from using Excel VBA
• Laptop power adaptor
• A USB mouse
• Software requirement: Microsoft Word and Excel version 2010-2019 or Office 365

Mr Alaster Leong

Having trained adult learners specialising in IT from both public and private sectors since 1986, Alaster has a wealth of experience in training. Before moving into the training sector, Alaster worked in IT for over 12 years – boasting a wide range of roles held within software development. Prior to being approved by People’s Association (PA), Alaster was an Associate Trainer with the Civil Service College.

Besides holding a Diploma in IT, Alaster also holds a Microsoft Office Specialist (MOS) certification and specialises in training Microsoft Office Applications and Adobe Photoshop.

With his vast experience and commitment to keeping abreast with emerging trends, tools and technologies within the IT and software industry, Alaster is extensively involved in developing course outlines and materials that equip learners with up-and-coming skills in demand for the future of work.

In constantly exploring innovative and effective methods of imparting knowledge, Alaster is able to engage his learners in the courses he conducts. A large part of his trainings is committed to providing practical solutions to real-life problems. An approachable and engaging trainer, Alaster is always willing to aid his learners in overcoming various problems using the skills acquired even after courses. Well-known and liked for his dedication, commitment, and passion for training, Alaster is appreciated by his learners.