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

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

by Kacharuk Marukpitak
Business AnalystFollow

224 views|1 comment|Bookmark Add to cart - $7.00

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; or
Microsoft 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 project
1.1 Project Start : Project start date
1.2 Project Timeline Duration : Duration for project timeline (60 – 1200 days)
1.3 Weekend mode : Select the option of weekend days
1.4 Show weekend : Whether to show the columns for weekends in the drawing area
1.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 calculation

2. Click Save Configs and you're good to go

3. Double click on the cells below Task column and you will see an input form.
3.1 Choose task type : Group / Task / Milestone
3.2 Enter the summary of the item
3.3 To select Start/Finish date, click at the Pick Date button and select the targeted date from the calendar area

4. To add dependency connector:
4.1 Click at the gantt bar representing the predecessor item - the bar will be highlighted with a bold outline
4.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