With the cloud technology, you can create a survey with Excel OnLine and share it to your audience.
Survey made with Excel
Open Excel Online
To create a survey, you must open a new workbook with Excel Online. To do that, you must be connected to your personal OneDrive or SharePoint.
Then you click on New > Excel workbook
Create a survey
To create your survey, activate the menu Insert > Insert > New Survey
A new window shows you the 3 states of the survey
- Share with your audience
- View the result of the answers
You click on Got it and you will insert your question
Insert your questions
First your have to enter a title to your survey and give a description. It's not compulsory but it's better.
Then you select the box "Enter your first question here" and click on the gear. A new dialog box appears with many options for the questions.
Type of questions
- Paragraph Text
- Yes / No
In function of your selection, the options for the question are different. Here, for the option "Choice" we have filled the different answer for the question.
Then simply click on the "Add a new question" to enrich your questionnaire
Reorder your questions
You can easily change the orders of your questions with a drag and drop
View the result of your creation
And you see this screen
Now, once you click on Share Survey, you have a dialog box with a link
In this example, the link is:
View the results
Of course, for you at the end, what you want is to see the answers.
Return to your OneDrive and open the Documents folder. There you will find among your files, an Excel workbook with the attribute Survey.
Just open the file to see the answers to your questions or embedded it in a webpage. If you have answer to the survey, relaod this page to see your answer display in the next workbook.