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

All 55 Scheduler videos

Build · 4 of 10. Each mark’s length is its running time.

TRANSCRIPTEvery word of the video, as text.

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.

THE SERIES Beta All 55 Scheduler videos, in order, 96 min 39 s end to end.

  1. 1The Scheduler in five minutesRunning time 2:50
  2. 2New to schedulingRunning time 4:14
  3. 3You know Microsoft ProjectRunning time 4:01
  4. 4New to scheduling on a P6 projectRunning time 4:16
  5. 5You know P6Running time 4:09
  6. 6Adding the Scheduler to a Basic accountRunning time 1:07
  7. 7Viewer or editor: which one you haveRunning time 1:41
  8. 8Open a scheduleRunning time 1:48
  9. 9New schedule and your defaultsRunning time 1:49
  10. 10Adding and deleting activitiesRunning time 0:56
  11. 11Indent, outdent and the WBSRunning time 0:44
  12. 12Durations and the sheetWatchingRunning time 1:19
  13. 13Drag a bar; undo and redoRunning time 0:50
  14. 14Milestones and activity typesRunning time 0:35
  15. 15The Details panelRunning time 0:47
  16. 16Editing activitiesRunning time 2:16
  17. 17Schedule options and settingsRunning time 2:16
  18. 18CalendarsRunning time 1:51
  19. 19Links: relationships, lags and leadsRunning time 2:01
  20. 20Constraints and datesRunning time 1:56
  21. 21Scenario 1 · a Microsoft Project file, Simple modeRunning time 1:58
  22. 22Scenario 2 · a Microsoft Project file, Full modeRunning time 2:29
  23. 23Scenario 3 · a P6 file, Simple modeRunning time 1:49
  24. 24Scenario 4 · a P6 file, Full modeRunning time 3:02
  25. 25How scheduling worksRunning time 1:48
  26. 26Switch engine: Standard and AdvancedRunning time 1:40
  27. 27Links: the four types, lag and leadRunning time 1:02
  28. 28Links by shorthandRunning time 0:47
  29. 29Links by nameRunning time 0:36
  30. 30Logic lines and off-screen partnersRunning time 0:33
  31. 31Columns, views, sort, filter and searchRunning time 2:13
  32. 32Columns and presetsRunning time 0:46
  33. 33Views, sort, filter and findRunning time 1:18
  34. 34The GanttRunning time 1:53
  35. 35Updating progress yourselfRunning time 1:54
  36. 36Resources, costs and the live cashflowRunning time 2:12
  37. 37Resources and assignmentsRunning time 1:01
  38. 38Costs and the live cashflowRunning time 1:19
  39. 39Curves and periodsRunning time 1:09
  40. 40Earned value against the baselineRunning time 1:20
  41. 41Usage and over-allocationRunning time 1:06
  42. 42Working with others: one editor at a timeRunning time 1:51
  43. 43Sharing and live linksRunning time 1:58
  44. 44Saving, Save as and recoveryRunning time 1:49
  45. 45Analysis copies and revertRunning time 1:13
  46. 46The update processRunning time 2:16
  47. 47Exports, print and Excel in and outRunning time 2:03
  48. 48Run analysis, compare and baselinesRunning time 2:20
  49. 49Exports and printRunning time 1:06
  50. 50Excel in and outRunning time 1:06
  51. 51Scheduling that survives the siteRunning time 1:47
  52. 52Logic, lags and leads: the practiceRunning time 1:50
  53. 53You were sent a schedule linkRunning time 1:18
  54. 54The viewer with a Basic planRunning time 1:28
  55. 55You were asked for an updateRunning time 1:13
Four ways inGetting inBuildSchedule itLook at itCostsShare and updateFiles and exportArticlesYou were sent something Minutes, end to end: 96 min 39 s
Register and try us for free for 30 days.Register