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

Wondering how to create a project timeline in Excel? In this tutorial I show you the steps you need to take and present to you three different project timeline options to consider.
🚀 Get your pre-built Project Timeline Template 👉 sowl.co/s/TSmfx
👇 HOW I CAN HELP YOU 👇
--------------------------------------------
🗣️ Project Management Consultations:
properprojectmanagement.com/c...
📈 Project Management Solution Design, Build & Support:
properprojectmanagement.com/p...
📄 Project Management Templates:
properprojectmanagement.com/p...
🚀 General Business Inquiries/Sponsorships:
properprojectmanagement.com/b...

Пікірлер: 50

  • @ProperProjectManagement
    @ProperProjectManagement11 ай бұрын

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

  • @worldwanderer1485
    @worldwanderer14852 жыл бұрын

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

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

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

  • @ProperProjectManagement

    @ProperProjectManagement

    Жыл бұрын

    You're very welcome. so glad to hear it was so helpful :)

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

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

  • @ProperProjectManagement

    @ProperProjectManagement

    Жыл бұрын

    Great to hear, thanks Susan

  • @MilanDjordjevicBG
    @MilanDjordjevicBG7 ай бұрын

    Short and with value, excellent. Thanks

  • @ProperProjectManagement

    @ProperProjectManagement

    7 ай бұрын

    Glad you enjoyed it!

  • @GabrielNguyen
    @GabrielNguyen2 жыл бұрын

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

  • @ProperProjectManagement

    @ProperProjectManagement

    2 жыл бұрын

    Great to hear, thanks Gabriel

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

    Smooth & precise. Thank You

  • @ProperProjectManagement

    @ProperProjectManagement

    Жыл бұрын

    Thank you Hitesh!

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

    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

    Жыл бұрын

    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!

  • @kane227able
    @kane227able2 жыл бұрын

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

  • @ProperProjectManagement

    @ProperProjectManagement

    2 жыл бұрын

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

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

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

  • @ProperProjectManagement

    @ProperProjectManagement

    Жыл бұрын

    You're very welcome!

  • @user-pg2te1cf4b
    @user-pg2te1cf4b5 ай бұрын

    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

    5 ай бұрын

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

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

    Thank you sir! 🥰

  • @ProperProjectManagement

    @ProperProjectManagement

    Жыл бұрын

    Most welcome!

  • @samahs2929
    @samahs29292 жыл бұрын

    Thank u u saved my day

  • @ProperProjectManagement

    @ProperProjectManagement

    2 жыл бұрын

    Thanks Samah. Pleased this was useful!

  • @MrVikram0123
    @MrVikram01232 жыл бұрын

    It was really helpfull.... Great 👍

  • @ProperProjectManagement

    @ProperProjectManagement

    2 жыл бұрын

    Thank you V J Singh. Pleased to hear this!

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

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

  • @ProperProjectManagement

    @ProperProjectManagement

    Жыл бұрын

    You're welcome 😊 So glad to hear this Axii

  • @stellamarrisachusi9904
    @stellamarrisachusi99043 ай бұрын

    Thank you

  • @ProperProjectManagement

    @ProperProjectManagement

    3 ай бұрын

    You're welcome

  • @r.shawishamin7502
    @r.shawishamin7502 Жыл бұрын

    well done sir

  • @ProperProjectManagement

    @ProperProjectManagement

    Жыл бұрын

    Thanks Ramadan!

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

  • @ProperProjectManagement

    @ProperProjectManagement

    Жыл бұрын

    Great advice, thank you.

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

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

  • @ProperProjectManagement

    @ProperProjectManagement

    Жыл бұрын

    Love this. Thanks for sharing Eric!

  • @tamararumiantseva1288
    @tamararumiantseva12882 жыл бұрын

    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

  • @machenesononloso
    @machenesononloso2 жыл бұрын

    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/

  • @raymondzwart4829
    @raymondzwart48292 жыл бұрын

    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

  • @alisheryuldashev9857
    @alisheryuldashev98577 ай бұрын

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

  • @ProperProjectManagement

    @ProperProjectManagement

    7 ай бұрын

    Sorry, I am not sure I quite understand. Can you please elaborate. Thanks

  • @chisomdom-anyanwu8096
    @chisomdom-anyanwu8096 Жыл бұрын

    Please how did you add the X in the third template

  • @ProperProjectManagement

    @ProperProjectManagement

    Жыл бұрын

    Hello. Its a capital X from the keyboard

  • @chisomdom-anyanwu8096

    @chisomdom-anyanwu8096

    Жыл бұрын

    @@ProperProjectManagement Ohh okay thank you But I saw asterisk above the x?

  • @andrewderrig7144
    @andrewderrig71442 жыл бұрын

    Good presentation. Can you pass me that template?

  • @ProperProjectManagement

    @ProperProjectManagement

    2 жыл бұрын

    Hello Andrew. Sure, just send me an email and I'll get it right over to you!