How to Create Fillable Forms in Excel - Employee Engagement Survey Template

Рет қаралды 632,119

Күн бұрын

HOW TO CREATE FILLABLE FORMS IN EXCEL // Learn to create a fillable form in MS Excel using interactive drop-down lists that populate text in other areas of the form. See how you can pull in data from another table using VLOOKUP and how you can program conditional text to appear using the IF formula. Take advantage of MS Excel functionality to create your form, then format it so that it looks like a form document and not a spreadsheet. Watch this video to see several formatting tips and techniques. Also see how to make your data table tabs Very Hidden.
In this video we create an Employee Engagement Survey as an example form. This formatted template including the IF and VLOOKUP formulas is available for purchase and download at: www.etsy.com/listing/87584666...
Consider taking my Course on Creating Fillable Forms in Microsoft Word to take your form-building skills to the next level!
• Creating Fillable Form...
TIP: Use the "Jump To" TimeStamp Links below to go directly to that part of the video to re-watch one of these tutorial highlights.
00:00 Introduction
02:55 Form Page Layout
04:53 Merge Cells & Cell Alignment
06:19 Create Drop-Down In Excel
08:43 Link Text to Drop-Down Using IF Formula
11:05 Insert Check Boxes
13:43 Link Text to Drop-Down Using VLOOKUP
19:12 Wrap VLOOKUP in IFERROR to make "hashtag not-applicable" Disappear
21:39 Excel Form Formatting
24:09 How To Hide Tabs & Make Very Hidden
__________
RESOURCES & GEAR
✦ Screen Recording Software: techsmith.z6rjha.net/NZG5b
✦ Green Screen: amzn.to/2DnHsY2
✦ Camera: amzn.to/39KvpQA
✦ JotForm: www.jotform.com/pricing/?utm_...
✦ PresenterMedia: shareasale.com/r.cfm?b=417324...
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: www.paypal.com/cgi-bin/webscr.... Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS:
✦ Visit mailchi.mp/6a0859ea0844/sharo... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
__________
KEYWORDS: #MSExcel, #M365, How To Create Fillable Forms in Excel, How To Create Drop-Down List in Excel, How To Create a Form in Excel, Link Text to Drop-Down Using IF Formula, Link Text to Drop-Down Using VLOOKUP, Insert Checkboxes in Excel, How To Hide Worksheet Tabs in Excel, Employee Engagement Survey Template, How To Hide Spreadsheet in Excel, How To Hide Workbook in Excel, How to Unhide Very Hidden Tabs in Excel, Excel Fillable Forms, Excel Tutorial, Excel Lesson, Excel Tips and Tricks, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:
➤Creating Fillable Forms: • How To Create A Fillab...
➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
➤ Word Tutorials for HR: • Microsoft Word Tutorials
➤ Welcome | About Me: • Playlist

Пікірлер: 460

@SharonSmith Жыл бұрын

Want to take your form-building skills to the next level? 🚀 Checkout my KZfaq Course on "Creating Fillable Forms in Microsoft Word: A Step-by-Step Guide," kzfaq.info/sun/PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs where your frequently asked questions on forms are answered, like how to insert a Submit form button that works with any email client and how to export completed form data to Excel quickly and easily. 💡 The Course includes 15 video lessons, a handy PDF workbook with all lesson summaries and VB code tidbits, and two versions of the Word form template we build together (a behavior-based interview questionnaire form). You can still always access all the free content on my Channel (over 100+ video tutorials). Please note that the KZfaq Courses feature is in Beta and currently limited to a subset of Creators. Courses are only available in the United States, South Korea, and India. Viewers must use a computer or Android device to buy a Course. We hope KZfaq Courses will roll out to more Creators, devices, and regions in the future! Thank you for taking the time to checkout my Course! You may see some of your other favorite KZfaq Creators who have also launched Courses by going to their Channel page and clicking on the "Playlist" tab. Enjoy! 😉

@RieRiePie Жыл бұрын

I love that you speak in a calm, normal voice during this instruction. Other videos feel like they are yelling at me with fake energy and enthusiasm.

@SharonSmith Жыл бұрын

Thank you so much, Marie! I appreciate that feedback and it is a great compliment. I'm so glad you found my videos helpful. Thanks for watching!

