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

🔥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 KZbin channel: kzbin.info...
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 - [phone]

[@SimplilearnOfficial]

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

[@SimplilearnOfficial]

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]

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]

Glad it was helpful! Thank you for watching!

[@fadzilyunos2985]

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

[@rlp861]

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

[@SimplilearnOfficial]

Thanks a ton

[@luisapowerafe]

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 : )

[@sagarnalawade5613]

Awesome!!

[@iamdeepshekhar]

Really appreciate your work. Thank you

[@SimplilearnOfficial]

Much appreciated! Thank you for watching!

[@azzamabdullah3469]

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

[@SimplilearnOfficial]

Always welcome

[@zunweitan6021]

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

[@abdulsakkoor7642]

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?

[@shivangeesaikia9721]

Thank you. Very Informative.

[@SimplilearnOfficial]

Glad it was helpful!

[@sivakumargami]

G8 job done, thanks team

[@SimplilearnOfficial]

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]

I found the answer to my question:-)

[@SimplilearnOfficial]

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

[@deolabamiro4u]

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

[@tenagnegetachew3896]

I have the same issue, I hope he will respond

[@tenagnegetachew3896]

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

[@Random_videoss]

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]

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]

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]

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

[@SimplilearnOfficial]

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]

@@SimplilearnOfficial [e-mail] Thank You

[@BalajiMCAT]

do you have this excel sheet ready to use ?

[@SimplilearnOfficial]

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

[@Tha.panjaitan]

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

[@SimplilearnOfficial]

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

[@williamrestrepo7244]

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]

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

[@CreativFarmGal]

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]

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