Google Spreadsheets as part of the Google Docs added some brand new features. The ones which are worth mentioning are: better revisions comparison through color highlights, change notifications, and a Google spreadsheet gadgets directory.
Revisions highlights
In Google Spreadsheet, the new changes during revisions are now highlighted for easier understanding; just click on the Revisions tab. This is especially useful when more than one users are jointly editing a particular Spreadsheet.
Instant Notifications
Notification rules – see the Set Notification Rules link on top – can automatically send you an alert when the spreadsheet, or a specific cell within it, changes. You can opt to receive a daily mail or immediate notification mail as it happens.
Spreadsheet gadgets
You can now add gadgets to the spreadsheet by picking a cell range and then clicking Insert -> Gadget at the top bar in Google Spreadsheets. I’ve pondered a Google Docs feature directory before as this can open up a huge number of interesting options without cluttering the interface. And … wow, this just boosted Google Spreadsheets into a different league. Currently available gadgets include:
- Motion chart: Its a nice gadget and can display a certain number over and over using Flash Animation.
- Gauges: Adds gauges (as pictured below) with dials visually indicating the cell values
- Table: You can add tables with grouping and filtering features
- Heatmap: A world map is connected to your cells containing an ISO country code, and then add color of different intensities to the countries
- Web search and image search: It can displays a result from Google by searching your cell value
- Organization chart: This can draw a hierarchy based on cells containing names (pictured)
Moreover you are not kimited to existing gadgets but can develop your own ones too!
No comments:
Post a Comment