Google Docs reconsidered

Two years out of beta, how does Google's online office suite hold up?

1 2 3 4 5 Page 3
Page 3 of 5

Spreadsheet

Google's Spreadsheet is on a par with basic spreadsheet programs such as the one in OpenOffice.org or earlier versions of Excel. It includes hundreds of functions listed under engineering, financial, logical, math, statistics and other categories.

Google Docs

Spreadsheet can generate a number of chart types based on your data.

Click to view larger image.

Throughout 2010, the Google Docs developers added several tweaks, including new features like data filtering and a significant tool: pivot tables. The latter helps you quickly pull out ranges and labels of data and instantly generates a recalculated table (essentially, a smaller spreadsheet spun off from the main spreadsheet). I've found pivot tables handy for experimenting with different ways of presenting and recalculating data without having to change the original spreadsheet itself.

Spreadsheet can generate charts based on your data. There are a decent number of presets to create line, column, bar, scatter-point, pie and other types of charts, but not as many varieties as you'd find in OpenOffice.org or recent versions of Excel. One helpful aspect about the chart editor that I like is how each chart sample has a description briefly explaining how your data needs to be formatted to create the graphic.

Spreadsheet imports a variety of formats, including XLS and XLSX (Excel), ODS (OpenOffice.org), CSV, TXT, TSV (tab-separated values) and TAB. I found that a few OpenOffice.org spreadsheet files wouldn't import correctly -- for example, background colors of cells were dropped. Some formulas set to calculate data taken from multiple sheets in a spreadsheet would no longer work. I had to manually tweak these formulas so the application would recognize them correctly. Spreadsheet handled converting Excel files better, which seems odd considering that OpenOffice.org uses open file formats.

Each sheet of a spreadsheet is denoted as a tab along the bottom of the application. Because it's an online application, flipping through multiple sheets in a spreadsheet -- especially if you've got a lot of data -- isn't a snappy experience, and it may take each page a second or two to load.

If you don't have enough rows on the spreadsheet, you can scroll down to an "Add" button and a fill-in box set to the lower-left below the sheet: Enter a number, click the button, and your spreadsheet will grow down by that many rows. Unfortunately, there is no similarly convenient button to quickly add more columns in multiple amounts. Otherwise, to insert multiple numbers of rows or columns, you highlight several rows or columns and then right-click to add that number of rows or columns.

Unlike the Drawing and Presentation applications, Spreadsheet doesn't offer the ability to zoom in or out of a spreadsheet (Document also lacks this feature). This can be an issue if you're working on a large spreadsheet -- whether designing it or filling it out -- because you can't zoom out to see the whole picture unless your browser offers this capability.

You can download your spreadsheet in a variety of formats, including XLS (Excel), ODS (OpenOffice.org), PDF, CSV, HTML or TXT.

Presentation

Presentation is essentially a simplified slide-show builder. It's meant mainly for assembling a linear sequence of slides to use in business or academic presentations, but it's possible to use it to build frame-by-frame animations if you have the skill (and determination).

Google Docs

Presentation is essentially a slide-show builder.

Click to view larger image.

You make an individual slide by inserting graphical elements such as text and tables -- or importing images from your local computer, a Picasa album or a Google Image search -- onto a blank page. You can then drag and drop and resize these elements to fit the way you want them to appear on the slide.

Click the toolbar buttons in the upper left of the application or right-click in the work area to add, remove and rearrange the playing order of the slides. You can also drag and drop the thumbnails that run along the left side of the work area to do this.

The thing to be aware of is that, for the most part, you can't use Presentation to build media-rich slide shows. You can embed a video from YouTube in a slide, but that's about it. You can't import MP3s or a large variety of video clips for use in a slide show -- even videos you've uploaded to your Google Docs account.

Slideshow presentations can be downloaded as PowerPoint or PDF files. You can also pull up a mini version of Drawing within Presentation to create line drawings or put predrawn shapes into a slide. But I think it's easier to simply launch the separate version of Drawing on its own, draw and finish your images and then insert them into Presentation.

1 2 3 4 5 Page 3
Page 3 of 5
Download the 2018 Best Places to Work in IT special report
  
Shop Tech Products at Amazon