Project Planning | Project Plan In Excel With Gantt Chart | Project Management In Excel |Simplilearn
ฝัง
- เผยแพร่เมื่อ 2 ต.ค. 2024
- 🔥PMP® Certification Training - www.simplilear...
🔥PMP® Certification Training - 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 TH-cam 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
Learn more at: www.simplilear...
🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688
🔥PMP® Certification Training - www.simplilearn.com/project-management/pmp-certification-training?Q7D_ub50WPg&Comments&TH-cam
🔥Professional Certificate Program in Project Management - www.simplilearn.com/pgp-project-management-certification-training-course?Q7D_ub50WPg&Comments&TH-cam
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!
Can you please tell what was used to determine the horizontal axis value 43831?
I have the same issue, I hope he will respond
Just click on the first date 01-Jan - and then under Custom you see the number...
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.
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....
May I know where to get the tutorial for making a "Sprint Project Tracker" as mentioned in video 12:09 minutes?
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.
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?
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!
Thanks for the tip! We'll take care of this in the coming videos. Thank you for watching!
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.
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
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.
Glad it was helpful! Thank you for watching!
do you have this excel sheet ready to use ?
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
I found the answer to my question:-)
Hello thank you for watching our video .We are glad that we could help you in your learning !
Thank you. Very Informative.
Glad it was helpful!
Thank You this is perfect and crisp knowledge sharing video 🙌🙌
Thanks a ton
thanks brother, it really helped a lot. thank you.
Always welcome
Thank you for sharing video and knowledge brother..very helpful
G8 job done, thanks team
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.
Could you share the link where the planning templates were showcased thank you
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.
@@SimplilearnOfficial Rohan.panade@hotmail.com
Thank You
This is the video I have been looking for so long!!!!!!!!!
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
Awesome!!
Really appreciate your work. Thank you
Much appreciated! Thank you for watching!
in 9:22 there's a code, how we made the code? or it's a fix code that we have to follow?
"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!"