Although Word is most commonly used for creating documents, it can also be used for capturing data like a form. Word Forms do not require any programming knowledge. These are easy to create and will work across ALL versions of Word.
The Need for Word Forms
This is very useful for conducting quick surveys or quizzes where you want to control the responses. Of course, there are more sophisticated methods and tools available for bother these scenarios, Word is familiar to everyone and almost guaranteed to be available on every desktop. Hence it is a compelling option even today (2017).
Continue reading Using Word Forms
The more I work with customers, the more I realize that data quality is still a very big problem. Data Validation in Excel is an effective solution to this problem. Here is a short guide for you. Reading time 12 min.
Continue reading Prevent data-entry mistakes using Data Validation in Excel
Capturing data from multiple people without using Excel:
This is a single most useful feature of SharePoint. No programming. Just create a list and get started. Much better than using Excel. Start using it NOW!
SharePoint 2013 update: Datasheet view is now called Quick Edit. It does NOT require Access to be loaded and it works on all browsers.