Forum Discussion

Kristen_McAfee's avatar
Kristen_McAfee
Copper Contributor
Jan 22, 2020

Accumulating Quiz results in Excel

I am creating multiple (optional) quizzes for our employees using Microsoft Forms.  I can upload the results to Excel but I am having trouble merging all of the quiz results into a total accumulated points per person table. Can anyone help? I ultimately plan on creating a Team to assign quizzes (I currently don't have the permission to create the team yet) . Could Teams tally all the points for me?

office 365
training
User Adoption

1 Reply

  • PascalKTeam's avatar
    PascalKTeam
    Iron Contributor
    Jan 22, 2020
    There's an append query option in Power Query, this will create one big table with all your data sources (This only works if the column structure of all quizes are the same)
    This video shows how https://www.youtube.com/watch?v=JSE9mjRzg-k You can fast forward to about 3:28

Resources