![]() As users complete the form, the data is automatically added to the spreadsheet, allowing you to aggregate data from surveys or to gather replies to an invitation all in one place and without your input. Once you have created the form, which can contain multiple-choice questions, checkboxes, and the like, you publish it to the Web. You might use it for an invitation for which you’re collecting replies, for example, or a customer survey form. Yet another feature of Google Spreadsheets that you can harness for business use–and has no direct parallel in Excel–is the Form feature, which allows you to create a form inside a spreadsheet to collect data from a user. Combine this flexibility with the capability to publish a Google Spreadsheet to the Web, and you have a great tool for providing location-based business information in a graphical way. At any time, if the data in the worksheet is updated, the map will redraw automatically. You then insert the map gadget and select the cells containing the data. To do so, place the address to map in one column and any tooltip text to display when the user hovers their mouse over that location in the adjacent column. Google Spreadsheets Gadgets, such as the Heatmap, offer useful tools for mapping business data.You can also make use of a map gadget to show, for instance, where your business offices or distributors of your products are located, by marking them on a Google Map. ![]() You then insert the Heatmap gadget, select the data, and choose the map to use–the data will be plotted as colors on the map. The codes go in the leftmost column in subsequent columns, you add the data to show on the map, one column for each map. In Google Spreadsheets you start by adding data listed by region, using ISO country codes or U.S. (Coincidentally, a similar feature was available in Excel 2000 and earlier versions however, it was subsequently removed and became the stand-alone application Microsoft MapPoint.) One of these is the capability to create maps with data that’s stored in a worksheet through a Google Gadget. When it comes to interesting uses for spreadsheets, Google Spreadsheets has some tricks up its sleeve that even Excel doesn’t offer. Other users have found a practical solution for being caught on a holiday without dice by writing a simple random number formula in an Excel cell to simulate dice rolls. Simply click one of the listed stations to play it. You can see it at work by downloading the file from. One-time Excel expert Harald Staff created a Web radio player that plays inside an Excel worksheet. Some novel uses for Excel are more for entertainment than work. This is a feature that Google Spreadsheets has offered for some time, and it’s sure to be a welcome addition for business users of Excel. They can use the Excel Web App to make changes, and they don’t even need to have Excel installed to use it. For example, you can upload a budget or other worksheet prepared in Excel to a Windows Live SkyDrive account and make it available for all interested parties to view and edit online, regardless of where they are. With the advent of Office Web Apps, even small businesses that don’t operate a Sharepoint server can make use of the new multiuser authoring feature for Excel. ![]() The Group, Filter, Consolidate, and PivotTable tools in Excel give plenty of options for summarizing the data to answer questions about your business. If the links between Excel and the data are live, then changes or edits to the original data should update automatically in Excel. You can use it to analyze data from a range of sources by first importing or linking the data from a data store and then displaying it in a format that’s easy to sort and summarize. You can use Excel to design other software.Excel has always been a good tool for analyzing information created elsewhere. He takes advantage of the application’s structure to lay out a design, and he also puts Excel’s drawing and form tools to good use in the mockups Other users, such as Purna Duggirala, harness Excel’s power to prototype user interfaces. You can find this worksheet as a free download from her Website. This lead-tracking sheet features a data-collection worksheet and a series of PivotTables that analyze the data and provide summarized information about referral sources, failed leads, booking rates, and other details. Photographer Leeann Marie created a marketing worksheet in Excel to track her photography leads and their conversion into actual shoots. Some users have found novel applications for Excel that harness its power for business. Track Leads, Build Software, and Analyze Data ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |