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

Published: 15 May 2024
on channel: Spotlight Impact Data Design

32,889

172

⚡ 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

On this page of the site you can watch the video online How to Connect Excel to Microsoft Forms 🔥 [SURVEY TIPS!] with a duration of hours minute second in good quality, which was uploaded by the user Spotlight Impact Data Design 15 May 2024, share the link with friends and acquaintances, this video has already been watched 32,889 times on youtube and it was liked by 172 viewers. Enjoy your viewing!