Office Tips & Tricks: Analyse data from your Microsoft ...

Office Tips & Tricks: Analyse data from your Microsoft Form

Using cell comments in Excel (3)

whiteRow

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.

whiteRow

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.
whiteRow
forms 1

 

Top level summary:

You can see summary data, using latest responses, pie charts etc.  Click Details beside any question to see more information.

whiteRow
forms 2

whiteRow

View results per respondent:

Click View results to scroll through full responses from each respondent in turn.

whiteRow
view results

whiteRow

Export results to Excel:

Simply click the Open in Excel button, to instantly download your results already populated in a handy Excel table.
whiteRow
open in excel

whiteRow

forms 4

whiteRow

Print a summary of the results:

Click the three dots, then select Print summary.

whiteRow
forms 5

whiteRow

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).


Leave a comment

Your email address will not be published.

Required fields are marked with required


required

required

required