Day 27: Google Docs Scripts and Power Tips

27.05.2011

With the month coming to a close on the project, I think we have established that Google Docs is more than adequate for creating simple documents, , presentations, and other content. Now, let's take a quick look at some of the features that power-users might appreciate.

For more advanced users, Google offers Google LookUp and Google Finance to automatically search for and add information to cells in your spreadsheet.By adding Google LookUp syntax to a spreadsheet cell, you can populate the cell with information stock data, country demographics, celebrity details, planets of the solar system, and more. Google says that the data can come from any Web site, but that certain sites like the CIA Factbook and Wikipedia tend to appear as sources more often than others.

To use Google LookUp, type "=GoogleLookUp("entity";"attribute")" in a cell. For example, if you want to populate a cell with "=GoogleLookUp("Michael Jordan" ; "average points per game")" Google LookUp searches to find out what Michael Jordan's average points per game was, and automatically populates the cell with "31.5".

Google Finance works in a similar way, but is specifically focused on finance and investing information. For example, "=GoogleFinance("GOOG" ; "price") fills the cell with the current share price of Google stock, or "=GoogleFinance("MSFT" ; "volume") populates the cell with the volume of shares traded today for Microsoft stock.

While these functions might save you some time from manually looking up data like Charlize Theron's birth date, it is better for information that is dynamic and may change frequently--like share price or share volume. To see what other options are available, just type "=Google" in a spreadsheet cell and a box will pop-up that lets you know how you can complete the query.