Hello I’m glad you like it, for my newer videos, I have downloadable samples but not my older ones. If you go to www.xlconsulting-asia.com/youtube-files.html you will see the available files
Thats just awesome! You saved my life :)) Can you create a content also about how to transform likert text (strongly disagree, disagree, neutral, agree, strongly agree) into nimeric: 1, 2, 3, 4, 5 values ? Please... I do that replace thing manually in my rae data table now - would be great to see that automated too (flow is way too complicated, I tried that too...) 🙏🏻
Thank you! I'm glad you like it... With Google Forms/Sheets its hard they don't have a Power Query equivalent, not even in data studio so for the moment I would say using dynamic array functions like QUERY would be needed, I have a video on using the QUERY function you may want to review
@@learnspreadsheets Thanks for the reply! :D Apps pinned on someone's taskbar have more than once been a great way to find really good apps/tools. It was Snaggit and Canva that got my attention. Do you find Canva docs better than MS Word?
hi I noticed all your videos does not contain the practice files in a subject like power query qnd Bi in general unless you practice you will not learn so if you share the files that will be good thanks
nice , please put excel file in the description video
Hello I’m glad you like it, for my newer videos, I have downloadable samples but not my older ones. If you go to www.xlconsulting-asia.com/youtube-files.html you will see the available files
awesome great video - I love excel power tools
Paula! Yesss shoutout to the Power Qwarriors everywhere!
Thats just awesome! You saved my life :))
Can you create a content also about how to transform likert text (strongly disagree, disagree, neutral, agree, strongly agree) into nimeric: 1, 2, 3, 4, 5 values ? Please...
I do that replace thing manually in my rae data table now - would be great to see that automated too (flow is way too complicated, I tried that too...) 🙏🏻
Glad you liked it! Ooh good idea, I'll make a video to show it!
Interesting tutorial, pretty advanced.
Is there a way to do this with Google sheets, data studio?
One can pull the info directly from Google forms
Thank you! I'm glad you like it... With Google Forms/Sheets its hard they don't have a Power Query equivalent, not even in data studio so for the moment I would say using dynamic array functions like QUERY would be needed, I have a video on using the QUERY function you may want to review
Thanks for this. Do you have a video on likert scale data analysis
Glad you like it, not yet but I plan to make one soon!
I woud like to use the Slider to change the language of the Questions, is it possible?
There is a translation tool within forms, from the settings menu which could help for sure, if you don’t see it look it up & you’ll see an explanation
What are the apps on your taskbar?
Lol, OneNote, Snaggit, Canva, Telegram, Magnifier, Zoom, Teams, Power BI, MS Office Apps
@@learnspreadsheets Thanks for the reply! :D Apps pinned on someone's taskbar have more than once been a great way to find really good apps/tools. It was Snaggit and Canva that got my attention.
Do you find Canva docs better than MS Word?
hi I noticed all your videos does not contain the practice files in a subject like power query qnd Bi in general unless you practice you will not learn so if you share the files that will be good thanks
Thanks for the feedback, my newer videos have files on request, my older ones don’t, but I’ll pay attention in future to having them