Hi David, great video! You mentioned that you have another video which explains how to analyse data from Microsoft Forms in Excel when there are a continuous stream of new responses. Are you able to send the link to this video? Thanks!
Hey! Glad you like it, I have around 4 videos which describe analysing forms data in excel, this one shows that but if you search in my channel you can find more! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UoEwPKLjoeU.html
Hey David, thank you for the video :) I wanted to know if I can do this the same way you did when I have more than one likert question in my forms. So in my case instead of E-Mails, Chatapp and Teams, I have 5 car manufacturers and instead of percentage I have a scale from 1-5. This structure continues for 10 different likert questions. And if I do it the same way you did the Powerquery changes a bit in structure. I‘m a bit confused and I‘d be glad if you‘d help me out here 😄
The same method is adaptable for your situation for sure, the video should explain how, if it doesn’t help I could offer consulting support under my company, you can email me on david@xlconsulting-asia.com
Hi David. Thanks for the videos, they are proving very helpful with my final year project for university. I have a quick question. When I import my data from Forms into Excel, the columns containing the answers from my likert questions are not titled with the statement from the Form itself ie: "Access to the countryside is a fundamental human right", instead it just says "Column 1, Column 2, Column 3 etc." Any ideas?
