This week, the world celebrated Spreadsheet Day, AKA the most boring holiday devised by humankind. But wait! If you hate spreadsheets and everything they stand for, it probably means you don't know how to use them properly. Here are our most useful spreadsheet hacks for Microsoft Excel and Google Sheets; suitable for novices and experts alike.
Tagged With google spreadsheets
If you're sharing or collaborating on a Google Spreadshet, you can now set columns to validate data types. Cells can enforce certain data types, require valid URLs or mandatory text, for example.
Predicting the future is near impossible -- but that doesn‘t stop us all from having a red hot go. Human beings have been predicting the future since the beginning of history and the results range from the hilarious to the downright uncanny.
One thing all future predictions have in common: they‘re rooted in our current understanding of how the world works. It‘s difficult to escape that mindset. We have no idea how technology will evolve, so our ideas are connected to the technology of today.
Techie Leonard Lin publishes his investment asset allocation in a Google Spreadsheet which employs the super-useful GoogleFinance formula for live-updating stock prices in-sheet.
At the top right of the Spreadsheet page you'll see a link to "Set Notification Rules" (or you can find it in the File menu). You can control what parts of your spreadsheet to track, and how often alerts are sent. You can see the options in this screenshot:
Google expert Philipp Lenssen has come up with a brilliant spreadsheet that creates a world map coloured by how often a term gets Googled by country. Data nerds will love this: The sheet dynamically pulls in the number of results for a given search term and updates a map widget with colours representing the totals. After the jump, check out what the map looks like for a search for "lifehacker."
Google rolls out a few impressive new features to its online spreadsheets offering today, including cell autocomplete, iGoogle gadgets, and notifications about collaborative edits. Autocomplete works the way any desktop spreadsheet does: as you type, if the cell contents match a past entry, Spreadsheets will suggest the value. As for data collection and sharing, you already know you can ask others to fill in a spreadsheet with a user-friendly form. Now you can get notifications whenever a sheet gets updated, down to a specific range of cells or via a form. Finally, you can track the status of your spreadsheet on your iGoogle homepage by creating a data widget, which updates as your spreadsheet does. Pretty nifty.Google Spreadsheets Adds Gadgets, a Directory of Features
CNET blogger Dennis O'Reilly is using Google Docs to manage his NCAA basketball pool; the bracket spreadsheet he put together is public and free for anyone to copy and use.
Google Spreadsheets adds conditional formatting rules and row and column hiding. It's still not Excel-quality, but it's good to see GSpreadsheets continually improving.