| Channel | Publish Date | Thumbnail & View Count | Download Video |
|---|---|---|---|
 David McLachlan | 2022-02-28 08:00:19 |  1,447,680 Views |
Fully assembled and ready for immediate use.
How to create the absolute BEST weekly Gantt chart in Excel that looks like Microsoft Project and is easier and better to use! Your managers and team will ask you, "Where did you get that?" and "Can I use it?" because it looks so good when you update your project.
Features include: milestone diamond, automatic Gantt chart bars, automatic counting of working days, automatic percentage completion on Gantt bars, colored bars for completed tasks and blocked tasks, and an automatic calendar.
Time stamp:
00:00 Gantt Chart Overview
01:53 First steps
02:31 Creating the calendar
05:26 Add lines and borders
06:40 Number of working days
07:24 Status dropdown list
09:21 Add Milestone Diamonds
10:27 Adding the Gantt bars
12:33 Add the percentage of completion to the bars
13:12 Adding the full gold color
14:03 Show blocked items
15:12 Fix window for scrolling
#Projectmanagement
All videos about project templates for Excel and Powerpoint: https://www.youtube.com/playlist?listPLEWFSKHjyrwydP0YBztsIdu47Csvp5KXf
Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.
