Google Spreadsheets Adds New Features
Google has just added a handful of new features to Google Spreadsheets. One of the coolest is the GoogleLookup function. The function calls to Google search to put content in a cell.
For example: if you wanted to use the population of Canada as a basis for calculations, you would enter the formula “GoogleLookup(“canada”, “population”)” in the spreadsheet cell and Google would return the appropriate number.
- Add your active docs & spreadsheets list to your Google Personalized Homepage
Google Docs & Spreadsheets GadgetNow you can add the Google Docs & Spreadsheets Gadget to your Google Personalized Homepage so your work is always at your fingertips. This module lists your most recently active docs & spreadsheets and lets you jump directly to your full docs list, right from your Homepage. Learn more or Add to Google - Browse (and revert to) past versions of your spreadsheet
Have you ever accidentally erased something important, or just want to see how your spreadsheet has changed over time? The new “Revisions” tab lets you step through old revisions, find major changes from you or others, and even revert to a previous one. Learn more
Past versions of your spreadsheet - Publish spreadsheets as web pages
Choose between a snapshot of your spreadsheet right now, or make it automatically update as your spreadsheet changes. You can also embed a spreadsheet in an existing webpage, or publish in other formats like .csv, .xls, .pdf, and more. Learn more
Publish spreadsheets as web pages - Spreadsheets get smarter with 2 special functions
- Two new functions bring the power of Google directly into your spreadsheet. The GoogleFinance function retrieves current price and volume for stocks, indices and ETF’s. For example, GoogleFinance(“GOOG”) returns the latest Google stock price.
- The GoogleLookup function attempts to answer your question using the web, with information about people, places and things, like the population of Japan, the mass of Jupiter, or the place of birth of Abraham Lincoln. It doesn’t know everything, but it knows quite a bit. For example, GoogleLookup(“tyrannosaurus”,”length”) returns “40 feet”.
Google Docs & Spreadsheets – What’s New
[tags]Google, Docs & Spreadsheets[/tags]
Related Posts:
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
Comments
Trackbacks
Leave a comment