So when a date is entered as a holiday, that day is not used when the task finish is calculated. You can enter the list of holidays in a separate tab. A very useful tool and it comes in Excel (Gantt.xlsx) for different tasks like Gantt Bar Chart to understand planning of a project or company. The Gantt Chart Excel template also handles holidays. Tasks are highlighted when they are not 100% complete beyond the current dates. Highlights the current date on the Gantt Chart this provides a view from reference from the current date. Rating: A Gantt chart template for project management: Just input task and owner names. Get help creating one in Excel with this template. Auto calculates end dates for tasks based on start date and effort. A Gantt chart is a simple yet effective visual tool to give you a snapshot of all the important elements. Allows use of predecessors for tasks - this feature allows you to capture task dependencies. Along with creating a Gantt chart using a pre-designed template, you also have the ability to manually create your own Gantt chart in Excel, versions 2007. Typically, when planning, you need a detailed view, but you need a holistic view once planning is complete. You can view the timeline for 1, 2, or 5 days or even more. The Excel Gantt chart template allows users to enter the start date of the view. The timeline for the Gantt chart can be adjusted.