Excel in and out

Export the Gantt as a workbook, download a three-week look-ahead from the viewer, and open an Excel schedule with Edit: the upload banner, the Excel banner and the Constraint column explain how it becomes a schedule.

Running time 1:06CaptionedNo account needed to watchVideo 50 of 55

All 55 Scheduler videos

Files and export · 4 of 4. Each mark’s length is its running time.

TRANSCRIPTEvery word of the video, as text.

Excel goes both ways: a workbook out, a look-ahead for the site, and a spreadsheet schedule back in.

Excel gives the Gantt as a workbook, for anyone who lives in spreadsheets. To look without editing, click View, the Gantt icon on a row. It opens in a new tab.

The three-week look-ahead lives in the viewer: Export, 3-week look-ahead. From the data date, three weeks. Change either date, then download. Nothing is saved into PC.o.

The sheet is the site's week-by-week list, in the look-ahead template PC.o reads back. Excel comes in too: open an Excel schedule with Edit.

It is an upload: try things out, then Save as. The banner explains: dates are held by Start On constraints, and the sheet's links did not come across.

Add links, remove the constraints as you go, and the sheet becomes a schedule the engine can run.

That was Excel in and out. Next in the Guide: run the analysis, compare, and pin a baseline.

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 sheetRunning 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 outWatchingRunning 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