Spreadsheet Roundup 20150304
Here is a roundup of selected spreadsheet articles that I’ve read in the past month. You’ll find interesting tips, useful sample files, and new ideas for your own spreadsheets.
If you have any suggestions for next month’s roundup, please add a comment, or send me a link to the article.
- NPR’s Planet Money podcast covers the history of spreadsheets, in an entertaining discussion. There is an explicit language warning on the podcast, but I didn’t hear anything offensive.
- Programmatic control over protected ranges has been added to Google spreadsheets.
- On my Pivot Table blog, you can see the pros and cons of saving the Source Data with a Pivot Table file
- Shannon O’Donnell spent a year travelling the world, and tracked all her expenses in a Google spreadsheet.
- Add your own spreadsheet functions to a website table with the Totalizer extension for Google Chrome.
- In an 11 minute video, Dave Bruns shares 23 Excel formula tips, and you can download his sample file, to help remember all those tips.
- Spreadsheets are already fun, but Tableau wants to make them even more exciting, with its newest smartphone app, Elastic. No info on expected release date or pricing.
- Jerome Cukier, data visualization designer at Facebook, looks at some of the new problems with dashboards.
- The Investintech blog shares 9 simple tips for working with Excel data. Of all those tips, I probably use #4 most often. How about you?
- Winter is almost over – I hope! Use this Google spreadsheet to plan your garden — when to start your seeds, when to plant outdoors and when to plant again.
Links to Recent Spreadsheet Books on Amazon.com
__________________________