Spreadsheets make the world go around! This document describes Dense Analysis tips and tricks for how to work with spreadsheets quickly so you spend less time in them.
General Dense Analysis Advice
- Stick to default formatting where possible.
- Be mindful of colorblindness and avoid similar colors.
- Don’t waste your time.
- Use your keyboard, including a num pad if you have one. Touch-type and learn to use the num pad with one hand.
Google Sheets
- Press Tab to move to the right after an edit, and Enter to move a row below
- Insert a new row below with Alt + Shift + I, then R, then B. (May be Alt + I in Chrome)
- Auto-fill cells including formulae with Ctrl + D