FREE
SOFTWARE - Microsoft Excel Surveys
To create survey forms, you use a OneDrive account.
If you have another Microsoft Service
account such as Hotmail, Outlook or Live, you may be unaware but you’re already
good to go!
The application is specially designed for making
surveys and questionnaires.
In the initial stages of starting up a business we
might use such forms for market research or gather information from our
potential target audience.
Once we’re up and running surveys to collect and analyse
customer feedback are critical for future planning.
- Log-in to say your Hotmail/Outlook account as though to view your email/inbox, note the button at the top left of the screen
Select
this button to see icons representing free online software (& storage)
available:
- In this example we shall choose OneDrive and then Create and Excel Survey
- Give an appropriate title to the survey and then begin the first question.
When you click on the question,
customisation options will appear.
- Here, you have to enter details about the question. You can write more description about the question.
- Select the type of response you want. You can either select from options like text, paragraph text, multiple choice, number, date and time and Yes / No.
- Then click on Done
The layout of the form will change
as per the type of response you select.
- Select Add New Question. Repeat the process with as many questions as you wish.
- Once done, click on the 'Share' button if you want to share the survey via a link. You can send the link to email address. OneDrive also offers to shorten the link for easy sharing.
- If you don't want to share the form you can straightway save the form. Click on 'Save and View' button.
Select Create Link
And then select Shorten Link
(Anyone familiar with Twitter and the
restriction of 140 characters per tweet will understand why we shorten the
link!)
At this point I would highlight the
link and copy it, though once you are familiar with OneDrive you will soon
discover how to view all your online documents and how to create a link to
share them with others determining permissions such as view or edit, at any
time.
When users complete the survey the
results will automatically be stored in the associated spreadsheet, which you
can view, analyse (summarise, sort, filter, etc) or produce graphical
representations of the responses.
From spreadsheet view note the
options to View, Edit, Delete or Share the survey.
This is what others
would see if I sent this link now:
Google Forms (which is also free) offers a
similar method of creating forms, and allows you to ‘embed’ the form in a
website. Many of the Contact Us forms
which you see on websites are created in this way.
A
Google form also comes with the facility to set an alert/send an email (to
yourself), when a form is completed and the spreadsheet updated.