Google Spreadsheets looks and feels just like Microsoft Excel with one special caveat, it’s free. If you haven’t tried we would encourage you to take a look at a minimum. It has all the functions within the cells that you would expect; calculations, links, graphs, etc. One very cool function that prompted me to share this is the functionality of Forms.
Google Forms is a function within the Google spreadsheet that allows you to quickly and conveniently take a survey of information. You can pose questions in a variant of ways and receive answers that are specifically denoted or multiple choices as an example. The form then is emailed away to your recipients and as they respond to the survey, your spreadsheet automatically populates. This is probably one of the more powerful functions of the Form because it can save you so much time.
Now for the WOW part of the form. We were recently at a conference where the speaker was a Google expert. He pulled up on his projector the Google form and started reviewing the abilities, some of which we have listed above and many more including the ability to host a Q&A session using Google forms and having your audience text their answer in to him right then. None of us had to wait to see the results because as all of the attendees were texting their answer choice to the phone number projected on the screen. We saw a poll of the possible answers and the percentages of people selecting one vs. the others. He was able to privately poll the audience and show immediately where the majority of the group stood. Talk about WOW factor!
Think about the various ways you could use this tool in your next presentation, company meeting or private event and the amount of time you will be able to save by letting Google handle all of the busy work. You can bet that I will certainly be trying to incorporate this into my next presentation.
For more information on Google Forms check out this video: http://youtu.be/IzgaUOW6GIs