Microsoft Excel Survey Web App

This tutorial guides the reader to use Microsoft Excel Web App. In this tutorial, we will be creating an Excel survey called 'social-media-survey'.

A) CREATING NEW DOCUMENT

1) Browse the url http://skydrive.live.com. You need to log in using your outlook.com or hotmail.com credential in order to access this page.

Click Create/Excel Survey.



2) Type the name of the workbook, social-media-survey.

B) SURVEY DIALOG WINDOW

3) A New Survey dialog window pops up.

3.1) Type the survey title.


3.2) Type the description.


3.3) Type the first question.
Click Done.



3.4) Click Add Second Question.
Click Done.



3.5) Click Add Third Question.
Click Done.


3.6) Click Add Fourth Question.
Click Done.


3.7) Click Add Fifth Question.
Click Done.

C) PREVIEW SURVEY

4) Click Save and View.


5) Preview the survey.



6) Click Share Survey.


7) A Create Link dialog window pops up.
Click Create.




8) Link is created.
Click Done.

D) EXCEL SURVEY TABLE

9) After Survey Dialog window is closed, you are back to Excel workbook.


10) In case, you forget the Survey link, you can always click on the Drop Down list at the Survey command button.
Click Share Survey.



10.1) The Shared Link is displayed again.
e.g. https://skydrive.live.com/redir?page=survey&resid=435522147A41518C!386&authkey=!AOXaSszqNUPTiKo



10.2) Click Shorten.
The link is shortened now, e.g. http://sdrv.ms/10LdsYj


10.3) Browse the shortened URL, e.g. http://sdrv.ms/10LdsYj
The address redirects back to the original URL.



E) MODIFYING SURVEY

11) Click the Drop Down list at the Survey command button.
Choose Edit Survey.


12) Click Add New Question.



13) Download sample text file  from https://sites.google.com/site/notaskydrive/home/beginner/social-media-test.txt?attredirects=0&d=1

14) Add these questions to the Survey dialog window.

15) Publish the survey again.