Want to take your form-building skills to the next level? 🚀 Checkout my KZbin Course on "Creating Fillable Forms in Microsoft Word: A Step-by-Step Guide," kzbin.info/aero/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 KZbin 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 KZbin 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 KZbin 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!
@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? 😂
@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!
@wingame522 жыл бұрын
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!
@SharonSmith2 жыл бұрын
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!
@miaw.58193 жыл бұрын
You’re an amazing teacher. Not a lot people have that skill. Thanks for the info!
@SharonSmith3 жыл бұрын
Thank you for your kind words, Mia! Thanks so much for watching my videos!
@francesrosado92882 ай бұрын
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 KZbin channel to my friends and family!!! 😊😊😊
@SharonSmith2 ай бұрын
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!
@Nipthezephyr3 жыл бұрын
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.
@SharonSmith3 жыл бұрын
Thanks Shawn! I'm glad you found this helpful. Thanks for watching my videos!
@srenep403 жыл бұрын
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!
@star24211 Жыл бұрын
your instructions were very easy to understand. As a result, i completed an evaluation form. Thanks.
@SharonSmith Жыл бұрын
Glad to help! Thanks for watching!
@danyos7772 жыл бұрын
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!
@cr1994yellow3 ай бұрын
Did you get a response to this? this is what I am trying to learn now :) your help will be truly appreciated.
@Xirnatts5 күн бұрын
Before you even distribute the form: 1 Create a new sheet with a table that you will use to add up all the answers together. 2 Give that table a name, and add a column for every answer you want to aggregate. 3 Report that answer from the "Form" sheet, either by referencing that cell, or giving it a name and referencing that name. When people fill in your form, that table should populate with their answers in an easy-to-aggregate form. Now, put all the excel files that are returned to you in one folder. Create a new Excel file to aggregate answers outside of that folder, and go to Data>Get Data(Power Query)>From a File>Folder and select the folder with all your Excel files. Select the name of the table you named in 2. Now all of the data will be pulled together into 1 single table. Bonus: you can add or delete files from the folder, and when refreshing your query, this will be reflected. To transform/filter data, read more about Power Queries. I'm late to answer, but hope it helps.
@nickpalmer32710 ай бұрын
This was a great tutorial Sharon, thank you. Speed of instruction and clarity was spot on.
@SharonSmith10 ай бұрын
I’m so glad to hear it! Glad you found it helpful! Thanks for watching!
@KofiWilliamsCoachАй бұрын
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Ай бұрын
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!
@jgdaily2 жыл бұрын
I just have to say thank you, you are really amazing, your NO.1 subscriber from Nigeria
@SharonSmith2 жыл бұрын
Oh, thank you very much! So glad you found my videos helpful. Thanks for watching!
@MeganAlissa243 жыл бұрын
You explain this so well! I feel like I'm my learning magic!!
@SharonSmith3 жыл бұрын
Hi Megan! So glad to hear you are learning a lot from my videos. Thanks so much for watching!
@PrasangaWijewardhane Жыл бұрын
You’re an amazing teacher. May you live long!
@SharonSmith Жыл бұрын
Thank you very much! I'm glad you like my videos. Take care!
@jaycal1920 Жыл бұрын
12:45 Page Layout/Arrange/Align. Select all check boxes by holding CTRL button and right clicking each. Align left then Distribute Vertically.
@Teacherman19552 жыл бұрын
I enjoyed your tutorial! I followed along and was able to complete the project, it looked just as yours did! Your instructions were clear and understandable, your pace was unhurried and easy to keep up with. As an educator in Special Needs Education for 40 years, I know how important those qualities can be in teaching those who may not be as well versed in working with computers and software programs. I've seen quite a few tutorials on You Tube, some of them are very good, like yours, and others are, for me at least, hard to follow. The host either speaks too fast, or moves through steps too quickly with little explanation of what he/she is doing and why. Some of them know their subject so well that they forget that the person viewing their tutorial may not be as knowledgable. True, they can stop and repeats parts they miss or need help with, but I' for one, don't want to have to constantly go forth and back. After viewing this video, I'm encourage to viewm others by you! Great Job, Sharon!!
@SharonSmith2 жыл бұрын
Thank you so much for your kind and encouraging words! I'm so glad you found my videos helpful. I strive to produce videos that will help everyone. I really appreciate you watching, and it is great to hear this feedback. I wish you the best of luck!
@SharonSmith2 жыл бұрын
Thank you so much for your donation to my Channel! I appreciate it very much. It is very kind of you!
@mikemellor89722 жыл бұрын
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.
@SharonSmith2 жыл бұрын
Thanks for subscribing to my Channel, Mike! Glad you found it helpful!
@karen.kohn-Temple2 жыл бұрын
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.
@digvijays252 жыл бұрын
Loved it !! I learnt so many new things about Excel
@SharonSmith2 жыл бұрын
That is great to hear!! So glad you found it helpful. Thanks for watching, Digvijay!
@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). 😉
@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!
@ianhunter89242 жыл бұрын
So many brilliant tips in this! I have learnt more from this than about twenty other confusing tutorials. Thank you!
@SharonSmith2 жыл бұрын
That is great to hear, Ian! Glad you found it helpful. Thanks for watching!
@sayanamsler28842 жыл бұрын
@sharon smith i think you miss understood his comment
@sayanamsler28842 жыл бұрын
@@SharonSmith i think you miss understood his comment
@ianhunter89242 жыл бұрын
@@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 :)
@tes-po5uf3 жыл бұрын
Fascinating! 4 questions 1. Does the form have to be saved in a particular format? 2. Do respondents have to have Excel software? 3. Do I attach the form as a traditional email attachment? 4. How do I access the information? A simple example, let's say I'm offering a limited number of free tickets to an event. I need the names of those wishing to attend and how many tickets they want.
@juangraysen75533 жыл бұрын
Instablaster.
@zikriaskinince97083 жыл бұрын
Amazingly educational video Sharon. You have really pulled the bar way up there. Kudos.
@SharonSmith3 жыл бұрын
Thank you so much for your kind words! I'm so glad you found my videos helpful. Thanks so much for watching!
@eissa247 Жыл бұрын
You and your channel taught me something; keep up the good job.
@SharonSmith Жыл бұрын
Thank you, Eissa! Thanks for watching my Channel!
@Lynx17862 жыл бұрын
Your explanation is way too simple to understand!! Thanks a lot! ❤ Keep up the great work!!
@SharonSmith2 жыл бұрын
Thanks so much for the nice comment! I appreciate it. Glad you found it helpful. Thanks for watching!
@Lynx17862 жыл бұрын
@@SharonSmith 🙂 💛
@akukiira2 жыл бұрын
Thank you so much. Very clear. I managed to create a simple fillable forms from this guide.
@SharonSmith2 жыл бұрын
That is great to hear! Glad you were able to create a form. Thanks so much for watching!
@jarius03013 жыл бұрын
You should have a million subscribers. Thanks, for your channel.
@SharonSmith3 жыл бұрын
Thanks, Jay! That is very nice of you. Thank you for watching my videos!
@kevin_k_moony2 жыл бұрын
Wow, this is exactly what I was searching for An entire playlist🙏🙏🙏 Really helpful
@SharonSmith2 жыл бұрын
So glad you found it helpful! Thanks for watching!
@dwarfusinterruptus93142 жыл бұрын
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.
@Xirnatts5 күн бұрын
Before you even distribute the form: 1 Create a new sheet with a table that you will use to add up all the answers together. 2 Give that table a name, and add a column for every answer you want to aggregate. 3 Report that answer from the "Form" sheet, either by referencing that cell, or giving it a name and referencing that name. When people fill in your form, that table should populate with their answers in an easy-to-aggregate form. Now, put all the excel files that are returned to you in one folder. Create a new Excel file to aggregate answers outside of that folder, and go to Data>Get Data(Power Query)>From a File>Folder and select the folder with all your Excel files. Select the name of the table you named in 2. Now all of the data will be pulled together into 1 single table. Bonus: you can add or delete files from the folder, and when refreshing your query, this will be reflected. To transform/filter data, read more about Power Queries. I'm late to answer, but hope it helps.
@tutsecret4992 жыл бұрын
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.
@robledoangel2 жыл бұрын
Your video was awesome. Thank you for that information. Now I can apply what I've learned at my job. Thanks again.
@SharonSmith2 жыл бұрын
That is great to hear, Angel! I'm so glad you found my videos helpful. Thanks for watching!
@uniquefall69522 жыл бұрын
:) 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 !!:)
@SharonSmith2 жыл бұрын
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!!
@toniwelch53103 жыл бұрын
Thank you for posting this. Also loving that the Managers are from Psych!!!
@syedikramullah11143 жыл бұрын
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.
@SharonSmith3 жыл бұрын
Hello Syed! Thank you so much for watching my videos. I'm very glad to hear you found them helpful! Take care!
@conradjames35262 жыл бұрын
gotta love good old Bruton Gaster - love that show
@SharonSmith2 жыл бұрын
Me too! 😂 Thanks for watching my videos!
@SharonSmith2 жыл бұрын
Oh yeah, did you hear about Pluto?
@jeannettekelbaugh32167 ай бұрын
This was super helpful. Great instructor skills. Thank you so much. 🙂
@SharonSmith7 ай бұрын
I'm so glad you found it helpful! Thanks for watching!
@brittneyrobinson27612 жыл бұрын
This tutorial was very easy to follow. Thank you.
@SharonSmith2 жыл бұрын
Glad you found it helpful! Thanks for watching!
@eltrompo832 жыл бұрын
I didn't know Tina Fey knew Excel so well!
@SharonSmith2 жыл бұрын
😄 I’ll take that as a compliment. Thanks for watching!!
@gracelee15463 жыл бұрын
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
@brittneyrobinson27612 жыл бұрын
that's a cool document to have.
@mrjdainsworth3 жыл бұрын
What a great video, one of the best tutorial videos iIve ever watched, such a good, unrushed, step by step explanation. Thank you.
@SharonSmith3 жыл бұрын
Thank you Dominic! That is very nice of you. I'm so glad you found it helpful. Thanks for watching!
@sherlynkeiling57822 жыл бұрын
Good video. Once the form has been completed and submitted, is there a way to download or collect the results automatically so that you don't have to manually update a spreadsheet.
@lukerobe17453 жыл бұрын
Hi Sharon - great job! Is there a way to link the answers from the created form, so they autopopulate in a table format in another sheet or workbook?
@michel.70482 жыл бұрын
I don't think it's possible without using VBA
@basilmuhammed97072 жыл бұрын
@@michel.7048 can we do the same with VBA?
@zahir42152 жыл бұрын
Using VBA in Microsoft forms response sheet is not possible, coz response report is an excel online platform.
@atakaai2 жыл бұрын
very clear helpful Sharon you simplify excel .....thank you !
@SharonSmith2 жыл бұрын
You are very welcome! Thanks so much for your kind words and glad you found my videos helpful. Thanks for watching!
@BioLClark2 жыл бұрын
Thank you so much! Just made up a template for trials. Wonderful!
@SharonSmith2 жыл бұрын
Awesome!! So glad you found it helpful, Lindsey! Thanks for watching!
@andusgroup23173 жыл бұрын
Thanks Sharon - great tutorial. Excellent additional skills to my arsenal. 👌🙂
@SharonSmith3 жыл бұрын
Very glad to hear you found it helpful! Thanks for watching my videos! 👍
@jwade123618 ай бұрын
AHHHHH YOURE A PSYCH FAN! Love it!!!!!!
@SharonSmith8 ай бұрын
Yes!! One of my favorite shows 😉! Thanks for watching my videos!
@jwade123618 ай бұрын
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
@hounddogmusic122 жыл бұрын
Wow! So much helpful info and presented in a very easy to understand way. Thanks!! Saved to favorites
@SharonSmith2 жыл бұрын
Awesome! So glad you found it helpful. Thanks for watching and saving me to your favorites!
@joeyboomgaarden8403 жыл бұрын
You have my respect because you had Burton Guster as one of the managers. Psych is the best show 😂😂
@SharonSmith3 жыл бұрын
Yes it is!! One of my favorites too 😄! Some of my earlier Excel tutorial videos feature my fake employee database of TV characters: kzbin.info/www/bejne/h5u7aGWLqtaKn6c Thanks so much for watching my videos!
@cesarlezama12 жыл бұрын
Amazing tutorial Sharon, Thank you!
@SharonSmith2 жыл бұрын
Glad you found it helpful, Cesar! Thanks so much for watching!
@craigfarnham10612 жыл бұрын
This is an excellent tutorial
@SharonSmith2 жыл бұрын
Thank you, Craig! I'm glad you found it helpful. Thanks for watching!
@shohedulislam993 жыл бұрын
Thanks Sharon. Really you are amazing. And You do not know, how much you have benefited me...! Thanks again, & good luck.
@SharonSmith3 жыл бұрын
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.
@shohedulislam993 жыл бұрын
@@SharonSmith :)
@alanstetz76783 жыл бұрын
I really liked the "very hidden" part! I tried to unhide it and I couldn't. I didn't have a project property window open. After I opened that it was all good. Thanks for the tutorial !
@SharonSmith3 жыл бұрын
Hi Alan, so glad you found this helpful! Thanks for watching my videos!
@subhajitbarui30572 жыл бұрын
Thanks Madam! Keep do uploading this kind of videos. It's really informative.🙏🏻
@SharonSmith2 жыл бұрын
Glad to help! Thanks for watching!
@kevin_k_moony2 жыл бұрын
Thanks mam, I want to use this in my office work(I work in the sales department of an Insurance company, lots of Forms and data work), lots of Forms to fill up, I think this will solve my troubles😊
@SharonSmith2 жыл бұрын
I hope this solves your troubles! Thanks so much!
@jimmymiller32273 жыл бұрын
love how she used characters from Psych as her example supervisors.
@SharonSmith3 жыл бұрын
Gotta love Psych! Thanks for watching my videos!
@stephensimiyu67483 жыл бұрын
This is very insightful.....thank you Sharon
@SharonSmith3 жыл бұрын
You are very welcome, Stephen! Thanks for watching!
@navyao11 ай бұрын
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. ; )
@SharonSmith11 ай бұрын
Oh, thank you so much. You are too kind. I'm glad you found my videos helpful. Thanks for watching!
@BruceKasoka2 жыл бұрын
This was so Great Sharon; I appreciate a lot.
@SharonSmith2 жыл бұрын
Thanks so much, Bruce! I'm glad you found it helpful! Thanks for watching!
@wardhively18563 жыл бұрын
You’re a very talented teacher
@SherryReck Жыл бұрын
This is very helpful - thank you. I would have used a radio button instead of a checkbox however, to avoid multiple selections.
@SharonSmith Жыл бұрын
Great tip, Sherry! Yes, if you want to avoid users selecting more than one checkbox, then radio buttons are the way to go. Thanks for watching!
@hgaubaul3 жыл бұрын
You're awesome! Very clearly explained. Thank you
@SharonSmith3 жыл бұрын
Glad you found it helpful! Thanks so much for watching!
@henrydavid22592 жыл бұрын
I think its very important to show how can some one transfere the response to this form to a database particularly when you have tons of similar form
@SharonSmith2 жыл бұрын
Very true, Henry! I'm working on a video on Power Query to show folks how to do this. Be sure to subscribe to my channel and click the bell so you'll receive a notification when I post it. Thanks so much for watching!
@abdikadirabdirahman20322 жыл бұрын
Thanks Sharon Smith. this is a great job well done
@SharonSmith2 жыл бұрын
Thank you for watching! Glad you found it helpful! Take care!
@user-gulb8 ай бұрын
Mam I really appreciate you. Very clearly explain and thanks you so much for sharing your great knowledge about excel.
@SharonSmith8 ай бұрын
Thank you very much! Glad you found my videos helpful!
@salmanilyas1092 жыл бұрын
Amazing I never knew custom forms are possible in excel Allah bless you please made a vedio on collecting data through this custom form .I would really appreciate
@SharonSmith2 жыл бұрын
You are very welcome and thank you for the idea on another video. I will work on it. Thanks for watching!
@lovethatbeach Жыл бұрын
Great content, Sharon! Thank you so much!
@SharonSmith Жыл бұрын
You are very welcome! Glad you found it helpful. Thanks for watching my Channel!
@milbird5 Жыл бұрын
Excellent very well explained
@SharonSmith Жыл бұрын
Glad you found it helpful! Thanks for watching!
@melissalomba3945 Жыл бұрын
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!
@unitedpublication82103 жыл бұрын
You are a great teacher. I have learnt alot
@SharonSmith3 жыл бұрын
Thank you very much! Glad you found my videos helpful. Thanks for watching!
@texmom46973 жыл бұрын
I love it that you’re a Psych fan! 😅
@SharonSmith3 жыл бұрын
One of my favorite shows!! Thanks for watching my videos and taking time to leave a nice comment! Always love to hear from my fellow Psych fans!
@chocomallows25593 жыл бұрын
This is very nice! Since this is a survey, my question is how do you compile the responses? Thank you!
@humbleahmed85583 жыл бұрын
Lol. My question too I guess we have to pay to know that part 🤷
@willaliburd98343 жыл бұрын
Exactly what I needed today!
@SharonSmith3 жыл бұрын
Hi Willa! So glad you found this video helpful. Be sure to check out the video I posted today: kzbin.info/www/bejne/pXnbq3ekeLafrpY 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!
@olaleyeoluwole34423 жыл бұрын
Sharon, you are just an amazing cool and precise teacher. Keep it up! Please, how can forms like this be embedded into other softwares outside excel
@SharonSmith3 жыл бұрын
Hello Olaleye! Thank you for your kind words! If you need to create an online form, you may want to consider using Google Forms. I have a video on this if you are interested: kzbin.info/www/bejne/jHOpgIJ5bcqhjKs Thank you for watching my videos!
@CristianRamirez-jr5yk2 жыл бұрын
Excelente video!!. Mi Ingles no es tan bueno porque, pues, hablo español jaja, pero aun así logre entender bastante ya que tu video esta tan bien hecho que incluso con solo las imágenes te haces una idea bastante clara de lo que se quiere decir. Muchas gracias.
@SharonSmith2 жыл бұрын
¡Muchas gracias, Cristian! Me alegro de que te haya gustado mi video a pesar de que estaba en inglés. No hablo español, pero puedo usar Google Translate. 😊 ¡Muchas gracias por verlo!
@The-Singularity-M87 Жыл бұрын
Outstanding lecture!
@SharonSmith Жыл бұрын
Glad you found it helpful! Thanks for watching!
@lucysheehan6972 жыл бұрын
Hi Sharon, is it possible to transfer the data collected from the excel into a spreadsheet? if so, how is it done? many thanks.
@dennismwangi35733 жыл бұрын
Learnt a lot there. I've encountered situations where this information could be very helpful. Esp designing such docs/workbooks for my clients who may need them for research work in the field. Working in a cyber in Kenya, this will definitely help my work.
@SharonSmith3 жыл бұрын
Hi Dennis! So glad to hear you found my videos helpful! Thanks so much for watching!
@keremozturk52353 жыл бұрын
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!
@Xirnatts5 күн бұрын
Before you even distribute the form: 1 Create a new sheet with a table that you will use to add up all the answers together. 2 Give that table a name, and add a column for every answer you want to aggregate. 3 Report that answer from the "Form" sheet, either by referencing that cell, or giving it a name and referencing that name. When people fill in your form, that table should populate with their answers in an easy-to-aggregate form. Now, put all the excel files that are returned to you in one folder. Create a new Excel file to aggregate answers outside of that folder, and go to Data>Get Data(Power Query)>From a File>Folder and select the folder with all your Excel files. Select the name of the table you named in 2. Now all of the data will be pulled together into 1 single table. Bonus: you can add or delete files from the folder, and when refreshing your query, this will be reflected. To transform/filter data, read more about Power Queries. I'm late to answer, but hope it helps.
@mchammer55926 ай бұрын
You misspelled Bruton Gaster 🤣. Great reference
@SharonSmith6 ай бұрын
One of my favorite shows!
@carabrookins565710 ай бұрын
But, then what? I love the video and how clearly you explain everything, but I need a part two because I don't know how to collect the data. I'd love to input it into another sheet on the form. Is this possible?
@NatalieDunn05026 ай бұрын
Really great tutorial, thank you!
@SharonSmith6 ай бұрын
Glad you found it helpful! Thanks for watching!
@tutsecret4992 жыл бұрын
Sweet lady, I would use password too when situation requires. Thank you for your tutorial.
@SharonSmith Жыл бұрын
Glad you found the video helpful! Thanks for watching!
@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!
@karolinagrygiel1783 жыл бұрын
Very useful tips here 👍🏼 thank you Sharon!
@SharonSmith3 жыл бұрын
Thank you Karolina! Glad you found my videos helpful! Thanks so much for watching and taking time to leave a comment!
@MohamedOuttilmirath136552 жыл бұрын
That was crystal clear. Thanks a lot. I really enjoyed it and I did put it to practice.
@SharonSmith2 жыл бұрын
That is great news! So glad you found this video helpful. Thanks for watching!
@mariesalazar42703 жыл бұрын
New subscriber here!! You just gave a great idea! Thank you!
@SharonSmith3 жыл бұрын
So glad to hear it! Thanks for subscribing to my channel and watching my videos. I really appreciate it!
@taychorhwee35162 жыл бұрын
Thank you!. Well presented.
@SharonSmith2 жыл бұрын
You are very welcome! Thanks for watching!
@patricknumi35392 жыл бұрын
Excellent presentation, very educational.
@SharonSmith2 жыл бұрын
Thank you, Patrick! So glad you found it helpful. Thanks for watching!
@lmd48812 жыл бұрын
this is amazing!! :) I had no idea that you could make a fillable form with excel :)
@SharonSmith2 жыл бұрын
I'm so glad you found it helpful! Thanks so much for watching!
@UnitedCanuck Жыл бұрын
Thanks. Great tutorial.
@SharonSmith Жыл бұрын
Glad you found it helpful! Thanks for watching!
@stgermain10743 жыл бұрын
"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.
@user-cq9ls1lw7i Жыл бұрын
Great video! Thank you! 🙂
@SharonSmith Жыл бұрын
Glad you found it helpful, Norma! Thanks for watching!
@natel7545 Жыл бұрын
Very helpful, thank you!
@SharonSmith Жыл бұрын
Glad you found it helpful! Thanks for watching!
@myfavourites62263 жыл бұрын
Thanks Sharon, it's helpful
@PaulSchwartzmeyerxxx3 жыл бұрын
I love this gal. This video is sooo well done
@SharonSmith3 жыл бұрын
Thanks so much for watching my videos, Paul! I appreciate it!
@azpapi3 жыл бұрын
Excellent! You're an excel queen!
@SharonSmith3 жыл бұрын
Thanks so much! I appreciate you watching my videos!
@ikramqalib68523 жыл бұрын
Dear mam you really help me to do work in easy way . many thanks .
@SharonSmith3 жыл бұрын
You are very welcome, Ikram! Glad you found my video helpful. Thanks so much for watching!