Increase Productivity with OneDrive for Business

OneDrive for Business is a place where you can store, share and sync your work files. It is an amazing way to make your digital life more efficient and productive, with very little effort.

Your files can be updated from any device with OneDrive for Business installed, and OneDrive also allows you to work on documents with others at the same time.

A useful, yet less-known, function of OneDrive is the ability to host online surveys. Use our guide below to quickly create and analyse surveys and questionnaires with your team, other departments or even external stakeholders. (You may also wish to attend some OneDrive training, part of our Office 365 one day courses that we run.)

Host an Online Survey in OneDrive for Business

Instead of distributing printed surveys, or using email to distribute surveys, a much more productive way of doing this is using a combination of OneDrive and Excel Online.

You can design great looking surveys in Excel Online and afterwards these can be shared from OneDrive.

Getting Started

Log in to OneDrive, then select New at the top of the window. From the list, select Forms for Excel. In the box which pops up, enter a name for the Excel file which you are creating to gather and analyse the survey results.

Example of hosting surveys in OneDrive
Example of a soft skills training programs Survey Creation

When you click Create, you are taken to Forms in Excel. Here, you can rename the survey, add a description and set up survey questions. The question types include

  • choice lists
  • text responses
  • ratings
  • dates
  • rankings
  • likert scales (multi statement, multi choice questions)
  • net promoter scores (feedback)

When using choice questions, you can add more choices to the default two. You can enable multiple answers and you can make certain questions required. “Other” can also be added as an option. Certain choice questions also trigger auto suggestions, like weekdays.

Modifying Settings

Text questions have the option for the user to set restrictions, e.g. when the answer needs to be a number. Simply select the ellipses buttons to the right of the question to change the restrictions. If you want a larger box for text answers, select “Long Answer”. Questions can easily be rearranged or deleted.

There are many themes to choose from, and before publishing or sharing the survey can be previewed. The form layout will adapt to the device used to view it, whether on a computer, a tablet or smartphone.

Sharing your Survey

Once you are happy with the survey, it can be shared via a hyperlink. Make sure to specify who can respond to the survey, whether this includes only people inside the organisation or anyone with the link. Two additional options are available if you wish the survey to only be filled out by people inside your organisation.

You can select Record Name if you would like each form response to include the name and email address of the person responding. If this option is cleared, anonymous responses will be allowed. If you want to limit the number of responses to one per person, select the option One response per person.

To restrict the collection duration of survey responses, you can specify start and/or end dates and times from the Settings menu in the top right of the Forms window.

Collecting Responses

When people complete the survey, responses are automatically sent straight to the Excel file saved to OneDrive. As the survey host, you will be able to see a summary and analysis of all survey responses in the Excel file.

Try hosting surveys this way to make it much easier to collect survey data, and of course to help you become more time efficient.

For information on other productivity apps, please follow the link below:

5 reasons to Upgrade to Windows 10

Is it worth taking advantage of the Free Upgrade to Windows 10?

Microsoft are offering Windows 10 as a Free upgrade for Windows 7/8 users. Why should you upgrade, is it really worth it? Windows 7 users are decidedly hesitant, after all, Windows 8 removed the Start Menu, Power Button and adjusted how individual Windows closed! Is Windows 10 something to be avoided or embraced? Should you Upgrade to Windows 10?

5 reasons to Upgrade to Windows 10

We have come up with 5 reasons why you should, based on our experience from the Training Industry and as a Microsoft Partner. See our video below.

5 Reasons to Upgrade to Windows 10

1 The Start Menu is back

Windows 7 users were outraged about the Start Menu changes in Windows 8, including the loss of the Power Button! Windows 10 has restored the Start Menu. It now only takes up the Full screen space when Windows 10 is used on a Tablet (Mode).

2 Cortana – Digital Virtual Assistant

Search is still at the core of Windows 10, but with the added power of Cortana. A truly digital Virtual Assistant, backed by the power of the Cloud. She can help you to search, manage your schedule and she’ll even remind you to leave earlier if there’s traffic. You may not wish to talk to her on you desktop, although that feature is available. Talking to your computer will still get you odd looks from coworkers.

3 Resized Windows

The ability to click on the X and close Windows is back, a relief to many desktop users frustrated by Windows 8.

4 Control Panel vs Settings

To adjust any setting in Control Panel in Windows 7, meant venturing into a maze of Icons. Microsoft have organised everything into logical groups any simply called it “Settings”. It’s now easier to connect a Bluetooth Mouse, adding a Printer will now take minutes instead of hours!

5 Desktop/Task Views

Windows will Snap when using the Windows Key and an Arrow key shortcut, it will then offer you other open Windows to snap to the other 50% of your screen. You can have more than 2, but this only really works on larger screens. As the majority of users work on only one screen, it can be hard to switch between open Windows/Programs while multi-tasking. Task View allows you to save the Window layout and assign it to different Desktop Views. This is going to be really useful for having Outlook open with Skype for Business, the two Windows I always have open.

We hope you found those 5 points helpful in assisting with your decision to upgrade to Windows 10. If you would like to get the most out of Microsoft Office, we can also help. Please feel free to get in touch to discuss your training requirements.

Microsoft Training – STL