That is very nice, is there a way to add a rest button for the fist table,as well any function to avoid copy paste to the analysis table? . Please advise. Thank you
Excellent job and thanks for sharing your knowledge with others. I have a question: Is it possible to send automatically an email by Excel in determined day in calender for example on last Monday of each month, Thanks advance.
Hi! Is there a way to automate this? If you are for example going to send to hundreds of participants and would like to analyze data after.. Thank you!
Hello Michelle, This might sound odd (but it is my honest answer): What I try to do with my videos is to show the viewers tools they can use in their daily routine so they can finish their work faster and go and enjoy life! That said, if you have hundreds of participants, my recommendation would be to use a professional service like Survey Monkey for example www.surveymonkey.com/ You can also use create surveys with Google Forms www.google.ca/forms/about/ I have used both and they work great!!! Let me disclose that I get ZERO commission from neither Survey Monkey nor Google. It is just a recommendation based on my experience. Like I said, this comment might sound odd being that my channel is in Excel, but I feel that’s my most honest answer. Good luck Michelle and thanks for watching! T-E-CH
sir i would like to know as "how to copy paste group boxes for multiple option buttons into separate groups of its own. Eg . I have a survey quesstionnaire of 90 questions and each has its options of Likert scale of 5 points .To group each button under each question is very tuf manually.Kindly expalin.
Hello Sardorbek. If you have more than one possible choice to each question, my recommendation is that you use a CHECK BOX instead of an OPTION BUTTON. Refer to the minute 1:38 in the video to see exactly where I display the INSERT CONTROLS MENU. Once you insert the Check Box, you will control it in the same way than the Option Button. I have an example of the use of Check Boxes in my video "Create a progress tracker with check boxes in Excel". I leave you the link here in case you want to check it out. ua-cam.com/video/gbDKwYPC4MI/v-deo.html I believe this answers your question. Thanks for watching and Happy New Year!!! T-E-CH
Hi Mike, good question. There are several ways you could get the file to your customers. 1) Yes, one of them is by email and ask them to get you an answered survey after saving the changes. 2) You could have the file in a website or a shared folder (for example Google Docs or DropBox) and have them download the file, answer it and email it to you. 3) You could provide them with access to a computer - I do not know what kind of business you do but I'm assuming at some point your customers come to your place (kiosk? store? office?) 4) You could fill the file with them on your computer. Anyway, these are only some ideas I can think of right now. Ultimately you will come up with the best one. I am trying to share the tools with the community so everyone can improve them from there. Please subscribe to our channel - if not already - so you can catch all the videos we're constantly sharing. Thanks for watching.
Hello gdgdgdgdgdgdg. Please watch this video where I show INDEX anMATCH and a combination of both: m.ua-cam.com/video/UfvhhbMBDO8/v-deo.html This one is a good example to understand INDEX and MATCH.
Brilliant tutorial - best part was common ,mistakes, really helpful!! Thank you so much for such useful content :)
thank you very much sir you really gifted. it helps so much
Impressive! Obviously experienced! Thanks
We have some serious Excel skills in here! Kudos man!
Hi very good video. Is it possible to make the grouping box invisible?
That is very nice, is there a way to add a rest button for the fist table,as well any function to avoid copy paste to the analysis table? . Please advise.
Thank you
i put the code today . take a looke to my comment.
Thanks man...., This vedio very helpful in one of my project ....🥳
Excellent - thank you☺
Excellent information! I'll put this to practice to evaluate my suppliers
Glad you find it helpful!
Hello Great tutorials, is it possible to export and send this survey to a customer email to get their feedback?
hi this is very good but how to create multiple responders and automate the survey after completing the survey
I am searching for the same answer. Please guide if you have answer
Great tutorial, thank you!! Question though -- is there a way to return specific text instead of a number in the linked cell?
great Video!!!
Very informative and nicely presented dude. Can we give our own values to check boxes. For example poor is 3, fair is 5 , good 8 very good 10
Excelente! Parabéns!!
How do you do the same thing only horizontally, with the radio buttons all in one row, and copied to the next?
please tell that how to create a reset button to reset these selected radio buttons please help
Excellent job and thanks for sharing your knowledge with others. I have a question: Is it possible to send automatically an email by Excel in determined day in calender for example on last Monday of each month, Thanks advance.
What can you do to avoid copying and pasting each survey manually?
Hi!
Is there a way to automate this? If you are for example going to send to hundreds of participants and would like to analyze data after..
Thank you!
Hello Michelle,
This might sound odd (but it is my honest answer):
What I try to do with my videos is to show the viewers tools they can use in their daily routine so they can finish their work faster and go and enjoy life!
That said, if you have hundreds of participants, my recommendation would be to use a professional service like Survey Monkey for example www.surveymonkey.com/
You can also use create surveys with Google Forms www.google.ca/forms/about/
I have used both and they work great!!!
Let me disclose that I get ZERO commission from neither Survey Monkey nor Google. It is just a recommendation based on my experience.
Like I said, this comment might sound odd being that my channel is in Excel, but I feel that’s my most honest answer.
Good luck Michelle and thanks for watching!
T-E-CH
@@TheExcelChallenge thank you!! ☺️
i put the code you need today look at it
Hi Sir, may i know how to limit the respondent to select only one option buttons? I have put group box but no effect on this. Please help.
same situation here
sir i would like to know as "how to copy paste group boxes for multiple option buttons into separate groups of its own.
Eg . I have a survey quesstionnaire of 90 questions and each has its options of Likert scale of 5 points .To group each button under each question is very tuf manually.Kindly expalin.
Please let me know if you get solution to this
It's possible to do design, engineering and procurement trackers
So great! But I have one question how to change the value of the options? For example, 02468 instead of 12345
Use Vlookup with option result.
How would we do, if we are going to create a survey for multiple choice questionary where it includes more than two possible choices?
Hello Sardorbek.
If you have more than one possible choice to each question, my recommendation is that you use a CHECK BOX instead of an OPTION BUTTON.
Refer to the minute 1:38 in the video to see exactly where I display the INSERT CONTROLS MENU. Once you insert the Check Box, you will control it in the same way than the Option Button.
I have an example of the use of Check Boxes in my video "Create a progress tracker with check boxes in Excel". I leave you the link here in case you want to check it out.
ua-cam.com/video/gbDKwYPC4MI/v-deo.html
I believe this answers your question.
Thanks for watching and Happy New Year!!!
T-E-CH
sir super
sir is there away after plotting a curve to get a value on y-axis when inputting a value on x-axis in a ref -cell
How can I merge these XL’s?
Hi Sir, we have some problem to create group box kindly assist
Hello Shan. What is the problem?
T-E-CH
How to work analyse ranks in excel
How would you send to customers? Email?
Hi Mike, good question. There are several ways you could get the file to your customers.
1) Yes, one of them is by email and ask them to get you an answered survey after saving the changes.
2) You could have the file in a website or a shared folder (for example Google Docs or DropBox) and have them download the file, answer it and email it to you.
3) You could provide them with access to a computer - I do not know what kind of business you do but I'm assuming at some point your customers come to your place (kiosk? store? office?)
4) You could fill the file with them on your computer.
Anyway, these are only some ideas I can think of right now. Ultimately you will come up with the best one. I am trying to share the tools with the community so everyone can improve them from there.
Please subscribe to our channel - if not already - so you can catch all the videos we're constantly sharing. Thanks for watching.
Sir, I have problems to understand the index and match function in excel. Could you give any video where it is easily understood
Hello gdgdgdgdgdgdg.
Please watch this video where I show INDEX anMATCH and a combination of both:
m.ua-cam.com/video/UfvhhbMBDO8/v-deo.html
This one is a good example to understand INDEX and MATCH.
Instead of 1 I need 0 how to customize?
Hello Aftab. You can create a formula and add a -1 where applicable.
@@TheExcelChallenge many thanks🤝