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

  • @deniskarozin1
    @deniskarozin1 Жыл бұрын

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

  • @sahidramdhani3191
    @sahidramdhani31912 жыл бұрын

    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!!

  • @sudheerkumar6427
    @sudheerkumar64272 жыл бұрын

    Awesome starter pack for PM!

  • @tshegofatsopule8053
    @tshegofatsopule8053 Жыл бұрын

    Hi Hemanth, thank you for this life saving document

  • @ijajbagwan8239
    @ijajbagwan82395 ай бұрын

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

  • @hrithikzgirl83
    @hrithikzgirl83 Жыл бұрын

    Thank you - this template is amazing!

  • @kimochidogi
    @kimochidogi2 жыл бұрын

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

  • @HEMANTHHEMU86

    @HEMANTHHEMU86

    2 жыл бұрын

    Glad to hear that

  • @nabilmsatfa3485
    @nabilmsatfa3485 Жыл бұрын

    Thank you very much ! Very helpful !

  • @mrslisajckson
    @mrslisajckson Жыл бұрын

    This chart is fantastic. Thank you very much

  • @alexandrasanchez2187
    @alexandrasanchez21873 ай бұрын

    you are a God amongst men.

  • @josuem.yamadjako4133
    @josuem.yamadjako41332 ай бұрын

    Very good template! Thanks

  • @Theviolingurl
    @Theviolingurl Жыл бұрын

    So cool, thank you!

  • @hebsursajid
    @hebsursajid2 жыл бұрын

    Thanks... Very helpful

  • @peaceandsleep3482
    @peaceandsleep34822 жыл бұрын

    FYI great work though one the best ones out there

  • @lamkhaidung9769
    @lamkhaidung97692 жыл бұрын

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

  • @TECProject
    @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?

  • @irenekocina9471
    @irenekocina94717 ай бұрын

    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

  • @daveh4208
    @daveh42082 жыл бұрын

    Where did you get the 'add new dependency' button that you have on the worksheet?

  • @wardhamilton2009
    @wardhamilton2009 Жыл бұрын

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

  • @91alezander
    @91alezander2 жыл бұрын

    Thank you very much Hemanth. It is a way to make update gantt chart run faster? Thank you!

  • @NMN797
    @NMN7974 ай бұрын

    Thank you. Can this spreadsheet view in Monthly intervals?

  • @latorracaclaudio6823
    @latorracaclaudio6823 Жыл бұрын

    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.

  • @RaviSharma_27
    @RaviSharma_27 Жыл бұрын

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

  • @alexanderforbes3457
    @alexanderforbes3457 Жыл бұрын

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

  • @moealshaibani914
    @moealshaibani9145 ай бұрын

    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

  • @kiranraj_al
    @kiranraj_al Жыл бұрын

    Can we do Cost management as well, using this excel sheet?

  • @ryans7940
    @ryans79403 ай бұрын

    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.

  • @vilasnargund2835
    @vilasnargund28352 жыл бұрын

    Hi Hemanth, How can I down load your templet?

  • @gaurav28jaswal
    @gaurav28jaswal2 жыл бұрын

    Excellent PM tracker pls help how to extend beyond 17 weeks

  • @shyammaddi1
    @shyammaddi17 ай бұрын

    how to add a percentage (%) of completion on each task along with status bars ?

  • @peaceandsleep3482
    @peaceandsleep34822 жыл бұрын

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

  • @sinumombits
    @sinumombits2 жыл бұрын

    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

    @Mr_MSingh

    2 жыл бұрын

    I also need that Help can not extend

  • @akhilperla6444
    @akhilperla6444 Жыл бұрын

    Can we add 2 dependencies for 1 task using this template

  • @sumaiyaesha6240
    @sumaiyaesha62402 жыл бұрын

    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

    @tiarasabrina168

    2 жыл бұрын

    yes please, i need it too:(

  • @wardhamilton2009

    @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.

  • @PGP_C__NehaMahmood
    @PGP_C__NehaMahmood8 ай бұрын

    How to edit the Gantt chart and how to change its color coding? Traditional Double click is not working

  • @tshegofatsopule8053
    @tshegofatsopule8053 Жыл бұрын

    i need to work on it till December how do i unlock the cells

  • @user-xj7mo5ng7z
    @user-xj7mo5ng7z Жыл бұрын

    How do you add dependency in excel? not the pop up button. but can you do a tutorial plz

  • @arianna2438
    @arianna24388 ай бұрын

    HI, thank you for sharing this document! Is it possible do add more weeks?

  • @HEMANTHHEMU86

    @HEMANTHHEMU86

    8 ай бұрын

    Yes, please check the description, i have provided two files

  • @sidl8606
    @sidl860611 ай бұрын

    how to add more columns? pls help here

  • @jenniferdevries3342
    @jenniferdevries33422 жыл бұрын

    How can you see the start dates?

  • @daniellis6396
    @daniellis6396 Жыл бұрын

    Hi, Is it possible to change the dates to months on the Ghant chart to show Monthly progress instead?

  • @daniellis6396

    @daniellis6396

    Жыл бұрын

    Thank you for sharing this file

  • @macroiu3778
    @macroiu37785 ай бұрын

    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....

  • @thatgirl6926
    @thatgirl692611 ай бұрын

    please how to add jalon?

  • @jespinob
    @jespinob2 ай бұрын

    how do I download the template?

  • @KGR_r
    @KGR_r8 ай бұрын

    when i change the month it breaks

  • @Ivan8orr
    @Ivan8orr8 ай бұрын

    how do you remove a dependncie? just delete it form the dependency tble?

  • @HEMANTHHEMU86

    @HEMANTHHEMU86

    8 ай бұрын

    Yes, that is correct

  • @chaitiroy7678
    @chaitiroy76782 жыл бұрын

    Nice demo? Is this free to access?

  • @HEMANTHHEMU86

    @HEMANTHHEMU86

    2 жыл бұрын

    Ofcourse

  • @chaitiroy7678

    @chaitiroy7678

    2 жыл бұрын

    @@HEMANTHHEMU86 how I can access? It's really useful, and needy one. Suggest pls.

  • @HEMANTHHEMU86

    @HEMANTHHEMU86

    2 жыл бұрын

    @@chaitiroy7678 link is in the description, download and use it :)

  • @TheSharath4321
    @TheSharath43218 ай бұрын

    How can I input planned start and end date ?

  • @HEMANTHHEMU86

    @HEMANTHHEMU86

    8 ай бұрын

    You can add your target end date and duration

  • @maxrex22
    @maxrex222 жыл бұрын

    Where can we get the file template?

  • @HEMANTHHEMU86

    @HEMANTHHEMU86

    2 жыл бұрын

    The link is in the description

  • @Mr_MSingh

    @Mr_MSingh

    2 жыл бұрын

    @@HEMANTHHEMU86 can you please help with how to e tend weeks

  • @vamshigarlapad8559
    @vamshigarlapad85592 жыл бұрын

    Party leda bodappu

  • @HEMANTHHEMU86

    @HEMANTHHEMU86

    2 жыл бұрын

    Nuvve ivvali ra bday party

  • @vamshigarlapad8559

    @vamshigarlapad8559

    2 жыл бұрын

    @@HEMANTHHEMU86 999 subscribers congratulations..

  • @joehodge2075
    @joehodge20752 жыл бұрын

    𝔭𝔯𝔬𝔪𝔬𝔰𝔪 😚

  • @mi59300
    @mi593005 ай бұрын

    TERRIFIC! just TERRIFIC!!!!

  • @mustaphaboucetta3843
    @mustaphaboucetta38432 жыл бұрын

    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.