Project Planning | Project Plan In Excel With Gantt Chart | Project Management In Excel |Simplilearn

Поделиться
HTML-код
  • Опубликовано: 2 янв 2025

Комментарии • 39

  • @SimplilearnOfficial
    @SimplilearnOfficial  3 года назад +1

    🔥PMP® Certification Training - www.simplilearn.com/project-management/pmp-certification-training?Q7D_ub50WPg&Comments&RUclips
    🔥Professional Certificate Program in Project Management - www.simplilearn.com/pgp-project-management-certification-training-course?Q7D_ub50WPg&Comments&RUclips

  • @SimplilearnOfficial
    @SimplilearnOfficial  4 года назад +2

    Do you have any questions on this topic? Please share your feedback in the comment section below and we'll have our experts answer it for you. Thanks for watching the video. Cheers!

  • @trishacavanaugh8874
    @trishacavanaugh8874 3 года назад +2

    This was super helpful when I needed a simple but somewhat detailed overview of how to make a project plan quickly in Excel. Thank you.

  • @luisapowerafe
    @luisapowerafe 2 года назад

    This is the video I have been looking for so long!!!!!!!!!

    • @SimplilearnOfficial
      @SimplilearnOfficial  2 года назад

      Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )

  • @zunweitan6021
    @zunweitan6021 3 года назад +4

    May I know where to get the tutorial for making a "Sprint Project Tracker" as mentioned in video 12:09 minutes?

  • @sivakumargami
    @sivakumargami 2 года назад +1

    G8 job done, thanks team

    • @SimplilearnOfficial
      @SimplilearnOfficial  2 года назад

      Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.

  • @shivangeesaikia9721
    @shivangeesaikia9721 3 года назад +1

    Thank you. Very Informative.

  • @deolabamiro4u
    @deolabamiro4u 3 года назад +9

    Can you please tell what was used to determine the horizontal axis value 43831?

    • @tenagnegetachew3896
      @tenagnegetachew3896 3 года назад

      I have the same issue, I hope he will respond

    • @tenagnegetachew3896
      @tenagnegetachew3896 3 года назад +7

      Just click on the first date 01-Jan - and then under Custom you see the number...

    • @Random_videoss
      @Random_videoss 3 года назад +7

      Select the first date and go to home and change the number format to number
      Select the column > home > number format > select number option
      Nd thn u will have your axis value.

    • @ondrayz8831
      @ondrayz8831 2 года назад +3

      Odd that no one explained this, to anyone.
      Once you've determined what date you want as the minimum date/start date, enter it into a random blank cell on the spreadsheet; keep the cell highlighted. Then, change the cell format to 'General'. It's the pulldown menu that shows 'Accounting', 'Number', 'Time', etc. After you change it, Excel will show you what number it assigns to that specific date. That...goes into the Minimum box.
      Fancy computers....

  • @azzamabdullah3469
    @azzamabdullah3469 3 года назад +1

    thanks brother, it really helped a lot. thank you.

  • @sagarnalawade5613
    @sagarnalawade5613 Год назад

    Awesome!!

  • @tenagnegetachew3896
    @tenagnegetachew3896 3 года назад +1

    I found the answer to my question:-)

    • @SimplilearnOfficial
      @SimplilearnOfficial  3 года назад

      Hello thank you for watching our video .We are glad that we could help you in your learning !

  • @rlp861
    @rlp861 3 года назад +1

    Thank You this is perfect and crisp knowledge sharing video 🙌🙌

  • @fadzilyunos2985
    @fadzilyunos2985 2 года назад

    Thank you for sharing video and knowledge brother..very helpful

  • @abdulsakkoor7642
    @abdulsakkoor7642 3 года назад +1

    Gant chart will be done once the project schedule and duration is known right ? In that case how we can use this tool as a tracker? It shouldn't be ongoing?

  • @iamdeepshekhar
    @iamdeepshekhar 4 года назад

    Really appreciate your work. Thank you

  • @Tha.panjaitan
    @Tha.panjaitan 4 года назад

    in 9:22 there's a code, how we made the code? or it's a fix code that we have to follow?

    • @SimplilearnOfficial
      @SimplilearnOfficial  4 года назад +2

      "It is a fixed a value that is to be found out by copying the content in a separate block, then going to the custom option and selecting the numbers option. To understand this even better with the help of snapshots you can check the same video from 4:25. There you can see all the steps explained well along with all the options highlighted.
      Hope this helps!"

  • @tomstice8604
    @tomstice8604 3 года назад +1

    I'm just average when it comes to Excel. Trying to learn more. The 2D bar chart never did change colors...that's a step he missed.

  • @rlp861
    @rlp861 3 года назад

    Could you share the link where the planning templates were showcased thank you

    • @SimplilearnOfficial
      @SimplilearnOfficial  3 года назад

      Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.

    • @rlp861
      @rlp861 3 года назад

      @@SimplilearnOfficial Rohan.panade@hotmail.com
      Thank You

  • @BalajiMCAT
    @BalajiMCAT 3 года назад +1

    do you have this excel sheet ready to use ?

    • @SimplilearnOfficial
      @SimplilearnOfficial  3 года назад

      Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.

  • @CreativFarmGal
    @CreativFarmGal 3 года назад +1

    You are talking way too fast for me...I recommend you slow down just a bit for us newbies. ;-) Thank you for making this video though!

    • @SimplilearnOfficial
      @SimplilearnOfficial  3 года назад

      Thanks for the tip! We'll take care of this in the coming videos. Thank you for watching!

  • @williamrestrepo7244
    @williamrestrepo7244 2 года назад +1

    This is useful, but definitively not even close to Ms Project. There is no way to define the dependencies and prerequisites for each task, or multiple ones for that matter. You cannot create indentations in the tasks column directly and cannot retract them to ease of view. Just to mention a few. Thanks anyway.

    • @SimplilearnOfficial
      @SimplilearnOfficial  2 года назад

      Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!