7 Great Google Spreadsheet Gadgets
One of the best-kept secrets of Google Docs, these gadgets add powerful features to your spreadsheets.
PC World - Inside Google Docs' spreadsheet component, you'll find gadgets that endow the app with powers that even Excel users will envy. Included are tools for creating animated pie charts, producing QR codes, generating organizational charts, and more. You can also plot data in color by country on a map, and you can publish a map with your office location marked on it. All of these tricks are easy to pull off--I'll show you how.
1. Make Your Own QR Codes
QR codes are ubiquitous these days. They're a great way to share contact details, URLs, product information, and other brief amounts of text.
To create a QR code in a Google Docs spreadsheet, first type the text for the code into one or more adjacent cells in a column of the spreadsheet. Choose Insert > Gadget > All, locate the QR Code gadget, and click Add to spreadsheet. When the Gadget Settings dialog box appears, drag over the cells containing the text for the code, click OK, and then click Apply & Close. The generated QR code will display in the gadget dialog box.
You can drag the gadget dialog box--as you can all gadget dialog boxes--and place it anywhere on the spreadsheet. To see the options for working with any gadget, click the down arrow in the top corner of the gadget dialog box. The options for the QR Code gadget include using 'Publish Gadget' to obtain some code that you can use on your website to display the QR code. You can also use Print Screen on the code and then insert it into a document or other publication.
2. Make Your Own Custom Google Map
Pictures convey more information than words do, and a map offers the easiest way to show people where your office and other places of interest are located. The Map gadget lets you create a custom Google Map with pointers to the places you want to highlight, and it's simple to use.
To begin, type a list of addresses, one per row down a single column. If you want a tooltip to appear over the map location when someone hovers over the marker, type the text for this item in the cell to the right of the address. For example, to produce a map of local farmers' markets, type each address in one cell and the name of the farmers' market in the adjoining cell to the right.
Choose Insert > Gadget > Maps, and click Add to Spreadsheet. Now select the range of cells containing your address and tooltip data, and then enter a title for the map in the Title box. If your data includes tooltips, select the Last Column as Tooltips checkbox, and then click the Zoom Using Mouse Wheel checkbox. From the 'Map type' list, select the type of map--Normal is a good choice--and then click Apply & Close.
- The Business Value of Continuous Delivery Download this whitepaper to learn more about the business value of Continuous Delivery and see why it could be a game changer for...
- Ten Factors Shaping the Future of Application Delivery Download this research report conducted by Enterprise Management Associates (EMA) to learn how those that are seeking to accelerate application delivery are leveraging...
- HTTP Status Code Cheat Sheet Look at the Graph, Find the Code and Boom - You're Solving Problems. Identifying and understanding common HTTP status codes can go a...
- Architects lead the next generation of data-driven applications Read this whitepaper to find out how application architects can quickly and confidently deliver long-lasting applications that minimize cost, complexity, and risk while...
- Why Are Customers Really Deploying an NGFW? It seems every IT Security expert is talking about the NGFW, but what are people really doing? This webcast covers 5 real-world customer... All Desktop Apps White Papers | Webcasts