How To Create A Project Timeline In Excel - 3 Different Ways!

Поділитися
Вставка
  • Опубліковано 25 гру 2024

КОМЕНТАРІ • 52

  • @ProperProjectManagement
    @ProperProjectManagement  Рік тому +1

    🚀Get my project management templates 👉 properprojectmanagement.com/project-management-templates/

  • @MilanDjordjevicBG
    @MilanDjordjevicBG Рік тому

    Short and with value, excellent. Thanks

  • @MarianaSantoyo-w6q
    @MarianaSantoyo-w6q 10 місяців тому

    This is amazing, thank you so much for your help! I really appreciated how you explained every single step including the formulas. You make things so easy, THANK YOU!!!

    • @ProperProjectManagement
      @ProperProjectManagement  10 місяців тому

      You're very welcome! Thanks for letting me know and providing this feedback, means a lot.

  • @MpomartMedia
    @MpomartMedia Рік тому +3

    Thank you so much for sharing your wisdom in a manner that is straight to the point and accessible, this has saved a many sleepless night, please keep up the great work, it is very much appreciated. God bless you 🙏🙏🙏

  • @susansmith1398
    @susansmith1398 2 роки тому +1

    Your third example is exactly what I needed and saved me tons of time!

  • @hitesharas8941
    @hitesharas8941 2 роки тому +1

    Smooth & precise. Thank You

  • @lovelynuzomaozougwu1811
    @lovelynuzomaozougwu1811 Рік тому

    Thank you for the Video! Your 3rd example was very helpful.

  • @worldwanderer1485
    @worldwanderer1485 2 роки тому +3

    Thank you so much for these tutorials! You're such a good teacher, with clear explanations and concise instructions. This is the third tutorial I've watched today but already started subscribing from the very first one I watched. Please keep making them!

    • @ProperProjectManagement
      @ProperProjectManagement  2 роки тому

      Thank you so much for the kind words, it means a lot. I am so pleased to hear they are useful!!

  • @GabrielNguyen
    @GabrielNguyen 2 роки тому +1

    This is actually what I'm looking for. Thanks so much, it's really helpful.

  • @alhawsawi84
    @alhawsawi84 2 роки тому +1

    Your thorough explanation was really helpful. The third Gantt chart example is a perfect fit for my needs.
    Really, you should keep doing what you're doing because it's incredible. Thanks

    • @ProperProjectManagement
      @ProperProjectManagement  2 роки тому

      Thanks so much for the kind words and leaving me a nice comment, it's appreciated. And so pleased it was helpful for you! Take care!

  • @aidanordin3345
    @aidanordin3345 2 роки тому +1

    Thank you sir! 🥰

  • @earlofopsis1307
    @earlofopsis1307 3 місяці тому

    Instructions worked like a charm! Now I just have to figure out how to change the fill colors as things are completed or late.

  • @kane227able
    @kane227able 3 роки тому +2

    Really good info. I’m looking to start my project management career, and your excel tips are brilliant.

    • @ProperProjectManagement
      @ProperProjectManagement  3 роки тому

      Thanks so much Kane. Appreciate you leaving a message and for the kind words. All the best with your project management career!

  • @MrVikram0123
    @MrVikram0123 2 роки тому +1

    It was really helpfull....
    Great 👍

  • @axiicrow613
    @axiicrow613 2 роки тому

    thank you so much. You saved my homework, since I was completely lost 😁

  • @samahs2929
    @samahs2929 3 роки тому +1

    Thank u u saved my day

  • @tamararumiantseva1288
    @tamararumiantseva1288 2 роки тому +1

    If you write the IF formula in the conditional formatting, will it give the same result?

    • @ProperProjectManagement
      @ProperProjectManagement  2 роки тому

      Great question; never tried it to be honest! Will give it a go and report back

  • @Amari_by_Marris
    @Amari_by_Marris 9 місяців тому

    Thank you

  • @r.shawishamin7502
    @r.shawishamin7502 2 роки тому +1

    well done sir

  • @qasimmustafa5901
    @qasimmustafa5901 Рік тому

    Great video. One point to note, for duration please use (End date - Start Date + 1) otherwise the gantt chart and duration days don't match obviously.

  • @chisomdom-anyanwu8096
    @chisomdom-anyanwu8096 Рік тому

    Please how did you add the X in the third template

  • @raymondzwart4829
    @raymondzwart4829 2 роки тому +1

    Can you help me, i got an error on the first date on the Gannt, i can send you a pic if you want. It is in Dutch.

    • @ProperProjectManagement
      @ProperProjectManagement  2 роки тому

      Hello Raymond; sure I'll happily try to help here. Send me an email and I'll respond there

  • @machenesononloso
    @machenesononloso 2 роки тому +2

    Again… and what if there needs to be an interruption of few days between a given task?

    • @ProperProjectManagement
      @ProperProjectManagement  2 роки тому

      Hello, this guide gives a good idea about the concept of what to do: tensix.com/scheduling-a-task-interruption-in-microsoft-project-2013/

  • @erictsang789
    @erictsang789 2 роки тому +1

    I learnt a formula =median(startdate,enddate,selectdate)=selectdate , as the new rule in the conditional formating.
    easier

  • @alisheryuldashev9857
    @alisheryuldashev9857 Рік тому

    how to create timeline in one row for 1 task, which has 3 subtasks, without "stairs"?

  • @andrewderrig7144
    @andrewderrig7144 2 роки тому +1

    Good presentation. Can you pass me that template?