tips for google sheets

speaker: Jum event: Learning Day 32 date: [2018-11-16 Fri 21:23:52]

freeze the top row, header

data validation, drop down box showing possible values

cell reference: H$1 means always refer to 1 and not increment it

IF function

conditional formatting