Tips & further reading

Keyboard shortcuts

For Windows/PC

CTRL + SHIFT + ; Insert the current time into the selected cell
CTRL + SHIFT + ; Insert the current time into the selected cell
CTRL + ↑ ↓ ← → Jump to the end, or the last cell in that direction adjoining a blank cell
CTRL + D Fill down with the value in the selected cells
SHIFT + ↑ ↓ ← → Highlight cells one by one
SHIFT + CTRL + ↑ ↓ ← → Highlight group of cells in that direction, until the next blank cell

For Mac

CMD + ; Insert the current date into the selected cell
CMD + SHIFT + ; Insert the current time into the selected cell
CMD + ↑ ↓ ← → Jump to the end, or the last cell in that direction adjoining a blank cell
CMD + D Fill down with the value in the selected cells
SHIFT + ↑ ↓ ← → Highlight cells one by one
SHIFT + CMD + ↑ ↓ ← → Highlight group of cells in that direction, until the next blank cell

Dive deeper

Excel Magic

Mary Jo Webster, Data Journalism Academy
Google Sheets function list

Staff, Google
The Quartz Guide to Bad Data

Staff, Quartz

Previous submodule:

Turning data into findings