Excel Gantt Chart With Dependencies Links | Project Planner Spreadsheet | Macro Enabled Template
Originally published: 09/08/2021 10:32
Last version published: 01/03/2023 11:13
Publication number: ELQ-78311-3
View all versions & Certificate
certified

Excel Gantt Chart With Dependencies Links | Project Planner Spreadsheet | Macro Enabled Template

This is an automated Gantt Chart + Task Dependencies Excel template.

Description
This is an automated Gantt Chart + Task Dependencies Excel template.Designed for those who love to plan their work & life with no fuss.Visualizing your plan has never been this easy!🎁🎁With this template, you have..🎁🎁- Gantt Charts & Dependency Links visualization- Color customization- Automatic highlighting for schedule conflict- Actual vs Plan comparison- Tasks grouping- Daily & weekly views- Automatic highlighting for holiday- Up to 1200 days of project timeline duration📹📹See more details with demo video📹📹https://quickquick.page.link/xlgantt⚠️⚠️BEFORE YOU PURCHASE⚠️⚠️Download the trial version to test it out first!https://quickquick.page.link/xlganttchart_trial🧑‍💻👨‍💻Software Requirement🧑‍💻👨‍💻Microsoft Office 365, 2013, 2016, 2019 for Windows; orMicrosoft Office 365 for Mac🔢🔢🔢Quick Start Guide🔢🔢🔢(See How-to video and detailed instructions at https://quickquick.page.link/xlgantt )1. Go to the Project sheet and click Configs button at the top of the sheet to start setting up your project1.1 Project Start : Project start date1.2 Project Timeline Duration : Duration for project timeline (60 – 1200 days)1.3 Weekend mode : Select the option of weekend days1.4 Show weekend : Whether to show the columns for weekends in the drawing area1.5 Gantt Chart Labeling : Choose gantt chart labeling mode (None / Summary / Dates / Summary + Dates).1.6 Holidays : Dates of holiday to be highlighted in the drawing area, also used for Net Workdays calculation2. Click Save Configs and you're good to go3. Double click on the cells below Task column and you will see an input form.3.1 Choose task type : Group / Task / Milestone3.2 Enter the summary of the item3.3 To select Start/Finish date, click at the Pick Date button and select the targeted date from the calendar area4. To add dependency connector:4.1 Click at the gantt bar representing the predecessor item - the bar will be highlighted with a bold outline4.2 Click at the gantt bar representing the dependent item - there will be a Link Type pop-up, choose the desired type and hit Save.Remark: Dependency connector only works with Task or Milestone. Group is not supported.

This Best Practice includes
1 Macro Excel Workbook

Acquire business license for $11.00

Add to cart

Add to bookmarks

Discuss

Further information

Project Planning / Activities Planning

Microsoft Office 365, 2013, 2016, 2019 for Windows; or Microsoft Office 365 for Mac


0.0 / 5 (0 votes)

please wait...