Analyze Results from Microsoft FORMS POLLS in Excel | Watch Chris Work
Posted on: 05/02/2022
I recently spoke at the Administrative Professional Day Conference hosted by the University of Georgia. After reviewing my survey results in Microsoft Forms, I realized I needed to analyze the survey data. Forms results are immediately available in Excel.

Microsoft Forms - Analyze data in Excel
After opening in Excel, I did the following functions in Excel: average, max, min, median, large, and trimmean functions. I added a helper column to calculate the time required to take the survey. Finally, I tested a few of the functions to ensure they were correct. This is something I needed to do so you actually get to see me work. I'm going to start a series called Watch Chris Work.
YouTube Video
Video Chapters
-
00:00 Introduction
-
03:45 Load results in Excel
-
04:08 Add helper column
-
06:56 Find maximum value
-
07:03 Find minimum value
-
07:16 Find average time
-
07:25 Find median time
-
08:18 Find top values
-
10:44 Average excluding
-
12:14 Test the formulas
-
13:19 Closing remarks
Recent Microsoft Forms articles
-
Microsoft Forms - Show Progress Bar on Surveys, Polls, and Quizzes
Microsoft Forms is an excellent tool for creating surveys, quizzes, and polls. Did you know you can add a progress bar to a Forms survey or quiz? A progress bar makes it easy for users to see how many pages they have left to complete.
-
Upload Files in Microsoft Forms - New Feature!
Microsoft Forms allows you to create a survey with multiple question types. One of the NEW question types is the "File upload". So users can now upload files in a survey! This is an awesome feature. The files are stored in a SharePoint folder and automatically marked with the person's name that uploaded the files. You can specify the number of files someone can upload and the maximum file size.

Excel functions to analyze data
Recent Excel Articles
TOP 5 Excel Features Released in 2022
Microsoft keeps rolling out awesome new features for M365 users. Many of the new features hit Excel in 2022. This video covers my top five favorite features in Excel from 2022.
Excel 7 Easy Tips Everyone Should Know
Here are 7 amazing, time-saving tips or functions you need to use if you're moving from an Excel beginner to a more advanced level. I walk you through 7 ways to move data, Autosum, Autofill, ways to create tables, and more super-useful functions
Chris Menard
Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 15 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube
Categories