Share Spreadsheets Online - Tech Learning

Share Spreadsheets Online

Tip: Google Spreadsheets is a Web-based spreadsheet product that makes it easier for people to create and share spreadsheets on the Web. It enables people to create simple Web-based spreadsheets that others can simultaneously update from their own computers. You must have a Google or Gmail account to sign up for
Author:
Publish date:
Social count:
0

Tip:

Google Spreadsheets is a Web-based spreadsheet product that makes it easier for people to create and share spreadsheets on the Web. It enables people to create simple Web-based spreadsheets that others can simultaneously update from their own computers.

You must have a Google or Gmail account to sign up for Google Spreadsheets. If you already have a Google Account, just sign in. After you sign in, name and save your spreadsheet.

  • Type in the text and numbers just as you would with any spreadsheet. You can even import and export .xls (Excel) and .csv (Comma-Separated Values) data.
  • Click on a cell and it shows up in the formula bar.
  • Click Formula and choose Sum, Average, Count, Minimum, Maximum, or more.
  • Press Enter or Tab to insert the results.

Click Format and the format bar appears.

Select the cell(s) to add effects such as bold text, italicized text, and more.

Click Sort to sort your data by A to Z or Z to A.

You can invite people to edit or view your spreadsheet. Just type in their Email addresses separated by commas.

TIP: Save your spreadsheet on your hard drive and then make a copy for sharing. Since shared spreadsheets are editable, this will preserve a copy of your original work, just-in-case.

Google Spreadsheets does not have the ability to create graphs and macros. However you can still import and export data and share your data with others. You can create and store up to 100 spreadsheets. Try it out, but be aware that it is still in beta. A new feature is embedding the code into your Website so the spreadsheet appears online.

Next Tip: Google Docs

Featured

Related

Web-based Spreadsheets

Tip: Have you wanted to be able to create and share a spreadsheet — online? "Num Sum" is a Web-based spreadsheet application with many of the same features as Excel as well as with some pretty cool social aspects tied in. This means you can share progress reports, track reports, or do any other number of

Sharing Photos Online

Listen to the podcast Question: How can I share pictures online? The IT Guy says: There are a number of services available, but by far the most popular right now is Flickr. The service was purchased by Yahoo! last year, and to set up an account you need to have a Yahoo account. Once you do, you can

Box.net: Online storage and file sharing

Box.net is an online file storage and file sharing site that allows users to upload and share documents. With this tool you can create a unique Website address which you can then share with others to whom you provide the link. In addition you can create collaborative folders for sharing with other Box.net users,

Drop.io: Easy File Sharing

Drop.io is a web service that enables you to create simple private exchange points called "drops." A drop is a 'discrete' chunk of space you can use to store and share anything (pictures, video, audio, docs, etc) privately, without accounts, personal registration, or an email addresses. Drops are not

Make and Share Templates

Tip: Do you find yourself creating materials over and over again? You can create templates for most of your documents, spreadsheets, and presentations that you later open and adapt, avoiding unnecessary work. Create a blank letterhead template with your logo, name, address, etc. Develop a template for grant

Mapping shared folders in Windows

Question: What are the different methods for mapping a shared folder in Windows XP? The IT Guy says: Once a shared folder has been created on a network server, several options are available for connecting to that directory as a drive letter on a client computer. Option 1: Go to START - RUN, type 2 backslashes and