Excel Gantt Chart With Dependencies Links | Project Planner Spreadsheet | Macro Enabled Template
Originally published: 09/08/2021 10:32
Publication number: ELQ-78311-1
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; 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

Acquire business license for $7.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

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Excel Gantt Chart With Dependencies Links | Project Planner Spreadsheet | Macro Enabled Template?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...