Create data entry forms in MS Excel using your questionnaire

Hi, I am Raj Kumar Subedi
Simple technique to prepare data entry form using MS-Excel.
Thank you.

[mohaamdoi]

Wow you are real teacher sir.
Thank you

[bmathur]

Thank you so much...very helpful video, the way you teach is 👌🏻

[splham]

well thanks for the video, but I came across a problem. Excel cannot handle too many variables, is there a way we can adjust?

[tutsecret]

After the set up is final, the data input will be from a hard copy questionnaire and/or from an online or from another file? I ask because, it would better set up something that automated the answers behind the scene at the time the user fills out the form.

[tutsecret]

About my comment below, the user/responder should input the answer to automate the answers behind the scene, instead of the survey person entering the responses. Can you imagine if the questionnaire is for dozen, hundred, thousand people, impacting the survey person to input each answer somewhere to be used for analysis, and it will be massive time consuming, physical stress on the hands and expensive. Almost 20 years ago, I did a project for somebody to automated this scenario, but I don't remember how I did, I lost the backup disk. I will try to remember and recover the project. The project was very neat, with few clicks and password, all the answers available and calculated. It was a breeze and the survey person does not do any input, instead is the responder.

[tejasvibhosale]

Sir how to do unique coding for each columns

[swastikaanand]

I do not have the option of files in my excel :'(

[yogeshmahindrakar]

can we add dropdown list in this data entry form ? If yes please guide me.

[m.thuring]

Hi Raj. Besides the technical aspect related to Excel you should also pay attention to the examples that you give. It seems that in your example all males passed the exam, but the female failed. It is clearly a mindset that needs to change here! It may seem like looking for things that are not about what you actually want to communicate, yet here it is! Because of this, I will not recommend your video.