Home > Technology > Software > Using Google Documents and Spreadsheets


Greg Brown

Guide to Using Google Documents and Spreadsheets

Cut software costs and boost productivity the Google way


Uncommonly
Useful
9.0
out of 10

Add Your Comments
 
 
Email Guide to Using Google Documents and Spreadsheets to a friend
Save the Guide to Using Google Documents and Spreadsheets to My Work.com Favorites
Print the Guide to Using Google Documents and Spreadsheets
link to this page
Save to del.icio.us
digg it!


It's very easy to predict the end of a certain Redmond, Washington software giant (many have called it before and been wrong), but a deep look into the simplicity and ease of Google's free online word processing and spreadsheet software, and -- well -- the bugle player is at the very least warming up "taps" for the most-used half of the Microsoft Office suite, Word and Excel.

Widely available broadband is part of the reason. Faster, more reliable Internet connections mean that being "online" is normal. But where Google's first attempt at office software really shines is collaborative work. Here's an overview of how to deploy and use Google's Docs & Spreadsheets service in your small business.

Action Steps
The best contacts and resources to help you get it done

Fear not, it's just a Web page


The first stumbling block for most of who grew up on floppy disks and booting up is that Google's office offering is an ASP, or application service provider. Put simply, you click open the Web page and the program is there, running and ready to use.

I recommend: To do this, you will first need a Google account. This will give you access to many other services, including Google mail. If you must continue to use corporate e-mail, AOL or Hotmail, registering at Google will not require you to switch. All your work is backed up instantly and saved to Google's servers, not your desk computer. Password back in from anywhere, and there it is.

Importing and exporting your old documents and spreadsheets


Generally, migrating your existing work into Googleworld is not as slick as it might seem. You can move Excels and Word documents easily enough, but tricky formatting is often lost, and if your sheets have complex formulas, they likely won't work correctly. Expect to start over in most cases.

I recommend: Try asking the users in Google Groups if you think your spreadsheet or document should be importing with no issues. An alternative: E-mail the document to your new Gmail address. At the bottom will be an option to open it in Docs & Spreadsheets or in its native format. You can export, too, including to formats like PDF, CSV and of course, Word and Excel.

Collaborating just got a heck of lot easier, no matter where you are


Microsoft is rocketing along with a collaborative suite for business called Live, but your small office can latch on to the productivity power of instant document and spreadsheet sharing now -- for free.

I recommend: Perhaps the most powerful, and startling, feature is the ability to manipulate a document or sheet and have large numbers of other users see the changes happen live. There's also a chat box alongside, so long-distance collaborators can comment without having to call you up. Sound exotic? Check out these real-world, and really normal, user stories.

Share information like crazy


The first thing you'll likely do in terms of sharing is "publish" a document or spreadsheet., which generates a Web address for that document anyone can see, Googlenaut or Googlenot.

I recommend: Once you learn to publish, graduate to tags (which give documents searchable, sortable labels, like "homework" or "sales department" and RSS feeds, which can create instantly updating Web lists of current work. You can also integrate with Blogger, another Google service, to send edited documents straight to a Weblog, or online diary. Very useful for disseminating the latest version of a document to, say, suppliers, employees and partners.

Use the Web to gather and crunch data in your docs


One little understood but potentially powerful feature harnesses the Googleverse to update spreadsheet cells instantly. Stock prices, statistics, movie times -- anything that Google tracks can be built into a sheet.

I recommend: You can now use all kinds of stock data as tracked by Google. If the price changes, so does your spreadsheet.  Farther afield, GoogleLookup will run a Web search and plug the data it finds (population of Japan, boiling point of water, capital of Mississippi) into your sheet. Not perfect, but wow!

Keep tabs on new features


Since Google is always developing the product, you needn't wait for an upgrade (or, for that matter, buy the upgrade) to enjoy new features. In the name of simplicity, however, Google will not beat you over the head with every little improvement.

I recommend: Keep track of new features at the Google Docs and Spreadsheets blog, run by the developers of the service itself.

Tips & Tactics
Helpful advice for making the most of this Guide

  • One fundamental difference is that, instead of folders, Google maintains a simple list of your latest documents. As you use, update, create or change them, they'll stick to the top. But click "view all" and there's the whole she-bang.
  • Want to look back in time? You can track changes and see your documents as they were saved in a setting known as "revisions."
  • Remember, this is Google. You can quickly search all your documents, and their contents, using Google's search box inside the documents home page.

Featured Vendors

IBM LotusLive Engage
Discover IBM's Integrated Suite of Online Collaboration Tools for Meetings, Web Conferencing, Sharing & More. Get the No Cost Trial.
www.LotusLive.com

Microsoft SharePoint® - Free Trial
A Simple, Highly Reliable Collaboration Platform. Download & Test Drive Today!
Microsoft.com/SharePoint

Groupware Software Resources
Find Groupware Software. Search listings and reviews of retailers, specialists and services in your local area now.
JustClickLocal.com

Web Conferencing Software Finder
Compare web conferencing software using Capterra's free and comprehensive Web Conferencing Software Finder.
Capterra.com

Sign up for the What Works for Business weekly e-newsletter!
 Related Resources from Business.com Back to top 
  CommentsBack to top 

Loading Comments...


Add Your Comments


Email Guide to Using Google Documents and Spreadsheets to a friend
Save the Guide to Using Google Documents and Spreadsheets to My Work.com Favorites
Print the Guide to Using Google Documents and Spreadsheets
link to this page
Save to del.icio.us
digg it!


Is any content on this page inappropriate? To let us know, please click here.

Ads by Google







© 2009 Work.com, Inc. All Rights Reserved. Work.com is a property of Business.com.
Help | About Us | Site Map | Terms of Use | Privacy Policy | Community Policy | Taskonomy | Advertise | Contact Us | Local Business Directory | Work.com Feed