Durations and the sheet

The grid as a sheet: the cell cursor and the row numbers, the blank rows, Tab across and Enter down, durations typed as you say them (3w, 10d, 4h), F2, the card of keys, fill down and the Type list.

Running time 1:19CaptionedNo account needed to watchVideo 12 of 55

TRANSCRIPTEvery word of the video, as text.

Read the transcript

The grid behaves like a sheet: a cell is the unit, and the keys do what spreadsheets taught you.

The outlined cell is the cursor. The arrow keys move it, one cell at a time. The numbers at the left are row places. The ID belongs to the activity, and travels with it.

Under the last activity, blank rows wait. Type a name, press Enter, and the next one volunteers. Tab moves across: the name is kept, and Original duration opens for typing.

Type 3w and press Enter. Fifteen working days, and the bar grows to match. 10d, 4h, 2.5w: type it as you would say it. The cell does the arithmetic.

F2 opens the cell you are on. Escape leaves it exactly as it was. Press the question mark for the card of keys. Nobody is expected to remember them all.

Drag the small square at a cell's corner down, and the value fills the cells below. The Type cell is a typed list: a few letters, and it narrows to what matches.

That was the sheet. Next in the Guide: drag a bar, then undo it, and redo it.

Taken from the video’s English captions.

Register and try us for free for 30 days.Register