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

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.

💻 DOWNLOADS FOR PURCHASE
Zip Code Lookup Template [Excel] https://spotlightimpact.gumroad.com/l...
Square Carousel Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
10 Minute Timer Slide Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
Net Promoter Slider Chart Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
Waffle Chart Template [Excel] https://spotlightimpact.gumroad.com/l...
Data Placemat or Dashboard Template [PowerPoint] https://spotlightimpact.gumroad.com/l...

🙏 SUPPORT MY CHANNEL
SUBSCRIBE to this channel for more tips, tricks, and tutorials!    / @spotlightimpact  
JOIN Spotlight Super Fans for early access to weekly tutorials    / @spotlightimpact  
HIT the SUPER THANKS 💗 button on any video!
DOWNLOAD templates from on Gumroad https://spotlightimpact.gumroad.com/
DOWNLOAD templates from Payhip https://payhip.com/spotlightimpact
BUY stickers, I 💗 CHARTS! https://spotlightimpact.creator-sprin...

🎒 COURSES & TRAINING AFFILIATES
Depict Data Studio Courses https://depictdatastudio.teachable.co...
Excel University https://affiliate.excel-university.co...
Miss Excel (Opens monthly) https://links.miss-excel.com/exclusiv...

🙋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