Google Spreadsheets is quickly becoming a more viable application – and probably a bigger problem for Microsoft. In fact, the Google team has just introduced a number of improvements to Spreadsheets. They are:
Spreadsheet Gadgets – Google and external developers have added new ways to visualize and use the information in a spreadsheet. This means Pivot Tables, Filters, Gantt Charts, even animated time-series charts, are now available in one fell swoop. Some of these are provided by Google, some by other companies and developers.
Notification of Changes Via Email – If you wanted to be notified when a spreadsheet, or one sheet, or a range of cells changed, use this feature now. You can find it on the file menu and the share tab. Best part is, the email notification contains a link to a version of your spreadsheet which highlights all the changes.
Use Arrow Keys to Select a Cell for Inclusion in Formula – Some of you will say “finally!” to this one . . . and some of you will say “huh?”
Expanded Color Palette for Font Color and Cell Color – A few more pastels have been added to the mix.
Clear Comments Feature
Auto-Complete From Previous Values in a Column – This can be a real productivity feature, as the cell you are typing in will try to guess what you might want based on what else is above and below.
Function Helper Autocomplete – You’ll notice next time you start a formula with an equal sign, that the product again tries to guess what formula you might want by matching your characters.
sort(), filter(), unique() functions
So if you’re a Google Spreadsheets user there are now more reasons to love it!
