This course is conducted in PC/Windows operating system and all learners are required to bring their own laptops.

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

Learn to extract digital fillable forms in Word and tabulate into Excel automatically in seconds or within minutes

All our courses are not subsidised / SkillsFuture claimable

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

The below questions are commonly asked by many people without a single clue on solving them and continue spending quality time collecting and entering information manually.

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

Well, creating a form is easy but creating a fillable Word form can be challenging and time consuming when transferring the digital form into tabular format is done manually.

Take for example,  you have 50 forms with 20 items in a single form. If the transferring of data (copy and paste) is done manually, you may take 5 mins or longer to complete 1 form. If you have 50 forms with 1000 items to be transferred, how much time will it takes you? It takes you 4 hours 16 mins to complete 50 forms by doing manually and continuously without any break time.

What if you can get 50 forms done in less than 30 seconds? This course is specially developed to increase your work efficiency by learning how to automate the importing of data to Excel. Focus on more worthwhile tasks with the 4 hours 15.5 mins you saved.

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.

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…

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.

  • Must possess basic working knowledge on Microsoft Word and Microsoft Excel
  • Programming and VBA knowledge are NOT required
  • 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

  • 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
  • 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
  • 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

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

All our courses are not subsidised / SkillsFuture claimable.

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

This course is not subsidised / SkillsFuture claimable.

Online Registration Form – Company

Part A:     Course Information

  • Create Digital Fill-in Form in Word & Auto Import Form Data from Excel
  • Creating Dynamic & Interactive Chart in Excel
  • Data Analysis using Dynamic & Interactive Excel Dashboard
  • Data Analysis with Excel Power Query, Data Model & Power Pivot
  • Data Analytics using Power BI Desktop Series 1 – Data Modelling & DAX Formulas
  • Data Analytics using Power BI Desktop Series 2 – Time Intelligence & Dashboard Visualization
  • Excel 100 Tips & Techniques
  • Excel Advanced Formulas & Functions
  • Excel Data Cleansing & Building Techniques
  • Excel Pivot Table In-Depth
  • Excel VBA Series 1 – Fundamentals
  • PowerPoint Tips & Techniques
  • Word Tips & Techniques
  • ————————————————————————————————————————————————————————————-
  • 21st Century Supervisory Management Skills
  • Adapt, Evolve and Change – Embracing Changes in an Ever-Transforming Work Environment
  • Better Grammar for Business
  • Dealing with Difficult Customers Behaviour
  • Editing & Proofreading Skills
  • Emotional Intelligence Skills to Make A Difference In your Service to Customers
  • Error-Proofing Your Process, Products and Services
  • How to Talk to Anyone: The Art of Everyday Conversation
  • Keys To Increase Your Focus & Productivity At Work
  • Kickass Presentations Intensive
  • Leading with Influence:Walk, Talk And Act Like A Boss™
  • Managing Conflict and Confrontation the Less Stressful Way
  • MEMORY Empowerment Workshop for Higher Efficiency
  • Nurturing Your Creative Brain
  • Persuade Like A Lawyer
  • Persuasion and Influence Secrets
  • Proactive Failure Management using FMEA (Failure Mode Effect and Analysis)
  • Problem Solving the 8D (Disciplines) Approach
  • Quality Control Tools for Data Analysis and Problem Solving
  • Quick Guide for Supervisory Management Roles
  • Reducing Stress While Optimizing Your 24/7
  • Systematic Approach to Solve Problems and Make Decisions
  • The Art of Technical Writing
  • The CRM Ways to Long Lasting Relationship
  • The Fundamentals of Business Process Reengineering – Don't Wait for Something to be Broken to Fix It!
  • The Real Approach (and Human Side) of Project Management
  • The Transformative Power of Story: Using Storytelling to Lead, Sell & Influence
  • Uncover Your Communication Power Towards Greater Understanding
  • Understanding how to be LEAN (not just for manufacturing industry)
  • Writing Better Emails
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 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
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 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
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038
  • Create Digital Fill-in Form in Word & Auto Import Form Data from Excel
  • Creating Dynamic & Interactive Chart in Excel
  • Data Analysis using Dynamic & Interactive Excel Dashboard
  • Data Analysis with Excel Power Query, Data Model & Power Pivot
  • Data Analytics using Power BI Desktop Series 1 – Data Modelling & DAX Formulas
  • Data Analytics using Power BI Desktop Series 2 – Time Intelligence & Dashboard Visualization
  • Excel 100 Tips & Techniques
  • Excel Advanced Formulas & Functions
  • Excel Data Cleansing & Building Techniques
  • Excel Pivot Table In-Depth
  • Excel VBA Series 1 – Fundamentals
  • PowerPoint Tips & Techniques
  • Word Tips & Techniques
  • ————————————————————————————————————————————————————————————-
  • 21st Century Supervisory Management Skills
  • Adapt, Evolve and Change – Embracing Changes in an Ever-Transforming Work Environment
  • Better Grammar for Business
  • Dealing with Difficult Customers Behaviour
  • Editing & Proofreading Skills
  • Emotional Intelligence Skills to Make A Difference In your Service to Customers
  • Error-Proofing Your Process, Products and Services
  • How to Talk to Anyone: The Art of Everyday Conversation
  • Keys To Increase Your Focus & Productivity At Work
  • Kickass Presentations Intensive
  • Leading with Influence:Walk, Talk And Act Like A Boss™
  • Managing Conflict and Confrontation the Less Stressful Way
  • MEMORY Empowerment Workshop for Higher Efficiency
  • Nurturing Your Creative Brain
  • Persuade Like A Lawyer
  • Persuasion and Influence Secrets
  • Proactive Failure Management using FMEA (Failure Mode Effect and Analysis)
  • Problem Solving the 8D (Disciplines) Approach
  • Quality Control Tools for Data Analysis and Problem Solving
  • Quick Guide for Supervisory Management Roles
  • Reducing Stress While Optimizing Your 24/7
  • Systematic Approach to Solve Problems and Make Decisions
  • The Art of Technical Writing
  • The CRM Ways to Long Lasting Relationship
  • The Fundamentals of Business Process Reengineering – Don't Wait for Something to be Broken to Fix It!
  • The Real Approach (and Human Side) of Project Management
  • The Transformative Power of Story: Using Storytelling to Lead, Sell & Influence
  • Uncover Your Communication Power Towards Greater Understanding
  • Understanding how to be LEAN (not just for manufacturing industry)
  • Writing Better Emails
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 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
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 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
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038

