Excel 2024: Surveys & Forms in Excel

December 17, 2024 - by Bill Jelen

I often start my live Excel seminars off by asking you to point your cell phone camera at a giant bar code I have projected on the screen. That QR code leads to a three-question survey. Answers automatically flow into my Excel worksheet and those answers get used in the afternoon demo of 3D Maps.

Start at Forms.Office.com.

A browser will open and you can build your form. Click New Question. Forms offers support for seven question types. Don't miss the useful Ranking or Likert types hidden behind the three dots.

As you are building survey questions, there are four question types visible: Choice, Text, Ranking, Date. But if you click on the three dots, you have more choices such as Raking, Likert, and New Promoter Score.

Type the question and possible answers.

With a multiple choice question, type the question and some answers. You can Add Option to increase the number of possible answers. Use Add Other Option to allow people to type their own answer.

Branching is now supported: Click the 3 Dots icon in the top right corner of Forms.Office.Com.

When you are done with all questions, click Share in the top right corner. You can share via a link, or via e-mail, or using the QR Code. Try it: point your cell phone camera at the bar code on the right.

On the Share tab, you can generate a link, download a QR Code, get embed code, or e-mail the survey to recipients.

This article is an excerpt from MrExcel 2024 Igniting Excel

Title photo by BoliviaInteligente on Unsplash