Using Forms to capture data for analysis – Part Two

Last week I showed you how to set up a Form in MS Forms. I hope you have come down from the excitement of all that (!) and are now ready for Phase Two..

  • A – Getting your data into Excel and cleaning it up
  • B – Constructing a pivot table to summarize the data
  • C – Updating the pivot table with new data.
  • A – Getting your data into Excel and cleaning it up

B – Constructing a pivot table to summarize the data

C – Updating the pivot table with new data.

I hope you find this useful and as always I welcome any suggestions/comments and I would love to hear if you have tried it out – THAT makes my day .

If you found this blog useful, why not give it a share?

Facebook
Twitter
LinkedIn
Pinterest
Reddit
Email
Print

Leave a Reply

Your email address will not be published. Required fields are marked *

four × 4 =