Monday, May 27, 2013

Extra: Excel Surveys on Skydrive [Data]

Microsoft  Office Web Apps, available to those with a SkyDrive account, enables you to create surveys to collect data online. This feature is similar to Google Forms.

To easily collect everyone’s info using Excel surveys in SkyDrive, log into your SkyDrive account and click “Create -> Excel survey”.

Name your survey and the survey designer opens in the Excel Web App. The survey designer lets you add questions, set the type of question (text, multiple choice, date, etc), and move them around. You can also show a default answer or set a question so that a response is required before submitting the survey.

When you're finished building your survey, click “Share Survey”. You will get a link that can be shared by email or otherwise.  Clicking on the link sends users directly to survey, they don’t have to sign in.

Creating a survey in the Excel Web App automatically generates a spreadsheet to store all of the results. Under the Insert tab, “Recommended Charts” will recommend useful visualizations of your data.

Watch a video: Using the Excel Survey Web App on SkyDrive


No comments:

All comments to this blog are reviewed before being published. The chances of you getting a comment including ridiculously obvious "hidden" hyperlinks to porn sites or other spam published is virtually zero. So, save your time as well as mine, and take your tawdry business elsewhere.