My rules for making great spreadsheets (in Google Sheets or Excel)

1) Round numbers: use "decrease decimal point" or "format" to automatically round numbers to the greatest number of decimal points that are truly useful (so 0.15, not 0.15121215 and 32%, not 32.42%). 2) Set units: use the "format" feature to make percentages into actual percentages (ending in %), to make dollar figures into actual dollar figures (starting with $), and so on. This makes it easier to interpret figures at a glance. 3) Use formulas: anything that can be calcul...
More