New Enhancements to Google Docs in 2010

Now, 2010 is going to end. Google Docs Team has announced his 85 new enhancements and other developments which it has done in Google Docs. Google Docs is mostly used by modern accountant for online excel sheet. So, it was very necessary to learn some of its new things.


1. Formula highlighting in spreadsheets

In the new version of Google Spreadsheets, cell references and the corresponding cells are now highlighted to make it easier to keep track of your formulas.

2. Upload and store your files in the cloud with Google Docs

Instead of emailing files to yourself, which is particularly difficult with large files, you can upload to Google Docs any file up to 250 MB. You'll have 1 GB of free storage for files you don't convert into one of the Google Docs formats (i.e. Google documents, spreadsheets, and presentations), and if you need more space, you can buy additional storage for $0.25 per GB per year. This makes it easy to backup more of your key files online, from large graphics and raw photos to unedited home videos taken on your smartphone. You might even be able to replace the USB drive you reserved for those files that are too big to send over email.

3.  New Visualizations in Charts

Google Docs Team have added annotated time-lines, organizational charts, gauges,  popular motion chart (which makes it easy to visualize data changing over time) and more to our chart types.

This team have also given our existing charts a more professional look and feel with with a refreshed color palette, improved layout and new customization options.

With these new chart types, we’ve also added a new charts editor that suggests recommended charts, matches your data labels and headers, auto selects colors, has a full size preview pane and more. The editor is designed to help you create the chart you need in just a few clicks

4. More tools for viewing document revisions

Google Docs announced that a new revision history interface is now available in Google documents. To see it, go to File > See revision history.

5. Advanced Sorting Rules in Google spreadsheets

In April, Google Docs launched a new version of Google spreadsheets. One new feature that helps organize your data is advanced sorting rules.

Sorting a selection

With the new sorting capabilities, you can sort a small selection of cells without affecting the rest of your spreadsheet. In my triathlon spreadsheet, for example, I could sort only the selection about running while leaving the biking and swimming sections intact. First, I highlight the range of cells in my spreadsheet about running.

Then, I go to the Tools menu and select Sort. Now I can set a sorting rule. In this case, I'd like to sort my running races by date.

Last, I click the Sort button, and my running times are organized by date.