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

Подписаться 4,2 млн

Просмотров 211 тыс.

50% 1

🔥PMP® Certification Training Course: www.simplilearn.com/project-m...
This video on project planning in Excel will help us understand the process of project planning concerning Excel. The video will explain the process of project management in Excel, elaborating on the reasons why we should use excel for project management. Then we will see the basics of a Gantt chart, along with understanding the process of making a Gantt chart in Excel. We will also see different Microsoft Excel templates, along with their features. Now, let us get started.
The below topics are explained in this project planning tutorial:
1. What is a project plan? 00:37
2. Project management in Excel 01:12
3. Why use Microsoft Excel? 01:35
4. How to make a Gantt chart in Excel? 02:03
5. Microsoft Excel templates 10:35
To learn more about Project Management, subscribe to our RU-vid channel: ru-vid.com...
To access the slides, click here: www.slideshare.net/Simplilear...
Watch more videos on Project Management: • PMP® Training Videos |...
#ProjectPlanning #ProjectPlanningInProjectManagement #ProjectPlanningInExcel #PMP #PMPTrainingVideos #PMPCertificationTraining #ProjectManagement #SimplilearmPMP #Simplilearn
✅About Post Graduate Program In Project Management
This project management certificate program will cover strategization and management - project, program, risk, quality, complexity management, customer-centric digital transformation, PMO implementation, and agile and scrum skills; and allow you to earn 146 Professional Development Units (PDUs) for maintaining CCR for PMI certifications.
✅Key features
- Receive Post Graduate Program Certificate and Alumni Association Membership from UMass Amherst.
- 8X higher live interaction in live online classes by industry experts.
- Earn 146 PDUs for PMI related certifications with 35 contact hours and 4 simulation examinations to ace the PMP exam.
- 100% Money back guarantee.
- Live classes entirely delivered by Simplilearn's expert instructors.
✅Skills Covered
- Project Management
- Agile Management
- Project Risk Management
- Quality Management
- Lean six sigma green belt LSSGB
- Digital Transformation
- Design Thinking
- Customer experience design
- Leadership Skills
🔥 Enroll for FREE Project Management Course & Get your Completion Certificate: www.simplilearn.com/learn-pro...
Learn more at: www.simplilearn.com/project-m...
🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

Опубликовано:

10 фев 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

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

🔥PMP® Certification Training Course: www.simplilearn.com/project-management/pmp-certification-training?PMP_Q7D_ub50WPg&Comments&

@SimplilearnOfficial 4 года назад

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 3 года назад

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.

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

Glad it was helpful! Thank you for watching!

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

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

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

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

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

Thanks a ton

@iamdeepshekhar 3 года назад

Really appreciate your work. Thank you

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

Much appreciated! Thank you for watching!

@sagarnalawade5613 Год назад

Awesome!!

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

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

@SimplilearnOfficial Год назад

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

@azzamabdullah3469 2 года назад

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

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

Always welcome

@shivangeesaikia9721 2 года назад

Thank you. Very Informative.

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

Glad it was helpful!

@sivakumargami 2 года назад

G8 job done, thanks team

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

@tenagnegetachew3896 2 года назад

I found the answer to my question:-)

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

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

@zunweitan6021 2 года назад

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

@abdulsakkoor7642 2 года назад

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?

@deolabamiro4u 2 года назад

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

@tenagnegetachew3896 2 года назад

I have the same issue, I hope he will respond

@tenagnegetachew3896 2 года назад

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

@Random_videoss 2 года назад

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 2 года назад

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

@tomstice8604 3 года назад

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.

@BalajiMCAT 2 года назад

do you have this excel sheet ready to use ?

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

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

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

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

@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 3 года назад

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

@CreativFarmGal 3 года назад

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 3 года назад

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

@williamrestrepo7244 2 года назад

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 2 года назад

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

@Tha.panjaitan 3 года назад

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

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

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