Instructor Josh Rischin outlines 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 taking the time to design it 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 use Excel Online…and here's one that I prepared earlier.…If you'd like to follow along, open up XOL FormDesign.…You will notice that I've pre-prepared…a form title Feedback on Learning Excel Online course.…I've also pre-populated a description.…
I then have a list of questions…with additional information off 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.…Go to the very bottom of the list,…and I'm going to make this question number five,…do you have any suggestions on how to improve the course?…For the rest of the information,…I'm going to make it exactly the same as question four,…by copying and pasting.…In this particular case though,…
Note: This course is for users who know the basics of the Excel desktop app, but are new to the web browser version, Excel Online. It emphasizes features that work differently in Excel Online. For basic Excel guidance, please see Learning Excel 2016 or Excel 2016 Essential Training.
- Creating and editing workbooks
- Integrating the desktop version of Excel
- Sharing workbooks and assigning access privileges
- Creating charts
- Designing forms and surveys