@srenep40 3 жыл бұрын

This was absolutely fantastic. Great demonstration. Not overly done or complicated. Thank you so much for this tutorial.

@SharonSmith Жыл бұрын

Thank you, Stacey! So glad you like this tutorial. Thanks for watching!

@miaw.5819 3 жыл бұрын

You’re an amazing teacher. Not a lot people have that skill. Thanks for the info!

@SharonSmith 3 жыл бұрын

Thank you for your kind words, Mia! Thanks so much for watching my videos!

@stacyvars8590 Жыл бұрын

Not only was this extremely helpful but you managed to reference one of my favorite shows. "I know, you know, that I'm not telling the truth. I know, you know, they just don't have any proof." 💖 Seriously though, thank you for this video!

@SharonSmith Жыл бұрын

Thanks so much, Stacy! I'm so glad you found my video helpful! Great to hear from a fellow Psych fan! You heard about Pluto? That's messed up, right? 😂

@Nipthezephyr 3 жыл бұрын

Excellent video. I was looking for something more complex than using the form button in the tabs at top, but less complex than VBA. Your video demonstrates the usage of many different component of Excel. Thanks for posting it.

@SharonSmith 3 жыл бұрын

Thanks Shawn! I'm glad you found this helpful. Thanks for watching my videos!

@danishiqbalhashmi Жыл бұрын

After all these years of pain. I have found the comfort. Thank you so much ❤ for all the videos and help you did here. It's helping me a lot and improving my work quality. My boss appreciated me in a meeting in front of everyone.😂

@SharonSmith Жыл бұрын

That is great to hear! I'm so glad you found my videos helpful and that you are getting recognized at work for your new skills! Thanks for watching my videos and taking time to leave a nice comment. I appreciate it!

@MeganAlissa24 3 жыл бұрын

You explain this so well! I feel like I'm my learning magic!!

@SharonSmith 3 жыл бұрын

Hi Megan! So glad to hear you are learning a lot from my videos. Thanks so much for watching!

@melissalomba3945 11 ай бұрын

Loved this video it was so well put together and informative. I consider myself to be advanced but still learned from it! Thanks you and keep up the great work!

@wingame52 2 жыл бұрын

I saw your how to make form using MS Word and thought you were MS Word guru until noticiing this video. So you are a full & complete MS Office pro it seems. Thanks for the slow and easy to follow videos!

@SharonSmith 2 жыл бұрын

Thank you so much for the nice compliment. I'm glad you found more of my videos and that you find them helpful. Thanks for watching!

@toniwelch5310 3 жыл бұрын

Thank you for posting this. Also loving that the Managers are from Psych!!!

@PrasangaWijewardhane Жыл бұрын

You’re an amazing teacher. May you live long!

@SharonSmith Жыл бұрын

Thank you very much! I'm glad you like my videos. Take care!

@nickpalmer327 9 ай бұрын

This was a great tutorial Sharon, thank you. Speed of instruction and clarity was spot on.

@SharonSmith 9 ай бұрын

I’m so glad to hear it! Glad you found it helpful! Thanks for watching!

@zikriaskinince9708 3 жыл бұрын

Amazingly educational video Sharon. You have really pulled the bar way up there. Kudos.

@SharonSmith 3 жыл бұрын

Thank you so much for your kind words! I'm so glad you found my videos helpful. Thanks so much for watching!

@navyao 10 ай бұрын

This was a BIG help, and you are absolutely beautiful @SharonSmith so I enjoyed watching and listening to you. Thank you so much for creating this. ; )

@SharonSmith 10 ай бұрын

Oh, thank you so much. You are too kind. I'm glad you found my videos helpful. Thanks for watching!

@francesrosado9288 2 ай бұрын

Thanks for the Video! I wish my profesor back in the university teach us the way you are teaching in this video (calmly, focus, explaining every detail knowing there are people new to excel). I will refer this KZfaq channel to my friends and family!!! 😊😊😊

@SharonSmith 2 ай бұрын

I"m so glad you found my videos helpful! Thanks for watching and for sharing my Channel with others! I really appreciate it. Take care!

@mrjdainsworth 3 жыл бұрын

What a great video, one of the best tutorial videos iIve ever watched, such a good, unrushed, step by step explanation. Thank you.

