Project planning on Excel with Gantt chart and Dependency arrows. Download template

In this video, I have explained how to use an Excel Project planning tool which I have created using Excel VBA. It has functionalities like color coded Gantt chart, Dependency arrows with very simple and user friendly actions.

To Connect with me:

#Excel #Gantt #Project

Intro: (0:00)
Features: (0:40)
How to Use: (1:53)
Color coding : (6:54)

[lpaone]

Great work! Saved me many hour of study.

[deniskarozin]

THANK YOU! This is exactly the kind of template I needed and super easy to show dependencies.

[sahidramdhani]

Thank you very much Hemanth for your valuable sharing. I am looking forward for your next videos related to supply chain and logistics. Great job!!

[tshegofatsopule]

Hi Hemanth, thank you for this life saving document

[ijajbagwan]

Thank you..
By far the best template for project planning and management.

[kimochidogi]

Great tool. Thanks for sharing it. Very useful to manage and give full visibility to project management

[FabulousMe]

This chart is fantastic. Thank you very much

[gauravjaswal]

Excellent PM tracker pls help how to extend beyond 17 weeks

[TECProject]

Great Tool. You have covered the basics. Is it possible to add Milestones, and the critical path as a different color line "RED" if it is known?

[ryans]

Thank you, excellent Gantt chart and video, this is very helpful. Something happened when I was adding data and the project shrunk to 17 weeks - I was unable to figure out how to make it change back to 137. I see others have had the same issue. After I downloaded another copy, it is back to 137 weeks. Does anyone know why it changes from 137 weeks to 17 weeks? I don't want to make the same mistake again and lose any work.

[lamkhaidung]

Thank you very much for your creative works.
May I ask for an edition with extend more timeline instead of just 4 months currently ?

[moealshaibani]

Hi, this is very very helpful. Thanks. But how can I make more columns to make it fit for one year plan. The template show 6 months only.

Please help

[peaceandsleep]

FYI great work though one the best ones out there

[wardhamilton]

Thank you Hemanth. How do I add weeks to the Gantt? Thank You.

[irenekocina]

Hello! Thank you so much for this, i love it! Question, is it possible to change the colors? And if so, how do i do that

[sumaiyaesha]

How to extend the sheets? i can't add month after May. Can you please let me know how can I other weeks or months?

[peaceandsleep]

how can I extend weeks, I need it for 93 weeks

[sinumombits]

Just wondering how to extend its use to more weeks, lets say 100 weeks?I tried adding more columns but its not allowing in current state. Good tool indeed!

[RaviSharma_]

Do you have any template that can track resources against a project and map them against project timelines

[alexanderforbes]

this is amazing, thank you. can you tell me how to change weeks to months?