Project Planning | Project Plan In Excel With Gantt Chart | Project Management In Excel |Simplilearn
🔥PMP® Certification Training Course: www.simplilear...
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 KZread channel: www.youtube.co...
To access the slides, click here: www.slideshare...
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.simplilear...
Learn more at: www.simplilear...
🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688
Пікірлер: 39
🔥PMP® Certification Training Course: www.simplilearn.com/project-management/pmp-certification-training?PMP_Q7D_ub50WPg&Comments&
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!
This is the video I have been looking for so long!!!!!!!!!
@SimplilearnOfficial
2 жыл бұрын
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
Thank You this is perfect and crisp knowledge sharing video 🙌🙌
@SimplilearnOfficial
3 жыл бұрын
Thanks a ton
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?
May I know where to get the tutorial for making a "Sprint Project Tracker" as mentioned in video 12:09 minutes?
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.
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....
Thank you. Very Informative.
@SimplilearnOfficial
2 жыл бұрын
Glad it was helpful!
thanks brother, it really helped a lot. thank you.
@SimplilearnOfficial
3 жыл бұрын
Always welcome
Thank you for sharing video and knowledge brother..very helpful
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 !
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!
Awesome!!
Really appreciate your work. Thank you
@SimplilearnOfficial
3 жыл бұрын
Much appreciated! Thank you for watching!
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.
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.
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!
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
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!
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!"