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
Artificial Intelligence (AI) in Microsoft 365
Artificial Intelligence (AI) is in all Microsoft 365 apps - Excel, Word, Outlook, PowerPoint, Teams, and other M365 apps. In Excel, we have Analyze data on the Home tab and the ability to get data from a picture or screenshot.
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 16 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