Properly Create Surveys with Microsoft Forms & Export to Excel
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
Пікірлер: 512
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
@shimaaal_harbi4155
4 ай бұрын
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 KZread 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. ☮🙏
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!
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! :)
@LeilaGharani
3 жыл бұрын
Great to hear! Thank you!
@imangoli1224
3 жыл бұрын
@@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??
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!
@LeilaGharani
3 жыл бұрын
There will be more :)
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 👍
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!
Wow, this is so amazing. Just what I was looking for to create a survey. You made it look so easy. Thank you Leila.
@LeilaGharani
3 жыл бұрын
You're very welcome!
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!!!
This has been the closest thing to a revelation I have ever had. Fantastic feature!! Thank you, Leila. You rock, as always!
@LeilaGharani
3 жыл бұрын
Glad it was helpful Miguel! Thanks for dropping by.
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!
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 👍👍🙏🙏
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.
just conducted an experiment and it was really fantastic!!!. Thanks Leila....Such a darling!!
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.
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!!
@LeilaGharani
3 жыл бұрын
Thank you! You too!
A great session by excellent instructor! Thank you Leila. Greetings from Vienna...
I love all you videos, Thanks for your efforts!!!!!!
Wow, creating Forms from Excel online is really a neat trick! I am going to use it for my next project.. Thanks a lot!
Very good presentation, please continue doing the things you do !! Full appreciation !
You are such a blessing to humanity....Thank you
Thank you, Leila. your video is great and to the point
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.
@LeilaGharani
3 жыл бұрын
Thank you, I appreciate that!
Great tutorials. I love the way they flow.
This is great! I had not realized the automatic connection when we use Excel online.
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!
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!
Das war einmal wieder perfekt erklärt, und obwohl ich Forms gut kenne habe ich wieder etwas gelernt! Vielen Dank!
Your videos are so good and helpful!, thank you for your time and work.
I love the way you discuss in this video.
I love this tutorial! So concise and organized in the explanation and all the steps. Thank you!
@LeilaGharani
4 ай бұрын
Glad it was helpful!
I’ve never used Forms before, this was great info. Thanks Leila!
@LeilaGharani
3 жыл бұрын
You're so welcome Chris!
I have been learning from your videos for some time now....thank you for what you do!
@LeilaGharani
Жыл бұрын
You are so welcome, Cliff!
Thanks a lot for an excellent coaching.
Thank you Leila. You saved me. Great video! Love you!
Didn't know I could do this! Thanks!
Thanks (as usual) for the great content! You Rock!!!
You did a good job, your explanation is clear and useful
Great video, it was brief and very easy to understand.
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.
It's good experience to use forms effectively and nicely explained.
This is a great lesson and will be extremely useful. Thank you!
@LeilaGharani
3 жыл бұрын
Glad to hear that!
Hmmm.., The combination of Forms and Grid is very interesting. Thanks Leila
This was super helpful. thanks.
Super useful! Thank you!
Simply brilliant! Thank you Leila
learned a lot from you leila in microsoft forms 👍👍👍
Thank you Leila, great video. Learned some great tips there.
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.👍👍
@qwandary
8 ай бұрын
It only lets you add media (image of video) these days.
Thank you very much my dear Leila, this was very helpful, simple, and clear. وفقك الله
Excellent structure and detail. You are awesome.
Thank you for the tutorial
Thank you. Great video.
Thank you, that was really informative. The way you explain is simple and very much understandable ❤️
@LeilaGharani
3 жыл бұрын
You are so welcome!
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!
Great tutorial! Thank you!
Love the animations and transitions
Brilliant! Thank you!
fantastic/concise/ informative Great video! Your explanations were clear and easy to understand. Keep up the excellent work!
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.
@LeilaGharani
3 жыл бұрын
You're very welcome!
GREAT WORK ! YOU POST THE BEST CONTENT !
Thank you very much for your useful video
Heavens bless you for this video. It has helped me a lot. Thanks a lot.
Engaging, informative and nicely paced... 👍
Every video is amazing tips has been sharing.. Thank you so much
Thanks Leila... now I'm aware on Form functionalities much better than earlier..
@LeilaGharani
3 жыл бұрын
Great to hear!
Extremely Useful ... thumps up .... thanks Leila
I have learned so much from you. Thank you for sharing.
@LeilaGharani
3 жыл бұрын
You are so welcome, Bobby!
Super helpful video!!
Fantastic video!
always impeccable teaching. your content are excellent
@LeilaGharani
Жыл бұрын
I appreciate that!
Excellent presentation Leila, thank you. I had no idea this was available in Excel so opted to use Google Sheets instead for a survey.
@LeilaGharani
3 жыл бұрын
Glad it was helpful!
It was really lovely . Thanks for the knowledge & understanding :)
@LeilaGharani
Жыл бұрын
My pleasure 😊
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!!
@LeilaGharani
3 жыл бұрын
Thank you Wayne.
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
Excellent. Thank you Madam.
very good video, helped me a lot.
This is a very good video for beginners who don't have any idea about Microsoft Forms.
Dear Madam, Thank you for making this video. Your videos are always perfect
This time, before you I have learned ms forms.. Expecting Power Automate complete course from you.. Thanks for this video
Thank you Leila!
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 !!
@LeilaGharani
3 жыл бұрын
Hope it will come in handy for you.
Your Excel skill is 7!! thats so humble.. loved the video as always:)
@LeilaGharani
3 жыл бұрын
Thank you so much!!
You amazing! As always 🙏
Really awesome.. thank you
thank you for sharing knowledge...👍
Leila ,thanks for very interesting lesson!
@LeilaGharani
3 жыл бұрын
My pleasure!
Leila... U are the best!!
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 very clear informations :). I will try Grid also :)
amazing .... totally new for me
Asusual informative and good tutorial thanks
This is incredible!
Very useful video congratulation Leila
Looks like fun, thank you.
You’re a gem!
I do like your tutoring 👍👍