Office Tips & Tricks: Analyse data from your Microsoft ...
Office Tips & Tricks: Analyse data from your Microsoft Form
Are you a Microsoft Forms convert yet? If not, why not have a go at creating and using a Microsoft Form either for a quiz or survey. Find out how to get started by reading our blog post from 15 March.
If you have had a go with Microsoft Forms, you might be interested in further exploring the analytics. After all, there’s not much point sending out a quiz or survey if you aren’t going to analyse the answers in some way. To get started viewing analytics, from your Survey or Quiz, click on the Responses tab.
Top level summary:
You can see summary data, using latest responses, pie charts etc. Click Details beside any question to see more information.
View results per respondent:
Click View results to scroll through full responses from each respondent in turn.
Export results to Excel:
Simply click the Open in Excel button, to instantly download your results already populated in a handy Excel table.
Print a summary of the results:
Click the three dots, then select Print summary.
Did you find this Tip & Trick useful?
Why not let us know using the comments? And feel free to share our post with your colleagues.
Further support: NTU staff and students can visit the Office Central learning room for more help on using Microsoft Office 2013 and Office 365/OneDrive by clicking here. You will need to log in to NOW to view the learning room. (Please note: Office Central is an internal resource only accessible by NTU staff and students).