I’ve created a video describing how to make this in Excel and you can get it HERE.
Also, I’ve created a template that you can download and use HERE.
Finally, HERE is the YouTube video instructions.
As many of you know, I’m a huge proponent of the communication style of Why, then How, then What. Because of this, I’ve come across a lot of opinionated information – asking people why they may want or do something, how they do it, and then what it is they actually do.
Not long ago I sent a survey out to my co-workers asking them why we do a few things as an organization to start a mission statement for the group I was tasked with forming. This brought back a bunch of results with no, absolutely none, data to work with. For a couple years now, as well, I’ve been collecting surveys from our training clients (with a few questions to be hand-written) to see how we might better serve them and improve in our quality. It’s great having that information, but can we really interpret these opinions into actionable paths for improvement? Maybe. If there are a few.
So, I started researching and finally built a tool (in Excel) to turn opinions into measurable results; in more technical terms – qualitative results into quantifiable data.
This is a valuable tool for anyone that wants to rightly know what clients, employees, friends, groups, or even one’s self, are thinking, want, need….
Simply, send out a survey:
- In a class
- On Facebook
- As an email
- Using MailChimp
- A pros and cons list
- Whatever
Use the results with this method, and you’ll have the DATA you want to make the decisions you see best.
This tool was built in Excel, however, the concept can be used in any logic program I believe.
Below I describe the process:
- Get your survey responses
- Enter them into a data bank (some electronic tool or list that can sort and assign)
- Create overarching categories that describe all the variables in the responses
- ex.
- ex.
- Assign the categories a code
- Go through all of the responses and assign them a category code
- Sum the results of each category
I’ve created a video describing how to make this in Excel and you can get it HERE.
Also, I’ve created a template that you can download and use HERE.
Hopefully, this brings some enrichment to your life. I know it is to me. If you have any feedback, comments, questions, etc I’d be really happy to hear from you.
Thanks for reading,
Jase
Incredible! I just finished reading your blog post and I’m absolutely amazed. Your insight on this topic is spot-on. I’ve learned so much and can’t wait to see what you write next. Your work is inspiring!
Amazing! I recently read your blog post and I’m absolutely amazed. Your insight on this subject is incredibly insightful. I’ve learned so much and can’t wait to read more. Your work is inspiring!
wow, amazing
nice content!nice history!! boba 😀
Amazing! I recently read your post and I’m blown away. Your analysis on this topic is spot-on. I’ve learned so much and am eager to see what you write next. Thanks for sharing!
Incredible! I just finished reading your post and I’m blown away. Your analysis on the topic is incredibly insightful. I’ve learned so much and can’t wait to see what you write next. Your work is inspiring!
Wow! I just read your article and I’m absolutely amazed. Your analysis on the topic is spot-on. It really made me think and can’t wait to see what you write next. Keep up the great work!
Incredible! I recently read your article and I’m absolutely amazed. Your analysis on this topic is spot-on. I’ve gained a new perspective and can’t wait to see what you write next. Thanks for sharing!
lost money
phising
lost money
phising
Wow! I recently read your article and I’m absolutely amazed. Your analysis on this subject is extremely valuable. It really made me think and am eager to read more. Your work is inspiring!
lost money
Wow! I just finished reading your blog post and I’m thoroughly impressed. Your analysis on this topic is extremely valuable. It really made me think and am eager to see your next post. Keep up the great work!
Incredible! I just finished reading your post and I’m absolutely amazed. Your analysis on this subject is spot-on. I’ve learned so much and can’t wait to read more. Your work is inspiring!
Amazing! I recently read your article and I’m blown away. Your analysis on this topic is spot-on. It really made me think and can’t wait to read more. Thanks for sharing!
Wow! I recently read your article and I’m thoroughly impressed. Your analysis on this topic is spot-on. I’ve gained a new perspective and can’t wait to read more. Keep up the great work!
Incredible! I just read your post and I’m blown away. Your analysis on the topic is spot-on. I’ve learned so much and can’t wait to see your next post. Your work is inspiring!
lost money
phising
lost money
lost money
Fantastic! I just read your post and I’m blown away. Your insight on this subject is extremely valuable. I’ve learned so much and can’t wait to read more. Your work is inspiring!
phising
Fantastic! I just finished reading your article and I’m blown away. Your analysis on this subject is extremely valuable. I’ve learned so much and can’t wait to see your next post. Keep up the great work!
scam
phising
phising
scam
Fantastic! I just read your post and I’m thoroughly impressed. Your insight on this topic is extremely valuable. It really made me think and am eager to see your next post. Keep up the great work!
Wow! I just finished reading your post and I’m blown away. Your perspective on this topic is extremely valuable. It really made me think and can’t wait to see your next post. Your work is inspiring!
lost money
lost money
scam
Incredible! I recently read your blog post and I’m absolutely amazed. Your insight on this topic is incredibly insightful. It really made me think and am eager to read more. Your work is inspiring!
Wow! I recently read your article and I’m blown away. Your perspective on this topic is incredibly insightful. It really made me think and can’t wait to see what you write next. Your work is inspiring!
phising
phising
phising
lost money
lost money
lost money
phising
scam
phising
Amazing! I recently read your blog post and I’m absolutely amazed. Your analysis on the topic is incredibly insightful. I’ve gained a new perspective and am eager to see your next post. Thanks for sharing!
Fantastic! I recently read your article and I’m blown away. Your perspective on this topic is spot-on. I’ve learned so much and am eager to see your next post. Thanks for sharing!
lost money
scam