@SharonSmith 3 жыл бұрын

Thank you Dominic! That is very nice of you. I'm so glad you found it helpful. Thanks for watching!

@gracelee1546 3 жыл бұрын

Sharon, this is great! I was trying to create a fax template to pull up existing data of contacts and you are the answer! Appreciate your educational videos! :D

@brittneyrobinson2761 2 жыл бұрын

that's a cool document to have.

@andusgroup2317 3 жыл бұрын

Thanks Sharon - great tutorial. Excellent additional skills to my arsenal. 👌🙂

@SharonSmith 3 жыл бұрын

Very glad to hear you found it helpful! Thanks for watching my videos! 👍

@digvijays25 2 жыл бұрын

Loved it !! I learnt so many new things about Excel

@SharonSmith 2 жыл бұрын

That is great to hear!! So glad you found it helpful. Thanks for watching, Digvijay!

@lynx2771 2 жыл бұрын

Your explanation is way too simple to understand!! Thanks a lot! ❤ Keep up the great work!!

@SharonSmith 2 жыл бұрын

Thanks so much for the nice comment! I appreciate it. Glad you found it helpful. Thanks for watching!

@lynx2771 2 жыл бұрын

@@SharonSmith 🙂 💛

@chayafruchter8617 3 жыл бұрын

Thank you for an amazing, video. It was amazing, well-presented and informative!

@SharonSmith 3 жыл бұрын

Thank you Chaya! I'm so glad you found my videos helpful. Thanks so much for watching!

@salpatil6136 Жыл бұрын

Thanks Sharon. it was very helpful. Appreciate your insight and patience. You are a very good teacher

@SharonSmith Жыл бұрын

Thank you so much for your kind feedback! I'm so glad you like my videos. Thanks for watching!

@kevin_k_moony 2 жыл бұрын

Wow, this is exactly what I was searching for An entire playlist🙏🙏🙏 Really helpful

@SharonSmith 2 жыл бұрын

So glad you found it helpful! Thanks for watching!

@hounddogmusic12 2 жыл бұрын

Wow! So much helpful info and presented in a very easy to understand way. Thanks!! Saved to favorites

@SharonSmith 2 жыл бұрын

Awesome! So glad you found it helpful. Thanks for watching and saving me to your favorites!

@jgdaily 2 жыл бұрын

I just have to say thank you, you are really amazing, your NO.1 subscriber from Nigeria

@SharonSmith 2 жыл бұрын

Oh, thank you very much! So glad you found my videos helpful. Thanks for watching!

@craigfarnham1061 2 жыл бұрын

This is an excellent tutorial

@SharonSmith 2 жыл бұрын

Thank you, Craig! I'm glad you found it helpful. Thanks for watching!

@star24211 Жыл бұрын

your instructions were very easy to understand. As a result, i completed an evaluation form. Thanks.

@SharonSmith Жыл бұрын

Glad to help! Thanks for watching!

@MohamedOuttilmirath13655 2 жыл бұрын

That was crystal clear. Thanks a lot. I really enjoyed it and I did put it to practice.

@SharonSmith 2 жыл бұрын

That is great news! So glad you found this video helpful. Thanks for watching!

@jwade12361 7 ай бұрын

AHHHHH YOURE A PSYCH FAN! Love it!!!!!!

@SharonSmith 7 ай бұрын

Yes!! One of my favorite shows 😉! Thanks for watching my videos!

@jwade12361 7 ай бұрын

mine too. I wasnt paying attention to the data you were entering in until later on in the video. and youre welcome. I have learned a lot from you in a very short time. @@SharonSmith

@BioLClark 2 жыл бұрын

Thank you so much! Just made up a template for trials. Wonderful!

@SharonSmith 2 жыл бұрын

Awesome!! So glad you found it helpful, Lindsey! Thanks for watching!

@akukiira 2 жыл бұрын

Thank you so much. Very clear. I managed to create a simple fillable forms from this guide.

@SharonSmith 2 жыл бұрын

That is great to hear! Glad you were able to create a form. Thanks so much for watching!

@KofiWilliamsCoach 21 күн бұрын

Such great content, delivered in a beautiful way! I learned so much and just created a fillable quiz for my business. I'm so proud! Thank you!!!

@SharonSmith 20 күн бұрын

That is awesome! I’m so glad you learned from my videos and made a fillable quiz for your business! Thanks for taking time to leave a nice comment and thanks for watching!

@stephensimiyu6748 3 жыл бұрын

This is very insightful.....thank you Sharon

@SharonSmith 3 жыл бұрын

You are very welcome, Stephen! Thanks for watching!

@eltrompo83 2 жыл бұрын

I didn't know Tina Fey knew Excel so well!

@SharonSmith 2 жыл бұрын

😄 I’ll take that as a compliment. Thanks for watching!!

@maryaftonday1285 Жыл бұрын

Just came across this--what an awesome tutorial (life saving!) but also, LOVE the Psych reference!!

@SharonSmith Жыл бұрын

Thank you so much, Mary! Yes, gotta love Psych, it is one of my favorite shows (still). 😉

@willaliburd9834 3 жыл бұрын

Exactly what I needed today!

@SharonSmith 3 жыл бұрын

Hi Willa! So glad you found this video helpful. Be sure to check out the video I posted today: kzfaq.info/get/bejne/pa6oraefqLfQqGg.html it builds on this and shows you how to set up a drop-down list in Excel that allows users to make multiple selections. Thanks for leaving a comment!

@karolinagrygiel178 3 жыл бұрын

Very useful tips here 👍🏼 thank you Sharon!

@SharonSmith 3 жыл бұрын

Thank you Karolina! Glad you found my videos helpful! Thanks so much for watching and taking time to leave a comment!

@hgaubaul 3 жыл бұрын

You're awesome! Very clearly explained. Thank you

@SharonSmith 3 жыл бұрын

Glad you found it helpful! Thanks so much for watching!

@myfavourites6226 3 жыл бұрын

Thanks Sharon, it's helpful

@brittneyrobinson2761 2 жыл бұрын

This tutorial was very easy to follow. Thank you.

@SharonSmith 2 жыл бұрын

Glad you found it helpful! Thanks for watching!

@wardhively1856 3 жыл бұрын

You’re a very talented teacher

@ianhunter8924 2 жыл бұрын

So many brilliant tips in this! I have learnt more from this than about twenty other confusing tutorials. Thank you!

@SharonSmith 2 жыл бұрын

That is great to hear, Ian! Glad you found it helpful. Thanks for watching!

@sayanamsler2884 2 жыл бұрын

@sharon smith i think you miss understood his comment

@sayanamsler2884 2 жыл бұрын

@@SharonSmith i think you miss understood his comment

@ianhunter8924 2 жыл бұрын

@@sayanamsler2884 Hi, nothing has been misunderstood. This was such a helpful video. My point was that I have sat through many long and tedious tutorials that went around in circles and made everything somewhat confusing. Sharons video was lots of quick great tips that have really helped. I issued a project form yesterday because of this! Fantastic :)

@cesarlezama1 2 жыл бұрын

Amazing tutorial Sharon, Thank you!

@SharonSmith 2 жыл бұрын

Glad you found it helpful, Cesar! Thanks so much for watching!

@BruceKasoka 2 жыл бұрын

This was so Great Sharon; I appreciate a lot.

@SharonSmith 2 жыл бұрын

Thanks so much, Bruce! I'm glad you found it helpful! Thanks for watching!

@mariesalazar4270 3 жыл бұрын

New subscriber here!! You just gave a great idea! Thank you!

@SharonSmith 3 жыл бұрын

So glad to hear it! Thanks for subscribing to my channel and watching my videos. I really appreciate it!

@uniquefall6952 2 жыл бұрын

:) Your post caught my attention ! Furthermore, thank you for taking the time to contribute your knowledge and experience with this collection of helpful "Excel" form-building tips. It made me feel ready to try and compelled me to do so. I wish you all the best !!:)

@SharonSmith 2 жыл бұрын

Thank you so much!! I'm so glad you found my post and that this video has inspired you. I wish you luck with your forms! Thanks for watching!!

@atakaai 2 жыл бұрын

very clear helpful Sharon you simplify excel .....thank you !

@SharonSmith 2 жыл бұрын

You are very welcome! Thanks so much for your kind words and glad you found my videos helpful. Thanks for watching!

@syedikramullah1114 3 жыл бұрын

