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.
Excel file: drive.google.com/file/d/1DIpI...
Excel file with 137 weeks: drive.google.com/file/d/10Ht3...
To Connect with me:
Email: hemu161095@gmail.com
#Excel #Gantt #Project
Intro: (0:00)
Features: (0:40)
How to Use: (1:53)
Color coding : (6:54)
Пікірлер: 69
THANK YOU! This is exactly the kind of template I needed and super easy to show dependencies.
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!!
Awesome starter pack for PM!
Hi Hemanth, thank you for this life saving document
Thank you.. By far the best template for project planning and management.
Thank you - this template is amazing!
Great tool. Thanks for sharing it. Very useful to manage and give full visibility to project management
@HEMANTHHEMU86
2 жыл бұрын
Glad to hear that
Thank you very much ! Very helpful !
This chart is fantastic. Thank you very much
you are a God amongst men.
Very good template! Thanks
So cool, thank you!
Thanks... Very helpful
FYI great work though one the best ones out there
Thank you very much for your creative works. May I ask for an edition with extend more timeline instead of just 4 months currently ?
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?
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
Where did you get the 'add new dependency' button that you have on the worksheet?
Thank you Hemanth. How do I add weeks to the Gantt? Thank You.
Thank you very much Hemanth. It is a way to make update gantt chart run faster? Thank you!
Thank you. Can this spreadsheet view in Monthly intervals?
Hi Hemanth, thanks for sharing this PM Tools which is really nice. How can I extend the weeks lets say for one year? The sheet is protected. Thanks.
Do you have any template that can track resources against a project and map them against project timelines
this is amazing, thank you. can you tell me how to change weeks to months?
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
Can we do Cost management as well, using this excel sheet?
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.
Hi Hemanth, How can I down load your templet?
Excellent PM tracker pls help how to extend beyond 17 weeks
how to add a percentage (%) of completion on each task along with status bars ?
how can I extend weeks, I need it for 93 weeks
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!
@Mr_MSingh
2 жыл бұрын
I also need that Help can not extend
Can we add 2 dependencies for 1 task using this template
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?
@tiarasabrina168
2 жыл бұрын
yes please, i need it too:(
@wardhamilton2009
Жыл бұрын
Hello. Did you receive a response or figure-out how to extend the months or weeks beyond the initial 4 months or 17 weeks? Thank you.
How to edit the Gantt chart and how to change its color coding? Traditional Double click is not working
i need to work on it till December how do i unlock the cells
How do you add dependency in excel? not the pop up button. but can you do a tutorial plz
HI, thank you for sharing this document! Is it possible do add more weeks?
@HEMANTHHEMU86
8 ай бұрын
Yes, please check the description, i have provided two files
how to add more columns? pls help here
How can you see the start dates?
Hi, Is it possible to change the dates to months on the Ghant chart to show Monthly progress instead?
@daniellis6396
Жыл бұрын
Thank you for sharing this file
super unselfish deed done by you for the most unsmart person like me that I hope my further request for more functions such as automatic calculation of % completion in terms of whole project & the project variances between actual & planned comparison by means of adding more columns on the same table presented by you would not be too demanding & annoying to you....
please how to add jalon?
how do I download the template?
when i change the month it breaks
how do you remove a dependncie? just delete it form the dependency tble?
@HEMANTHHEMU86
8 ай бұрын
Yes, that is correct
Nice demo? Is this free to access?
@HEMANTHHEMU86
2 жыл бұрын
Ofcourse
@chaitiroy7678
2 жыл бұрын
@@HEMANTHHEMU86 how I can access? It's really useful, and needy one. Suggest pls.
@HEMANTHHEMU86
2 жыл бұрын
@@chaitiroy7678 link is in the description, download and use it :)
How can I input planned start and end date ?
@HEMANTHHEMU86
8 ай бұрын
You can add your target end date and duration
Where can we get the file template?
@HEMANTHHEMU86
2 жыл бұрын
The link is in the description
@Mr_MSingh
2 жыл бұрын
@@HEMANTHHEMU86 can you please help with how to e tend weeks
Party leda bodappu
@HEMANTHHEMU86
2 жыл бұрын
Nuvve ivvali ra bday party
@vamshigarlapad8559
2 жыл бұрын
@@HEMANTHHEMU86 999 subscribers congratulations..
𝔭𝔯𝔬𝔪𝔬𝔰𝔪 😚
TERRIFIC! just TERRIFIC!!!!
Great tool, thanks for sharing. Sir I have an inquiry about Gurobi do you use it often, I have something I need your help in it, if you can. how can I contact you or do you have fiverr or Upwork? Thank you so much for your videos.