40+ big and small changes to make your look good and efficient.
Checklist & Subscribe: https://dataful.tech/good-looking-spreadsheets-checklist/
Mentioned videos:
- Named Ranges: https://www.youtube.com/watch?v=btmvZuQsgjM
- How to Highlight Duplicates: https://www.youtube.com/watch?v=UHz1EXIsXWQ
- Multi-Select Dropdowns: https://www.youtube.com/watch?v=_c7n1WO43KY
Custom number format:
- Documentation: https://developers.google.com/sheets/api/guides/formats#number_format_patterns
- Color pallet: https://dmcritchie.mvps.org/excel/colors.htm
- Up/Down symbols: ▲ ▼
Timestamps:
00:00 Intro
01:25 Cleanup
02:33 Headers
03:47 Layout
05:58 Visualizing Data
13:19 Data Input
16:24 Miscellaneous
#gsheets #googlesheets #googlesheetstips #googlesheetstutorial #conditionalformating #datamanagement #datavisualization #namedranges