I am so glad that I subscribed your channel .bcz I learnt a lot off tricks from your channel in Microsoft word.once again thank u so much Sharon.

@SharonSmith 3 жыл бұрын

Hello Syed! Thank you so much for watching my videos. I'm very glad to hear you found them helpful! Take care!

@dwarfusinterruptus9314 2 жыл бұрын

Great form building tutorial. But, how do you aggregate the data? If it is a survey, reports will need to be created from what is collected.

@jarius0301 3 жыл бұрын

You should have a million subscribers. Thanks, for your channel.

@SharonSmith 3 жыл бұрын

Thanks, Jay! That is very nice of you. Thank you for watching my videos!

@conradjames3526 2 жыл бұрын

gotta love good old Bruton Gaster - love that show

@SharonSmith 2 жыл бұрын

Me too! 😂 Thanks for watching my videos!

@SharonSmith 2 жыл бұрын

Oh yeah, did you hear about Pluto?

@robledoangel 2 жыл бұрын

Your video was awesome. Thank you for that information. Now I can apply what I've learned at my job. Thanks again.

@SharonSmith 2 жыл бұрын

That is great to hear, Angel! I'm so glad you found my videos helpful. Thanks for watching!

@eissa247 Жыл бұрын

You and your channel taught me something; keep up the good job.

@SharonSmith Жыл бұрын

Thank you, Eissa! Thanks for watching my Channel!

@richardl3720 3 жыл бұрын

Awesome stuff for a rather dull subject. Thank you.

@SharonSmith 3 жыл бұрын

Thanks for watching, Richard!

@abdikadirabdirahman2032 2 жыл бұрын

Thanks Sharon Smith. this is a great job well done

@SharonSmith 2 жыл бұрын

Thank you for watching! Glad you found it helpful! Take care!

@lovethatbeach Жыл бұрын

Great content, Sharon! Thank you so much!

@SharonSmith Жыл бұрын

You are very welcome! Glad you found it helpful. Thanks for watching my Channel!

@jeannettekelbaugh3216 7 ай бұрын

This was super helpful. Great instructor skills. Thank you so much. 🙂

@SharonSmith 6 ай бұрын

I'm so glad you found it helpful! Thanks for watching!

@shohedulislam99 3 жыл бұрын

Thanks Sharon. Really you are amazing. And You do not know, how much you have benefited me...! Thanks again, & good luck.

@SharonSmith 3 жыл бұрын

Thank you so much, Shohedul! I am very glad you found my videos helpful, that is my goal. I really appreciate you watching. Best of luck to you.

@shohedulislam99 3 жыл бұрын

@@SharonSmith :)

@mikemellor8972 2 жыл бұрын

Thanks for your valuable contribution. The drawback of this form-like worksheet is that the user is free to move the cursor anywhere, and even protecting it doesn't entirely prevent mischief.

@SharonSmith 2 жыл бұрын

Thanks for subscribing to my Channel, Mike! Glad you found it helpful!

@belindaramz 3 жыл бұрын

Very helpful and beautiful voice! 😊🌸

@PaulSchwartzmeyerxxx 3 жыл бұрын

I love this gal. This video is sooo well done

@SharonSmith 3 жыл бұрын

Thanks so much for watching my videos, Paul! I appreciate it!

@taychorhwee3516 2 жыл бұрын

Thank you!. Well presented.

@SharonSmith 2 жыл бұрын

You are very welcome! Thanks for watching!

@thomsonnshila3465 8 ай бұрын

such an informative session

@mariemucha3195 Жыл бұрын

This is fabulous. You make it so easy to follow :)

@SharonSmith Жыл бұрын

So glad to hear you liked my video and found it helpful. Thanks for watching!

@walzanonato 2 жыл бұрын

This is excellent. Thank you!

@SharonSmith 2 жыл бұрын

You are very welcome, glad you found it helpful. Thanks for watching!

@rais7450 3 жыл бұрын

Amazing...thanks Sharon!

@SharonSmith 3 жыл бұрын

Glad to help! Thanks for watching!

@tchapmanpdx3533 Жыл бұрын

Very helpful, thank you!!

@SharonSmith Жыл бұрын

Glad to hear it! Thanks so much for watching!

