Table of Contents
Some users are create Surveys in MS Excel Online. Are you sick of having to manually gather information from different people and put it into your Excel spreadsheet? If so, you probably haven’t heard of Excel Survey yet. Excel Survey and Office Online were both made by Microsoft a few years ago. But if you’ve only used the desktop version of Office, you might not have noticed.
The survey feature is only available in the online version, which makes sense since users will need to be able to take your survey online. In the last couple of years, Office Online has become a competitor to Google Docs because it has a lot of useful apps. The good news is that if you have a working Microsoft Account, you can use the Office web apps from almost anywhere. We mentioned below are the ways to create Surveys in MS Excel Online.
Ways to create Surveys in MS Excel Online
Make the survey as short as possible
Pay attention to what’s most important. What kind of information do you need to make your case, start a campaign, or change a product? Extra questions like “good to know” ones slow down surveys and make them less useful. Don’t forget that the people taking your survey don’t really care about what you or your company find interesting. They care about how quickly they can finish the survey.
It’s important to keep in mind that more people drop out of longer surveys. So, what would your boss prefer: a long, detailed survey that only 15 people fill out, or a shorter, more focused survey that 200 people fill out? Most likely the second.
If your survey is long, help your respondents move through the different parts. Tell them what you want to ask of them. Tell them, “In this last section, we’re going to ask you to…” when they’re almost done. If your survey tool lets you (Google Forms does), show them a progress bar so they can see how much of the survey is left. And thank them for taking the time to share their thoughts.
Randomize your answer options
In surveys, there is also a first-choice bias, which is when people always click on the first answer. It comes up a lot in questions with “select all that apply” options. When you mix up your options, it makes it harder for people to choose the first one they see.
Most survey tools let you put answers like “Don’t know” or “None of the above” at the end of the list so they don’t get picked at random.
Choose the right platform for the survey
Consider how you want to use the data as well. For instance, using Microsoft Forms will allow you to export the survey results as a spreadsheet if you’re collecting a lot of data that you want to segment and analyze.
Keep your tone neutral
When you ask leading questions, you can get people to answer in a certain way. If you publish your results in a way that makes the question clear, your readers may wonder if your data are reliable.
Here’s a very bad example of what we mean: “Don’t you agree that product X is great in these ways? Yes, it’s incredible because x. Because of y, it’s great. Because of z, it’s great.”
Avoid “Yes” or “No” questions
People tend to say “yes” when asked a “yes” or “no” question (unless you ask if they’ve done something wrong). This is because of psychological bias.
Instead of directly asking, try to find out the answer in a roundabout way. For instance, you could give them a list of choices and ask if they use or know anything on the list. Don’t let people move on unless they choose the item(s) you care about. Then you can be sure that the people who answer your question will be more likely to be honest.
If you’ve tried all of these solutions and you’re still having the same problem in your Devices, you should go to their official Microsoft Excel support website for more information.
FAQ
Do forms work in Excel Online?
If you made a form in Excel Online, clicking Open in Excel (in the Responses tab) will open Excel for the web with a workbook saved to OneDrive for Business every time you click Open in Excel.
What is the best graph to use for survey results?
One of the most common types of charts used to compare survey results is the pie chart. Spread lines are used to outline each arc of a pie chart. These go from the centre of the circle to its edges.