Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
Checkout the full article and download the file at: http://www.excelcampus.com/pivot-tables/analyze-survey-data-in-excel/
In this third part of the series we learn how to use Pivot Tables and formulas to analyze the multiple choice survey data. We also create a chart that shows the percentage of total responses for each item (choice) in the survey question.
Please subscribe to my free email newsletter to get more Excel tips and tutorials like this. http://www.excelcampus.com/newsletter
PART 2: https://youtu.be/h-sKEPEvwZ8
PART 3: https://youtu.be/NBgL8ItVdKY
00:00 Introduction
00:41 Pivot Tab les
05:42 Conclusion