How to Summarize Survey Results in Excel

In this Excel tutorial, you will learn how to create survey and summarize survey results in Excel.

These following steps will easily make you summarize surveys.

1. Layout the headers

Surveys headers

Note: Response, Friendly, and Waiting are topics that have sub-topics (low and high). If someone checked 2 on a scale of 1 – 5, then that will get into low, and 3 upward will be on high. The overall is how many people participated in the survey.

Collect the survey results in a table

2. Input the answer as they were answered by survey's participants.

Surveys participants

3. Click on an empty cell in a, and write Total.

Surveys total

4. Highlight all the cells with values, exclusive survey nr and session nr.

Surveys highlight cells

How to calculate survey results?

5. Click autosum

Surveys autosum

6. Highlight the results and press CTRL + B.

Surveys keyboard shortcut

In conclusion, we have just summarized how three hundred people sees the customer service' performance.