How to Connect Excel to Microsoft Forms 🔥 [SURVEY TIPS!]

Veröffentlicht am: 15 Mai 2024
auf dem Kanal: Spotlight Impact Data Design
38,664
205

⚡ Support my channel with a $1.99 membership (cancel anytime!)    / @spotlightimpact  

In this step by step tutorial you'll learn how to connect a Microsoft Form to an Excel file so that as your Form collects data it feeds into Excel in real time! The trick is to start with Excel! (Insert Form) and remember to have the Excel file saved in OneDrive or SharePoint. You can even make changes to the questions in the form and it will automatically update in the Excel file.

📣 SHOUTOUTS
I picked this tip up from Laura Devine who shared it on the Presentation Guild’s Slack workspace. Thanks Laura! You rock 🙌🏼 Check out the PG at www.presentationguild.org
Grab the best survey design book in the biz, Designing Quality Survey Questions by Shelia B. Robinson and Kim Firth Leonard. Link above 👆 or in video.

🙏 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 #microsoftforms #surveytips


Auf dieser Seite können Sie das Online-Video How to Connect Excel to Microsoft Forms 🔥 [SURVEY TIPS!] mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Spotlight Impact Data Design 15 Mai 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 38,664 Mal angesehen und es wurde von 205 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!