Joe and Jesse talk about spreadsheets on The Roundtable, Tuesday, August 21, 2017 11:30 AM on WAMC.
Everyone uses spreadsheets. Most people use them incorrectly.
Here are some of Jesse's suggestions for spreadsheets.
- Spreadsheets are not for formatting data. If you want to make nice rows and columns, use a word processor or page layout app.
- If you don't have any formulas in your spreadsheet, see #1.
- If you have to check totals or subtotals, you're doing it wrong.
- If your formulas break when you add or remove data, you're probably not using SUM (and other functions) properly.
- If you have several tables in your spreadsheet, turn the tables into a workbook (Excel) or use separate tables (Numbers).
- Put a comment in your spreadsheet and update it when you make changes.
- Merge cells and center titles for neatness.
- Destroy old versions unless you clearly archive them by file and title.
- If you need to put multiple lines in a cell, you probably want a related table in a database (or a related spreadsheet)
- Run away quickly from anyone who says "According to the spreadsheet..."