How to Analyze Check-All-That-Apply Survey Questions in Excel ✅ [MS FORMS!] скачать в хорошем качестве

How to Analyze Check-All-That-Apply Survey Questions in Excel ✅ [MS FORMS!]

⚡ Support my channel with a $1.99 membership (cancel anytime!)    / @spotlightimpact   One problem I've had with Microsoft Forms (and Google Forms) is in how it exports 'select all that apply' survey question data to Excel. Forms exports all responses into a single cell and you really want each response to be in it's own cell and column for easy analysis. In this step by step tutorial you'll learn how to use this clever Excel formula (courtesy of ‪@MrXL‬ ) to transform that data export to a more useful format for analysis and summarizing your survey data. Here's the formula from the video: =countif($B2,"*"&C$1&"*") Copy the formula here, drag it over and down your cells and VOILA! 🌟 Your survey data analysis will be a breeze with this little trick! Stay tuned to the end to see my favorite data table trick....Paste Special-Transpose ⌚TIMELINE 00:00 Ahoy 04:45 The magic formula to un-concetenate your select-all-that apply data 📣 SHOUTOUTS Thanks to Mr. Excel for this helpful tip!    • Excel IF Contains - Episode 2514   🙏 Support My Channel SUBSCRIBE for more tips, tricks, and tutorials!    / @spotlightimpact   JOIN for early access to weekly tutorials    / @spotlightimpact   DOWNLOAD templates from Gumroad https://spotlightimpact.gumroad.com/ DOWNLOAD templates from Payhip https://payhip.com/spotlightimpact CHART 💗 STICKERS! https://www.charthearts.com/ SHOP on Amazon with my link https://www.amazon.com?&linkCode=ll2&... 💻 Download Templates ZIP Code Lookup Template [Excel] https://spotlightimpact.gumroad.com/l... Carousel Template [PowerPoint] https://spotlightimpact.gumroad.com/l... 10-Minute Timer Slide Template [PowerPoint] https://spotlightimpact.gumroad.com/l... Data Placemat Template [PowerPoint] https://spotlightimpact.gumroad.com/l... 🎒 Courses Depict Data Studio Courses https://depictdatastudio.teachable.co... Excel University https://affiliate.excel-university.co... 🛒 My Gear Microsoft 365 http://www.amazon.com/dp/B07F3TQ6DQ/r... Laptop http://www.amazon.com/dp/B09K4GKQRZ/r... Webcam http://www.amazon.com/dp/B09NBWWP79/r... Mic http://www.amazon.com/dp/B007JX8O0Y/r... Tripod http://www.amazon.com/dp/B0DP4MLMR2/r... 📚 Reads Building PPT Templates V2 http://www.amazon.com/dp/B09GL757ZJ/r... PowerPoint Mastery http://www.amazon.com/dp/B0F2M7ZQYG/r... The Reporting Revolution http://www.amazon.com/dp/B0G19PWNM6/r... Presenting Data Effectively https://amzn.to/3NxEwvW Effective Data Visualization https://amzn.to/49Kz4P7 🙋FAQs I’m using Microsoft 365 in my videos - PowerPoint, Excel, Word. If you don't have a feature you see here check the Microsoft support pages for a version feature list https://support.microsoft.com/en-us Buying courses through affiliate links above costs no extra, but gives a small percentage of the proceeds to my channel. #excel #survey #microsoftforms