Google Docs

The spreadsheet in the online Google Docs has some seriously useful features you’ll not even find in Excel. It can look up information on the web and return to a cell on the spreadsheet.

For example, “GoogleLookup(‘California’, ‘capitol’)” will return “Sacramento.” You can do this with virtually any piece of data, and if Google can find the answer, it will put it in the cell.

Not only that, Google Docs can be made shareable. So, here’s a spreadsheet showing how these functions work.