@azpapi 3 жыл бұрын

Excellent! You're an excel queen!

@SharonSmith 3 жыл бұрын

Thanks so much! I appreciate you watching my videos!

@siswopoerwantophdmphmscbsc4288 2 жыл бұрын

Highly appreciated!

@SharonSmith 2 жыл бұрын

Glad you found it helpful! Thanks for watching!

@serriayers6662 3 жыл бұрын

Thank you for ALL your videos, they have helped me so much. I have gone through all your tutorials for word but I do need to know how to make a auto fillable cell in excel, where the more you write in the cell or cells it auto expands. Is this possible and how?

@AhmedMohamed-kq2gx 3 жыл бұрын

wonderful explanation. Thank you.

@SharonSmith 3 жыл бұрын

You are very welcome! Thanks so much for watching!

@user-cq9ls1lw7i Жыл бұрын

Great video! Thank you! 🙂

@SharonSmith Жыл бұрын

Glad you found it helpful, Norma! Thanks for watching!

@stgermain1074 3 жыл бұрын

"Shawn Spencer - Communications" LOL! Love all the Psych callbacks. You didn't give poor Lassie a title. :D I was looking for a form to input data into a spreadsheet for later data analysis. In the case of your employee engagement survey, you'd want to record the responses. For my needs, I want to build a db for my beehives. Inspection date, queen present Y/N, Honey yield, that sort of thing. Something that can easily be manipulated with a tablet out in the apiary.

@unitedpublication8210 3 жыл бұрын

You are a great teacher. I have learnt alot

@SharonSmith 3 жыл бұрын

Thank you very much! Glad you found my videos helpful. Thanks for watching!

@NatalieDunn0502 6 ай бұрын

Really great tutorial, thank you!

@SharonSmith 6 ай бұрын

Glad you found it helpful! Thanks for watching!

@akaman85 2 жыл бұрын

Fantastic Tutorial! Subscribed!

@SharonSmith 2 жыл бұрын

Awesome! Glad you found my videos helpful. Thanks so much for watching and subscribing to my channel!

@subhajitbarui3057 2 жыл бұрын

Thanks Madam! Keep do uploading this kind of videos. It's really informative.🙏🏻

@SharonSmith 2 жыл бұрын

Glad to help! Thanks for watching!

@adejupe8308 Жыл бұрын

thanks pal, very helpful!!!

@SharonSmith Жыл бұрын

Glad to help! Thanks for watching!

@UnitedCanuck Жыл бұрын

Thanks. Great tutorial.

@SharonSmith Жыл бұрын

Glad you found it helpful! Thanks for watching!

@juanarroyo8219 3 жыл бұрын

Love your video!

@SharonSmith 3 жыл бұрын

Thanks for watching Juan!

@________a177 3 жыл бұрын

Sharon, the information and presentation are Amazing! I started into a project and you answered MANY of my questions in this one video, and it just happened to be the first source I found. I do have a question on how to disseminate the form to at team an then retrieve the form ideally via submit button that sends form/file to admin with time stamp). Is this possible utilizing a Microsoft 360 account? It would be great to give users unlimited access to the blank forms, then once its submitted have the finished form locked, but accessible to the user and the administrator.

@DrXJ 11 ай бұрын

Thank you. I love you. 😊 Very Helpful!! 🙏🤘

@SharonSmith 11 ай бұрын

Thank you! I'm so glad you found my videos helpful. Thanks for watching!

@patricknumi3539 2 жыл бұрын

Excellent presentation, very educational.

@SharonSmith 2 жыл бұрын

Thank you, Patrick! So glad you found it helpful. Thanks for watching!

@keremozturk5235 3 жыл бұрын

Hello. Is it possible to send the form to many people and then to collect all the inputs in one excel file? That would be very helpful to know. Thank you!

@lmd4881 2 жыл бұрын

this is amazing!! :) I had no idea that you could make a fillable form with excel :)

@SharonSmith 2 жыл бұрын

I'm so glad you found it helpful! Thanks so much for watching!

@milbird5 Жыл бұрын

Excellent very well explained

@SharonSmith Жыл бұрын

Glad you found it helpful! Thanks for watching!

@The-Singularity-M87 Жыл бұрын

Outstanding lecture!

@SharonSmith Жыл бұрын

Glad you found it helpful! Thanks for watching!

@vestivideopk Жыл бұрын

its really great & appreciable

@SharonSmith Жыл бұрын

Glad you found it helpful! Thanks so much for watching!

@lindapertiwi1600 2 жыл бұрын

This is great. Thank you !

@SharonSmith 2 жыл бұрын

You are very welcome, Linda! Thanks for watching my videos! I appreciate it!

@lindapertiwi1600 2 жыл бұрын

@@SharonSmith Hi, Do you have a course on how to make auto-populated data in PDF and JavaScript for PDF? Will definitely follow the course

@dawnstratton7623 2 жыл бұрын

@Sharon, this is fantastic. I do have a question though. I created a form using Microsoft Forms, I love the branching capability. However, I don't like a lot of the issues with compiling results and my process after receiving them. Is there a way to have multiple lines populate based on the drop down answer? So if the drop down is A, B, or C and they choose "C", can 3 different Yes/No or Text answer questions populate?

@donnaorpilla6682 3 жыл бұрын

Thank you for this! Exactly what I’ve been looking for. Can this excel form be made into FORMS and be accessed on my iPhone? I can’t bring computers into my meetings, but would like to collect data on my iPhone while I’m in a meeting.

@danyos777 2 жыл бұрын

Great! Thank you! I am new to building forms using Excel. QUESTION 1: If you send out this form to several staff to fill out, once you get them back, how do you collect all their individual answers (from several employees) into a single Excel sheet database? QUESTION 2: Is there a way to automatically feed a spreadsheet with the data from each employee form done? Thanks for sharing your knowledge!

@cr1994yellow 2 ай бұрын

Did you get a response to this? this is what I am trying to learn now :) your help will be truly appreciated.

@karen.kohn-Temple 2 жыл бұрын

This video was so clear and well done, and I'm excited about the possibilities. I was wondering, however, how a user would submit the form and whether it's possible to compile the submissions into a spreadsheet. I see other users have asked similar questions below, but I don't see an answer.

@jennifermartin9213 Жыл бұрын

I can't see why you couldn't compile the results into a tab on the same spreadsheet, like having a summary sheet as the top of the tab list. But I'd like to hear from more of an expert as well. I'm not one.

@aseleta3533 2 жыл бұрын

thank you so much for your amazing video

@SharonSmith 2 жыл бұрын

You are very welcome, glad it helped! Thanks so much for watching!

@Andrew.chomba 3 жыл бұрын

Thank you. I haven't gone to school to study excel just yet, but this has been helpful. Quick question, how can I add the if other option for a question that needs the user to explain?

@joeyboomgaarden840 3 жыл бұрын

You have my respect because you had Burton Guster as one of the managers. Psych is the best show 😂😂

@SharonSmith 3 жыл бұрын

Yes it is!! One of my favorites too 😄! Some of my earlier Excel tutorial videos feature my fake employee database of TV characters: kzfaq.info/get/bejne/h9CIapWG2te7mXk.html Thanks so much for watching my videos!

@davidjones5319 2 жыл бұрын

beautiful. Thank you

@SharonSmith 2 жыл бұрын

Glad you liked it! Thanks for watching!

@aducaale328 2 жыл бұрын

Thank you very much.

@SharonSmith 2 жыл бұрын

You are very welcome, thanks for watching!

@tutsecret499 2 жыл бұрын

People below are asking about populating the answers. I did a project 20 years ago populating the answers behind the scene in the same workbook, with one click you see all the answers and calculations. My problem is I lost my backup of my project, and don't remember how I set up. I am trying to remember. I do remember that I even wrote down the password, the name of the Manager to whom I made the project. The original project was done manually by somebody 17,000 questionnaire forms with 50 questions in word format. Each question has 5 answers. I had to assist the dept to retrieve the data/results of the questionnaire. So I decided to set up another method to replace the original manual labor project. I transferred everything to excel. After I accomplished the set up, it was a breeze, you open the answered form, and done. Saved a lot money, fatigue, and time. I just don't know where I put the backup disk, I saved in a floppy disk, even if I find it, where I am going to insert the flipflop disk, unless I go to those antique computer store and ask them to retrieve it. I have a habit not to backup my project inventions, a great procrastinator.