Short answers to the questions people ask most — step by step, with the exact formula.
Drag a formula down and it changes. Fix it with the $ sign to keep one cell locked while the rest move down, one short formula works everywhere.
From Book 0: Google Sheets for Absolute Beginners
Show "LATE" for overdue items and "Due soon" for anything due within a day. One formula that updates itself every day, step by step.
From Book 1: Google Sheets Made Simple
Stop the same item being typed three ways. Make a dropdown list in Google Sheets from a range on another tab, step by step.
From Book 0: Google Sheets for Absolute Beginners
Tick a checkbox and the whole row turns green; untick it and the color goes away. One custom formula in conditional formatting, step by step.
From Book 0: Google Sheets for Absolute Beginners
Turn a small table into a pie or column chart in one click, give it a title, and watch it update by itself when a number changes.
From Book 0: Google Sheets for Absolute Beginners