Group items tagged

Step 1: Assuming that your already have a Gmail account, go to your Google Contacts and create a new Group (let's say "Media"). Add all the contacts to this group who you want to send a personalized email. Step 2: Create a copy of this spreadsheet into your own Google Docs account. Step 3: You'll see a new "Mail Merge" menu in Google Docs near "Help." Click "Import Gmail Contacts" and authorize Google Docs to access your Google Contacts. Step 4: Click Mail Merge -> Import Gmail Contacts again and type the name of the Gmail group ("Media") that you created in Step 1. Google Docs will now automatically import the relevant Gmail contacts into the spreadsheet.

effective tutorial for Google Spreadsheet; especially interested in the explanation of the Gantt Gadget; great for data visualization

Google Spreadsheet tips, including the use of the Gantt Gadget

Turn a boring old spreadsheet into an interactive web-based map, timeline, or table with some simple HTML using the free, open source Exhibit project. Exhibit takes data sets up to about 500 rows, plots locations on a Google Map, dates on an interactive timeline, and displays images and links in a tabular or thumbnail view. The viewer can sort, search, and filter data in any Exhibit view without reloading the page. You can make Exhibit do all this with a single HTML file and a spreadsheet-no hardcore programming required.

"Chronoscope is an interactive time series chart that can be used as an embedded widget, a Google Gadget, or with the Google visualization API. This page explains how to use Chronoscope as a Google gadget for line or bar charts in Google spreadsheets, in iGoogle, or in Open Social containers. "

Google spreadsheet now has pivot table reports...

Use PDF to Excel to quickly and easily create highly-editable XLS files, making it a cinch to re-use tables and spreadsheets from PDF files in Microsoft Excel, OpenOffice, Google Docs, and WordPerfect Office. Best of all, it's entirely free!

Keyboard accelerators, mnemonics, and shortcuts Keyboard accelerators let you open menus using special keyboard shortcuts. The table lists shortcuts for people using Chrome on Windows/Linux. If you're working in Internet Explorer or Firefox, replace Alt with Alt+Shift. If you're working on a Mac, replace Alt with Ctrl+Option.