Friday, June 22, 2007

5 Things I bet you didn't know about Google Docs & Spreadsheets

Josh Lowensohn published article, 5 things you probably didn't know you could do in Google Docs & Spreadsheets, a couple of days ago that I found to be very informative. The five things are:

1. Live lookup via Google and Google Finance. In Google's Spreadsheets, you can use two special formulas to create cells that will continually update with data or information gleaned from Web searches or Google's finance service. Stock symbols, Sports statistics, or any other piece of information offered on Google that you to update automatically. Check out more here and here.

2. Google search inside a spreadsheet. Highlight any phrase in Google's Spreadsheets, right click on it and choose "Search the Web." Results from a Google Search for that phrase will open in a new browser window (Note: This doesn't work in Google Docs, just Spreadsheets.)

3. Color-coded live comments. Google's Documents allows users to annotate wherever they please, using color-code comments. If a contributor finds a comment useful, they can add it to the document by right clicking on it and then choosing add it from the contextual menu.

4. Versioning. Google Docs and Spreadsheets offer the option to keep track of changes to a document or spreadsheet. The application will highlights the differences between different versions of the same document.

5. Automatic Backup. Google Docs and Spreadsheets are stored on the GFS (Google File System), which has been designed so even if the server in which your file is hosted bursts into flames, the system will automatically switch over to the backup copy. Users wouldn't even notice.

Pretty neat, Thanks Josh, let us know if you find more.

Sphere: Related Content

0 comments: