Explore the value of taking time to design your form before building it.
- [Instructor] Before commencing the development…of an Office 365 form,…I strongly recommend you take the time…to design the inputs first.…Investing this effort up front…will save an incredible amount of time…in the long run.…And reduce the risk of collecting irrelevant data.…To design a form, I like to use Excel Online.…And here's a file that I prepared…a little bit earlier.…If you'd like to follow along…have XOL FormDesign open.…What you'll notice in this table…is that I have pre-populated…a form title, a form description,…and questions with additional information…to the right.…
This helps to prepare the questions…to be seamlessly loaded into the Office 365 forms app.…Let's say that we want to prepare…an additional question now.…Let's go to the very bottom of the list,…question number five.…And the additional question that I want…to add to my design file is,…"Do you have any suggestions on how to improve the course?"…I'm going to make the option type text.…Options not applicable.…The same for multiple answers.…And I actually want this to be…
- Creating and editing workbooks
- Using Excel Online shortcuts
- Integrating the desktop version of Excel
- Sharing workbooks and assigning access privileges
- Creating and editing charts
- Designing and creating forms
Skill Level Beginner
1. Getting to Know Excel Online
2. Working Seamlessly with Excel Online and Excel Desktop
3. Collaborating with Excel Online
4. Charting in Excel Online
5. Creating Forms with Excel Online
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.