In Creating Fillable Forms in Word Lesson 15, you will learn how to export form field results to Excel. You will learn how to save completed forms as text files with extracted form field data, and then how to import that data into Excel using Power Query. We will link a file folder to the Power Query so that as you save multiple completed forms in that folder, you can refresh your data in Excel and load additional results as they come in. Once you have your data in Excel, you can further analyze it through filtering, pivot tables, and more.
COURSE: Creating Fillable Forms in Microsoft Word – A Step-by-Step Guide
Introduction
Lesson 1: Microsoft Word Form Overview
Lesson 2: Form Field Types & Functionality
Lesson 3: Content Control Form Fields
Lesson 4: Legacy Form Fields
Lesson 5: Building a Form Template from Scratch
Lesson 6: Enforce Form Field Number Formatting
Lesson 7: Create Multiple Level Dependent Drop-Down Lists
Lesson 8: Make Form Fields Required
Lesson 9: Link Text to Drop-Down Selection
Lesson 10: Make Form Fields Repeat
Lesson 11: Calculating Form Fields
Lesson 12: Insert a Submit Button
Lesson 13: Lock Forms or Parts of Forms
Lesson 14: Test & Distribute your Form
Lesson 15: Collect & Analyze Results
Wrap-up Creating Fillable Forms in Word
__________
CONNECT WITH ME 📎
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
Instagram: https://www.instagram.com/sharonsmithlearn/
Facebook: https://www.facebook.com/profile.php?id=100090910316584
__________
TEMPLATES
Check out my helpful list of templates available for purchase: https://www.etsy.com/listing/875846662/employee-engagement-survey-ms-excel?ref=listing_published_alert
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
GEAR
🎙 Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
🎥 Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
📗 Green Screen: https://amzn.to/2DnHsY2
📸 Camera: https://amzn.to/39KvpQA
🔌 Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top-notch webcam)
RESOURCES
✏️ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog
📑 Wondershare PDFelement (PDF Editor): https://bit.ly/31QEkA8
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
NOTE: If you found this content helpful, please consider donating to my channel, either by clicking the YouTube Super Thanks button under my videos, or from this PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url. Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS
✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
PLAYLISTS:
➤ Jotform Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD
➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv
➤ Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45
➤ Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90
➤PowerPoint Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM
➤ Excel Tips & Tricks (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW
source
como comprar um site , Collect and Analyze Results – Create Fillable Forms in Word Course Lesson 15