Part B:     Company Information

Part C:     Particulars of Training Coordinator / Contact Person

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.

Part D:     Billing Information 

Part E:     Learner(s) Information

Learner 1

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
  • Singaporean
  • Singapore PR
  • Others
  • Muslim
  • Vegetarian
  • No Preference

Learner 2

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
  • Singaporean
  • Singapore PR
  • Others
  • Muslim
  • Vegetarian
  • No Preference
  • ALS Sales Team / Email Updates
  • Search Engines (Bing, Yahoo, Google)
  • Social Media (LinkedIn, Facebook)
  • Referral (Colleagues, Friends, Family)
  • Others

Online Registration Form – Individual

Part A.     Course Information

  • Create Digital Fill-in Form in Word & Auto Import Form Data from Excel
  • Creating Dynamic & Interactive Chart in Excel
  • Data Analysis using Dynamic & Interactive Excel Dashboard
  • Data Analysis with Excel Power Query, Data Model & Power Pivot
  • Data Analytics using Power BI Desktop Series 1 – Data Modelling and DAX Formulas
  • Data Analytics using Power BI Desktop Series 2 – Time Intelligence & Dashboard Visualisation
  • Excel 100 Tips and Techniques
  • Excel Advanced Formulas & Functions
  • Excel Data Cleansing & Building Techniques
  • Excel Pivot Table In-Depth
  • Excel VBA Series 1 – Fundamentals
  • PowerPoint Tips & Techniques
  • Word Tips & Techniques
  • 21st Century Supervisory Management Skills
  • Adapt, Evolve and Change – Embracing Changes in an Ever-Transforming Work Environment
  • Better Grammar for Business
  • Dealing with Difficult Customers Behaviour
  • Editing & Proofreading Skills
  • Emotional Intelligence Skills to Make A Difference In your Service to Customers
  • Error-Proofing Your Process, Products and Services
  • How to Talk to Anyone: The Art of Everyday Conversation
  • Keys To Increase Your Focus & Productivity At Work
  • Kickass Presentations Intensive
  • Leading with Influence:Walk, Talk And Act Like A Boss™
  • Managing Conflict and Confrontation the Less Stressful Way
  • MEMORY Empowerment Workshop for Higher Efficiency
  • Nurturing Your Creative Brain
  • Persuade Like A Lawyer
  • Persuasion and Influence Secrets
  • Proactive Failure Management using FMEA (Failure Mode Effect and Analysis)
  • Problem Solving the 8D (Disciplines) Approach
  • Quality Control Tools for Data Analysis and Problem Solving
  • Quick Guide for Supervisory Management Roles
  • Reducing Stress While Optimizing Your 24/7
  • Systematic Approach to Solve Problems and Make Decisions
  • The Art of Technical Writing
  • The CRM Ways to Long Lasting Relationship
  • The Fundamentals of Business Process Reengineering – Don't Wait for Something to be Broken to Fix It!
  • The Real Approach (and Human Side) of Project Management
  • The Transformative Power of Story: Using Storytelling to Lead, Sell & Influence
  • Uncover Your Communication Power Towards Greater Understanding
  • Understanding how to be LEAN (not just for manufacturing industry)
  • Writing Better Emails
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 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
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 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
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038
  • Create Digital Fill-in Form in Word & Auto Import Form Data from Excel
  • Creating Dynamic & Interactive Chart in Excel
  • Data Analysis using Dynamic & Interactive Excel Dashboard
  • Data Analysis with Excel Power Query, Data Model & Power Pivot
  • Data Analytics using Power BI Desktop Series 1 – Data Modelling and DAX Formulas
  • Data Analytics using Power BI Desktop Series 2 – Time Intelligence & Dashboard Visualisation
  • Excel 100 Tips and Techniques
  • Excel Advanced Formulas & Functions
  • Excel Data Cleansing & Building Techniques
  • Excel Pivot Table In-Depth
  • Excel VBA Series 1 – Fundamentals
  • PowerPoint Tips & Techniques
  • Word Tips & Techniques
  • 21st Century Supervisory Management Skills
  • Adapt, Evolve and Change – Embracing Changes in an Ever-Transforming Work Environment
  • Better Grammar for Business
  • Dealing with Difficult Customers Behaviour
  • Editing & Proofreading Skills
  • Emotional Intelligence Skills to Make A Difference In your Service to Customers
  • Error-Proofing Your Process, Products and Services
  • How to Talk to Anyone: The Art of Everyday Conversation
  • Keys To Increase Your Focus & Productivity At Work
  • Kickass Presentations Intensive
  • Leading with Influence:Walk, Talk And Act Like A Boss™
  • Managing Conflict and Confrontation the Less Stressful Way
  • MEMORY Empowerment Workshop for Higher Efficiency
  • Nurturing Your Creative Brain
  • Persuade Like A Lawyer
  • Persuasion and Influence Secrets
  • Proactive Failure Management using FMEA (Failure Mode Effect and Analysis)
  • Problem Solving the 8D (Disciplines) Approach
  • Quality Control Tools for Data Analysis and Problem Solving
  • Quick Guide for Supervisory Management Roles
  • Reducing Stress While Optimizing Your 24/7
  • Systematic Approach to Solve Problems and Make Decisions
  • The Art of Technical Writing
  • The CRM Ways to Long Lasting Relationship
  • The Fundamentals of Business Process Reengineering – Don't Wait for Something to be Broken to Fix It!
  • The Real Approach (and Human Side) of Project Management
  • The Transformative Power of Story: Using Storytelling to Lead, Sell & Influence
  • Uncover Your Communication Power Towards Greater Understanding
  • Understanding how to be LEAN (not just for manufacturing industry)
  • Writing Better Emails
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 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
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 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
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038

Part B.     Personal Information

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
  • Singaporean
  • Singapore PR
  • Foreigners
  • Vegetarian
  • Muslim
  • No Preference
  • No results
  • ALS Sales Team
  • Referrals (Colleagues, Friends, Family)
  • Search Engine
  • Social Media
  • Website
  • Others

Course Information

Course Code:

ALSIT-CFF

Course Fee:

S$385.00 (Nett)

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

Bring Your Own Laptop (BYOL) Course.

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 5 or more preparing for the same course, you can opt for your own closed class at a date of your choice, subject to trainer’s availability.

Please note that closed class is not customised class.

Lower course fee is also available for closed class at your premises. Request a quote.

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.

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.

More Courses By Alaster