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

  • @LeilaGharani
    @LeilaGharani4 ай бұрын

    Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

  • @shimaaal_harbi4155

    @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

  • @deitragomez7365
    @deitragomez7365 Жыл бұрын

    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!

  • @ishrashad
    @ishrashad4 ай бұрын

    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. ☮🙏

  • @biggeekreview
    @biggeekreview Жыл бұрын

    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!

  • @TylerStanczak
    @TylerStanczak3 жыл бұрын

    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

    @LeilaGharani

    3 жыл бұрын

    Great to hear! Thank you!

  • @imangoli1224

    @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??

  • @t3geek
    @t3geek3 жыл бұрын

    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

    @LeilaGharani

    3 жыл бұрын

    There will be more :)

  • @vishalmathur8624
    @vishalmathur86243 жыл бұрын

    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 👍

  • @vijayarjunwadkar
    @vijayarjunwadkar3 жыл бұрын

    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!

  • @anillpatel
    @anillpatel3 жыл бұрын

    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

    @LeilaGharani

    3 жыл бұрын

    You're very welcome!

  • @florin1504
    @florin15042 жыл бұрын

    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!!!

  • @miguelencanarias
    @miguelencanarias3 жыл бұрын

    This has been the closest thing to a revelation I have ever had. Fantastic feature!! Thank you, Leila. You rock, as always!

  • @LeilaGharani

    @LeilaGharani

    3 жыл бұрын

    Glad it was helpful Miguel! Thanks for dropping by.

  • @cthru2k
    @cthru2k3 жыл бұрын

    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!

  • @gracemark5995
    @gracemark59953 жыл бұрын

    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 👍👍🙏🙏

  • @pooyannaghsh6274
    @pooyannaghsh62743 жыл бұрын

    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.

  • @samuelkodjoe1645
    @samuelkodjoe16453 жыл бұрын

    just conducted an experiment and it was really fantastic!!!. Thanks Leila....Such a darling!!

  • @olga.m1162
    @olga.m1162 Жыл бұрын

    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.

  • @moeeeeeeeekdkdkd
    @moeeeeeeeekdkdkd3 жыл бұрын

    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

    @LeilaGharani

    3 жыл бұрын

    Thank you! You too!

  • @bbashur
    @bbashur Жыл бұрын

    A great session by excellent instructor! Thank you Leila. Greetings from Vienna...

  • @remediationdepartment4332
    @remediationdepartment4332 Жыл бұрын

    I love all you videos, Thanks for your efforts!!!!!!

  • @MrEagle1982
    @MrEagle19823 жыл бұрын

    Wow, creating Forms from Excel online is really a neat trick! I am going to use it for my next project.. Thanks a lot!

  • @bluescream7463
    @bluescream74633 жыл бұрын

    Very good presentation, please continue doing the things you do !! Full appreciation !

  • @adenigba
    @adenigba2 жыл бұрын

    You are such a blessing to humanity....Thank you

  • @banderdammam9068
    @banderdammam9068 Жыл бұрын

    Thank you, Leila. your video is great and to the point

  • @MathematicsClasses001
    @MathematicsClasses0013 жыл бұрын

    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

    @LeilaGharani

    3 жыл бұрын

    Thank you, I appreciate that!

  • @cherifbelfekih7545
    @cherifbelfekih75452 жыл бұрын

    Great tutorials. I love the way they flow.

  • @CeliaAlvesSolveExcel
    @CeliaAlvesSolveExcel3 жыл бұрын

    This is great! I had not realized the automatic connection when we use Excel online.

  • @mohammedalbaqaawi8548
    @mohammedalbaqaawi85483 жыл бұрын

    Many thanks Dear Leila for sharing I'm learning so much from you, you are AMAZING

  • @daveys
    @daveys8 ай бұрын

    This is a great tutorial on MS Forms, many thanks Leila!

  • @ricdonato4328
    @ricdonato43282 жыл бұрын

    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!

  • @andreaschunzel4672
    @andreaschunzel46722 жыл бұрын

    Das war einmal wieder perfekt erklärt, und obwohl ich Forms gut kenne habe ich wieder etwas gelernt! Vielen Dank!

  • @rodrigogarciasharpe5308
    @rodrigogarciasharpe53082 жыл бұрын

    Your videos are so good and helpful!, thank you for your time and work.

  • @caselcortez8071
    @caselcortez807110 ай бұрын

    I love the way you discuss in this video.

  • @called7bn
    @called7bn4 ай бұрын

    I love this tutorial! So concise and organized in the explanation and all the steps. Thank you!

  • @LeilaGharani

    @LeilaGharani

    4 ай бұрын

    Glad it was helpful!

  • @chrism9037
    @chrism90373 жыл бұрын

    I’ve never used Forms before, this was great info. Thanks Leila!

  • @LeilaGharani

    @LeilaGharani

    3 жыл бұрын

    You're so welcome Chris!

  • @cliffmorgan9120
    @cliffmorgan9120 Жыл бұрын

    I have been learning from your videos for some time now....thank you for what you do!

  • @LeilaGharani

    @LeilaGharani

    Жыл бұрын

    You are so welcome, Cliff!

  • @MrSaylom
    @MrSaylom Жыл бұрын

    Thanks a lot for an excellent coaching.

  • @kiacarens
    @kiacarens2 жыл бұрын

    Thank you Leila. You saved me. Great video! Love you!

  • @stephenfarrell6794
    @stephenfarrell67943 жыл бұрын

    Didn't know I could do this! Thanks!

  • @MrPeru510
    @MrPeru5102 жыл бұрын

    Thanks (as usual) for the great content! You Rock!!!

  • @gmmichel7
    @gmmichel72 жыл бұрын

    You did a good job, your explanation is clear and useful

  • @diegoloredobecerra7124
    @diegoloredobecerra7124 Жыл бұрын

    Great video, it was brief and very easy to understand.

  • @bajanbear
    @bajanbear3 жыл бұрын

    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.

  • @tusharpatil2989
    @tusharpatil29893 жыл бұрын

    It's good experience to use forms effectively and nicely explained.

  • @leoric3081
    @leoric30813 жыл бұрын

    This is a great lesson and will be extremely useful. Thank you!

  • @LeilaGharani

    @LeilaGharani

    3 жыл бұрын

    Glad to hear that!

  • @mattschoular8844
    @mattschoular88443 жыл бұрын

    Hmmm.., The combination of Forms and Grid is very interesting. Thanks Leila

  • @shimamyina246
    @shimamyina2462 жыл бұрын

    This was super helpful. thanks.

  • @thedish5
    @thedish53 жыл бұрын

    Super useful! Thank you!

  • @jared1122
    @jared11222 жыл бұрын

    Simply brilliant! Thank you Leila

  • @gracemark5995
    @gracemark59953 жыл бұрын

    learned a lot from you leila in microsoft forms 👍👍👍

  • @TheQureshy
    @TheQureshy3 жыл бұрын

    Thank you Leila, great video. Learned some great tips there.

  • @simpliexcel1289
    @simpliexcel12893 жыл бұрын

    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

    @qwandary

    8 ай бұрын

    It only lets you add media (image of video) these days.

  • @Jawad1058
    @Jawad10582 жыл бұрын

    Thank you very much my dear Leila, this was very helpful, simple, and clear. وفقك الله

  • @andiesmithe1598
    @andiesmithe15982 жыл бұрын

    Excellent structure and detail. You are awesome.

  • @pankajparadkar8298
    @pankajparadkar82982 жыл бұрын

    Thank you for the tutorial

  • @markturner6755
    @markturner67553 жыл бұрын

    Thank you. Great video.

  • @foxyb8153
    @foxyb81533 жыл бұрын

    Thank you, that was really informative. The way you explain is simple and very much understandable ❤️

  • @LeilaGharani

    @LeilaGharani

    3 жыл бұрын

    You are so welcome!

  • @williambell4591
    @williambell4591 Жыл бұрын

    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!

  • @Przemasok
    @Przemasok3 жыл бұрын

    Great tutorial! Thank you!

  • @erikapineo6699
    @erikapineo66993 жыл бұрын

    Love the animations and transitions

  • @sharacy889
    @sharacy8893 жыл бұрын

    Brilliant! Thank you!

  • @hamedriyahyzadeh8414
    @hamedriyahyzadeh841411 ай бұрын

    fantastic/concise/ informative Great video! Your explanations were clear and easy to understand. Keep up the excellent work!

  • @odelakumar06
    @odelakumar062 жыл бұрын

    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..

  • @nipunkavinda8254
    @nipunkavinda82543 жыл бұрын

    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

    @LeilaGharani

    3 жыл бұрын

    You're very welcome!

  • @adityapatnaik6079
    @adityapatnaik60793 жыл бұрын

    GREAT WORK ! YOU POST THE BEST CONTENT !

  • @ToryalaiMajeedi
    @ToryalaiMajeedi Жыл бұрын

    Thank you very much for your useful video

  • @akinwaleakinlosotu4079
    @akinwaleakinlosotu40793 жыл бұрын

    Heavens bless you for this video. It has helped me a lot. Thanks a lot.

  • @robregist
    @robregist2 жыл бұрын

    Engaging, informative and nicely paced... 👍

  • @brahmmamb24
    @brahmmamb243 жыл бұрын

    Every video is amazing tips has been sharing.. Thank you so much

  • @sriharim1596
    @sriharim15963 жыл бұрын

    Thanks Leila... now I'm aware on Form functionalities much better than earlier..

  • @LeilaGharani

    @LeilaGharani

    3 жыл бұрын

    Great to hear!

  • @HusseinKorish
    @HusseinKorish3 жыл бұрын

    Extremely Useful ... thumps up .... thanks Leila

  • @sideshowbobby71
    @sideshowbobby713 жыл бұрын

    I have learned so much from you. Thank you for sharing.

  • @LeilaGharani

    @LeilaGharani

    3 жыл бұрын

    You are so welcome, Bobby!

  • @davidmelgar1935
    @davidmelgar1935 Жыл бұрын

    Super helpful video!!

  • @pwanlass
    @pwanlass2 ай бұрын

    Fantastic video!

  • @eduardooc8531
    @eduardooc8531 Жыл бұрын

    always impeccable teaching. your content are excellent

  • @LeilaGharani

    @LeilaGharani

    Жыл бұрын

    I appreciate that!

  • @Choroidal
    @Choroidal3 жыл бұрын

    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

    @LeilaGharani

    3 жыл бұрын

    Glad it was helpful!

  • @AdityaKumar-zz7dm
    @AdityaKumar-zz7dm Жыл бұрын

    It was really lovely . Thanks for the knowledge & understanding :)

  • @LeilaGharani

    @LeilaGharani

    Жыл бұрын

    My pleasure 😊

  • @wayneedmondson1065
    @wayneedmondson10653 жыл бұрын

    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

    @LeilaGharani

    3 жыл бұрын

    Thank you Wayne.

  • @ciruzzi7
    @ciruzzi7 Жыл бұрын

    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

  • @1gopalakrishnarao
    @1gopalakrishnarao3 жыл бұрын

    Excellent. Thank you Madam.

  • @knsc8762
    @knsc87623 жыл бұрын

    very good video, helped me a lot.

  • @XcelGuruSayantan
    @XcelGuruSayantan3 жыл бұрын

    This is a very good video for beginners who don't have any idea about Microsoft Forms.

  • @revingmsto6980
    @revingmsto6980 Жыл бұрын

    Dear Madam, Thank you for making this video. Your videos are always perfect

  • @swaminathannarayanan2639
    @swaminathannarayanan26393 жыл бұрын

    This time, before you I have learned ms forms.. Expecting Power Automate complete course from you.. Thanks for this video

  • @maximlarioshin7402
    @maximlarioshin74022 жыл бұрын

    Thank you Leila!

  • @MM-nr8nf
    @MM-nr8nf3 жыл бұрын

    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

    @LeilaGharani

    3 жыл бұрын

    Hope it will come in handy for you.

  • @dkarthikr123
    @dkarthikr1233 жыл бұрын

    Your Excel skill is 7!! thats so humble.. loved the video as always:)

  • @LeilaGharani

    @LeilaGharani

    3 жыл бұрын

    Thank you so much!!

  • @mohammdzafer
    @mohammdzafer2 жыл бұрын

    You amazing! As always 🙏

  • @thangaveluraj5366
    @thangaveluraj53663 жыл бұрын

    Really awesome.. thank you

  • @mayankchheda311
    @mayankchheda3113 жыл бұрын

    thank you for sharing knowledge...👍

  • @rustamakhmullaev5697
    @rustamakhmullaev56973 жыл бұрын

    Leila ,thanks for very interesting lesson!

  • @LeilaGharani

    @LeilaGharani

    3 жыл бұрын

    My pleasure!

  • @YauFennie
    @YauFennie3 жыл бұрын

    Leila... U are the best!!

  • @olgachicot8017
    @olgachicot80173 жыл бұрын

    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 😊

  • @KadirMuratTosun
    @KadirMuratTosun3 жыл бұрын

    Thank you very clear informations :). I will try Grid also :)

  • @nasirshoaib223
    @nasirshoaib2233 жыл бұрын

    amazing .... totally new for me

  • @mohamedaslam6619
    @mohamedaslam66193 жыл бұрын

    Asusual informative and good tutorial thanks

  • @redspade2303
    @redspade23033 жыл бұрын

    This is incredible!

  • @sailingmarquise9742
    @sailingmarquise97423 жыл бұрын

    Very useful video congratulation Leila

  • @yogibearstie
    @yogibearstie3 жыл бұрын

    Looks like fun, thank you.

  • @jeanettemena1286
    @jeanettemena12863 жыл бұрын

    You’re a gem!

  • @tithsambo6923
    @tithsambo6923 Жыл бұрын

    I do like your tutoring 👍👍