Project Planner (Advanced) - Excel Template - v2 - Product Demo

Project Planner (Advanced) - ExcelTemplate - v2 - Product Demo

In this video, I demonstrate how to use the Project Planner (Advanced) Excel Template.

Relevant Links:

PURPOSE
• Determine if/when projects will complete
• Estimate the cost of each project
• Prepare project, resource & task schedules
• Understand resource utilization
• Identify opportunities to improve project completions & resource management
BENEFITS
• Easy to use. Plan your projects in few minutes.
• Saves time by automatically scheduling tasks
• Ready-made printable schedules and plan
• Flexible in accommodating common scenarios
• All within Microsoft Excel. No programming used.
FEATURES
• Automatic scheduling of tasks given the inputs
• Planning done at the granular unit of hours
• Instantly create resource, task and project schedules (Gantt charts)
• Schedule based on Project and Task prioritization
• Resource can work on parallel projects
• Each task can have up to two predecessors (dependencies)
o A task begins the day after its predecessors have ended.
• Project Start Dates can be restricted (optional)
• Project/Task due dates can be input (optional) to compute completion on time
• Customize company weekends (non-working days) and holidays
• Each resource can have different work hours for each weekday
• Each resource can have personal leave days (partial or full)
• Each resource can have different cost per hour

-~-~~-~~~-~~-~-
-~-~~-~~~-~~-~-

[marriwamiq]

Question: if there are multiple projects with different start and end date, than how can we put one date in planning period on slide 1 in your demo.

[tibintitus]

Can we input more than 1 resource for each task.

[stuvey]

hi, are we able to copy paste the project name in to the tasks tab instead of using a drop down when there's 50 projects to assign?