Properly Create Surveys with Microsoft Forms & Export to Excel
HTML-код
- Опубликовано: 15 июл 2024
- To sign up for early access to our sponsor, GRID, visit grid.is
This video is your guide to creating and using Microsoft Forms for data collection and analysis. With Microsoft Forms you can collect data from different people with fillable forms you can control from Excel. With Microsoft Forms you can easily create surveys, quizzes and polls.
You can export the data to Excel to analyze and share the results with your audience. No programming is necessary, no VBA, no add-ons. Just a Microsoft 365 account (free or paid).
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
👩💻 What You'll Discover:
▪️ Ease of Use: Learn how Microsoft Forms simplifies data collection from surveys to feedback forms, all without any programming.
▪️ Versatile Form Elements: Explore how to include various elements like drop-downs, multiple choice, calendar dates, number checks, and even star ratings in your forms.
▪️ Seamless Excel Integration: Understand how to control and analyze your form data directly in Excel, especially if you have a Microsoft 365 account.
▪️ Form Creation Walkthrough: Follow a step-by-step guide to creating your first form, including tips on adding questions, choosing question types, and customizing your form.
We'll cover how you can use Microsoft forms to add dropdowns, multiple choice, calendar date selection, number checks, net promoter score, and even star ratings.
If you'd like to automatically connect the Excel Form results to your Microsoft Form, you need to use Excel Online. If you'd like to export the Microsoft Form results without an automatic connection, you can create your Form directly from Microsoft Forms. You have access to Microsoft Forms also with a free Microsoft 365 account.
If you'd like to collect data in Excel with a data entry form or a user form, think about using Microsoft Forms instead. It's the better way of collecting data from different people as long as it's not lots of data (for example for budget purposes). This works well for surveys, quizzes, polls and information on a smaller scale.
⯆ Read the full article here: www.xelplus.com/microsoft-forms
Check out this playlist for more Microsoft 365 videos: • Microsoft 365 (Other A...
00:00 How to Use Microsoft Forms
01:19 How to Get Started with Microsoft Forms
01:50 Automatic Connection between Excel and Microsoft Forms
02:58 Create Data Entry Form with Microsoft Forms
04:10 Star rating in Microsoft Forms
04:35 Choice in Microsoft Forms
05:08 How to add a drop-down to Microsoft Forms
06:10 Date picker with calendar pop-up
06:30 Add a text box and validate numbers
06:50 Add a Likert scale to Microsoft Forms
07:15 Net Promoter score in Microsoft Forms
07:50 How to Add a Theme to Microsoft Forms
08:09 How to Share a Data Entry Form with Microsoft Forms
09:24 How to Fill Out a Data Entry Form
10:34 Analyze the Responses from Microsoft Forms in Excel
13:39 Grid
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
This video was sponsored by Grid.
#excel #Microsoft365
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
Hi, I have question let say I have a question to upload excel file, now how to heve this uploaded files into my excel as Data rows it's shown as links I want a way to read from upload and insert as rows
I've recently had to create more and more forms to collect opinions/preferences, basic data and have had so much trouble getting this accomplished. After watching a couple of hours worth I can across this one and it is a time saver! The tutorial is so easy to follow at a nice pace with great explanation. Thank you, thank you!
As usual, thanks again, Leila.
When I come to RUclips to explore and learn about a new topic - in this case, MS365 and MS apps - it should be confusing because there are (literally) hundreds (if not thousands) of quality tutorials.
But there are only a handful of educators who are of platinum+++ standard, whose tutorials I know will give me exactly what I need. Every time, without fail.
You are right the top of the tree, and thank you for the obvious effort you put into this.
if I sound extra-grateful today, it is because MS Forms is maybe their poorest documented product, and many non-MS tutorials only regurgitate the basics.
It is so rewarding to arrive here and listen to your crystal clear presentation on the Forms-Excel relationship and link.
Just brilliant. ☮🙏
I have had to learn this in the past on my own so this is great to see a well designed tutorial on this. Thank you! :)
Great to hear! Thank you!
@@LeilaGharani
Hi, I'm from Iran 🇮🇷
I have a problem
I want to know how can we convert the Xlsm file to Exe or something like that
Others can use this app without Excel.
I searched for this about 8months
Can you help us??
Thank you so much for making this tutorial! My organization has been using a system of paper surveys for over ten years and this is going to save HUNDREDS of hours of work transferring them into excel and is infinitely simpler to use!
5:33 copy and paste multi-row data as individual answer options - such a time saver! In this example a list of countries is easily transported to MS forms - without the need to individually copy & paste each country name (=cell).
Every time I watch your video, I end up learning something new and today was no exception! Just when I thought, I knew Forms enough, I was surprised by some things I never noticed! Thanks for enlightening! 😊👍 BTW, up next is what? a video on Grid documents? Would love to learn that from you!
I am currently moving our company to Teams and using these apps to connect our organization. Your videos have been such a huge asset for me! Thank you!
I started watching your video from yesterday and I'm just loving all of them....... You're doing just great work
Keep it up Good bless you 👍
I love and appreciate the timeliness of your videos, Leila. Sometimes I feel like we're on a similar learning journey, but that you're just ahead of me, so that I (and obviously everyone else) reaps the benefits of your willingness to share what you know and have learned. Greatly appreciated, and don't stop learning and sharing!
There will be more :)
Wow, this is so amazing. Just what I was looking for to create a survey.
You made it look so easy.
Thank you Leila.
You're very welcome!
What a useful concept! thank you, Leila! It was my nightmare for more than 3 years that started in 2012 in the computer world for my small business.
still watching your videos leila i'm not getting bored about microsoft forms in this pandemic situation and learning a lot more thank you so much ....... hope you do more and more videos further ..and i can't wait to watch it................... thank you once again 👍👍🙏🙏
just conducted an experiment and it was really fantastic!!!. Thanks Leila....Such a darling!!
Leila, unbelievable well presentations. I didn’t learn anything in school, despite thousands owed in student loans, compared with what I learned from you. Thank you much!!!
Wow, creating Forms from Excel online is really a neat trick! I am going to use it for my next project.. Thanks a lot!
This is great! I had not realized the automatic connection when we use Excel online.
I tried it on my own yesterday (8 Dec) for the first time and I did it from Forms first, I couldn't get it shared to who I wanted it to go to. I thank you for this video, good job.
Thank you very much. You are a wonderful expert in what you are doing, you understand the needs of common users, and you are an amazing trainer.
Very good presentation, please continue doing the things you do !! Full appreciation !
Das war einmal wieder perfekt erklärt, und obwohl ich Forms gut kenne habe ich wieder etwas gelernt! Vielen Dank!
Thank you so much for your tutorial videos! It's so easy to understand and apply on my own.
Thank you for your explanation. Other videos explain how to make forms, how they function, all their features, they did not explain where the data goes, how to use the collected data, where it connects to anything least of all Excel. When I first saw MS Forms I thought "ah-hah similar to Google Forms which ties into Google Sheets." Nobody explained the use of Excel, at least the videos I watched. Your explanation is a breath of enlightenment. Yes, yes, I first should have looked for your video. Thank you!
This has been the closest thing to a revelation I have ever had. Fantastic feature!! Thank you, Leila. You rock, as always!
Glad it was helpful Miguel! Thanks for dropping by.
I love all you videos, Thanks for your efforts!!!!!!
Many thanks Dear Leila for sharing I'm learning so much from you, you are AMAZING
This is a great tutorial on MS Forms, many thanks Leila!
A great session by excellent instructor! Thank you Leila.
Greetings from Vienna...
I had learned a lot from you. You are the best in explaining things. Your presentation skills and ability to put important points in a concise manner, that what I admire a lot. We can try it to take online quiz as well.
Thank you, I appreciate that!
Thank you, Leila. your video is great and to the point
Now Leila!, You know you should have SELECTED 20 for the answer about your Excel skills!! 😁😋
I agree with the comments below - here I am needing to create my first survey form, and (as always), here you are boosting my knowledge level on the subject!
I appreciate you, Leila, WE ALL appreciate you - you're SAVING LIVES out here on these Microsoft Office streets - PROPS!
I am a BIG fan of yours!! Incredibly amazing presentation and I NEVER get bored of the topics you share and teach!! BEST OF LUCK to you because you deserve all the best!!
Thank you! You too!
Your videos are so good and helpful!, thank you for your time and work.
You are such a blessing to humanity....Thank you
Great tutorials. I love the way they flow.
I’ve never used Forms before, this was great info. Thanks Leila!
You're so welcome Chris!
That was indeed a great tutorial Leila. Thank you for making this video. There is one more option in MS forms that is option to upload/attach file to the form. Most of the people don't use it even though they need to. It will be nice if you create another video and cover that part as well. All the best for the future.👍👍
It only lets you add media (image of video) these days.
Thank you Leila, great video. Learned some great tips there.
Hmmm.., The combination of Forms and Grid is very interesting. Thanks Leila
Thanks (as usual) for the great content! You Rock!!!
I have been learning from your videos for some time now....thank you for what you do!
You are so welcome, Cliff!
Simply brilliant! Thank you Leila
I love the way you discuss in this video.
This is a great lesson and will be extremely useful. Thank you!
Glad to hear that!
Thank you Leila. You saved me. Great video! Love you!
Didn't know I could do this! Thanks!
learned a lot from you leila in microsoft forms 👍👍👍
Great tutorial! Thank you!
Love the animations and transitions
Thank you, that was really informative. The way you explain is simple and very much understandable ❤️
You are so welcome!
Thanks a lot for an excellent coaching.
Thank you very much.. i am into market research domain and working with other survey platforms but today because of you i came to know this an another beautiful option.. thank you..
It is very useful to get responses from people via Microsoft Forms in secure manner. Users also have good options to analys the data through Excel. That make easier for selection of better responses. Thanks for the tutorial Leila.
You're very welcome!
Thank you very much my dear Leila, this was very helpful, simple, and clear. وفقك الله
It's good experience to use forms effectively and nicely explained.
Heavens bless you for this video. It has helped me a lot. Thanks a lot.
Was using Office 365 E5 from past 4 years but never knew this was there!! And we were using manual entry forms all along 🙃
Thanks Liela !!
Hope it will come in handy for you.
fantastic/concise/ informative Great video! Your explanations were clear and easy to understand. Keep up the excellent work!
Every video is amazing tips has been sharing.. Thank you so much
I love this tutorial! So concise and organized in the explanation and all the steps. Thank you!
Glad it was helpful!
Hi Leila. Thanks for this Forms demo and good tips on how to start and the options available. Always interesting and useful information at your channel :)) Thumbs up!!
Thank you Wayne.
Excellent presentation Leila, thank you. I had no idea this was available in Excel so opted to use Google Sheets instead for a survey.
Glad it was helpful!
Super useful! Thank you!
This time, before you I have learned ms forms.. Expecting Power Automate complete course from you.. Thanks for this video
You did a good job, your explanation is clear and useful
This was super helpful. thanks.
GREAT WORK ! YOU POST THE BEST CONTENT !
Thanks Leila... now I'm aware on Form functionalities much better than earlier..
Great to hear!
Brilliant! Thank you!
great video, great explanation
a lot of thanks.
Thank you. Great video.
Great video, it was brief and very easy to understand.
I have learned so much from you. Thank you for sharing.
You are so welcome, Bobby!
Thank you for the tutorial
Hi Leila, your videos are awesome and a great treasure of knowledge. Thanks a lot for the great content you keep on sharing with us.
Is it possible to create dependent lists in MS Forms?
Another great sharing Leila! I guess, im not the only whom didnt get Forms from the tab from Excel Online.
Excellent structure and detail. You are awesome.
Your videos are always perfectly designed and very helpful. Thanks a lot!
I do have a question on Forms: Is it possible to send a response notification to different people, depending on the answers given? It would be great to know. I’ve been trying to fond it in Power Automate but I do need help! If you know an answer, I would really appreciate a tutorial 😊
Thank you, I have 365 account, but creating forms directly, not from excel. Then I downloaded the responses in excel, copy and paste them in my master excel. I was not aware of crating forms from excel itself. Thanks for sharing.
Thank you very much for your useful video
As a novice I was able to follow along and create my first MS Forms document. Now that it's created it has to go to multiple administrators for approval. I'm off to see if there's a video, by you of course, to automate the flow of approvals. Fingers Crossed
Engaging, informative and nicely paced... 👍
Extremely Useful ... thumps up .... thanks Leila
Thank you Leila!
thank you for sharing knowledge...👍
Thank you very clear informations :). I will try Grid also :)
This is a very good video for beginners who don't have any idea about Microsoft Forms.
Thanks for sharing this Leila - it was well presented! One would be also interested in how best or smartest to analyze the data towards presenting from the created survey via say pivot or otherwise?
This is incredible!
Leila... U are the best!!
Super helpful video!!
Fantastic video!
Dear Madam, Thank you for making this video. Your videos are always perfect
Looks like fun, thank you.
You’re a gem!
Asusual informative and good tutorial thanks
Leila ,thanks for very interesting lesson!
My pleasure!
you are the best , thank you dear.
It was really lovely . Thanks for the knowledge & understanding :)
My pleasure 😊
very good video, helped me a lot.