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 .