Analyze Results from Microsoft FORMS POLLS in Excel | Watch Chris Work

Posted on:  05/02/2022
Analyze Results from Microsoft FORMS POLLS in Excel | Watch Chris Work

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

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

Excel functions to analyze data

Recent Excel Articles

Excel Sorting Tips with Chris Menard on January 24, 2023

Excel Sorting Tips with Chris Menard on January 24, 2023

Chris Menard will be live on YouTube and Linked showing Sorting Tips in Excel on January 24, 2023.

Excel - Convert Seconds to Minutes and Seconds - Watch Chris Work!

Excel - Convert Seconds to Minutes and Seconds - Watch Chris Work!

Frequently we have data in one format but need to convert it to another. Today's example is I have a column on seconds for the length of videos. I want to show minutes and seconds with a colon in between the minutes and seconds.

TOP 5 Excel Features Released in 2022

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

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

Excel Chart Maps used with the Geography Data Type

Excel Chart Maps used with the Geography Data Type

Combine the Geography Data type with a Chart Map. The Geography Data type is located on the Data tab, and Chart Map is on the Insert tab with the other chart types.

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

For potential homeowners, 1 year makes a HUGE difference. In 2021, we saw some of the lowest mortgage rates in the last 30 years. In July 2021, the average rate on 30-Year Fixed-Rate Mortgages was 2.87% (source FreddieMac). Today, July 2022, we are looking at rates around 5.8%.

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