How To Create A Project Plan In Excel
ฝัง
- เผยแพร่เมื่อ 31 พ.ค. 2024
- How To Create A Project Plan In Excel.
Learn all the steps you need to take, and all the data points you need to capture, in this step-by-step how-to project plan excel tutorial.
🚀 Get your pre-built optimized Project Plan template👉 sowl.co/s/bec8nZ
.
👇 HOW I CAN HELP YOU 👇
--------------------------------------------
🗣️ Project Management Consultations:
properprojectmanagement.com/c...
📈 Project Management Solution Design, Build & Support:
properprojectmanagement.com/p...
📄 Project Management Templates:
properprojectmanagement.com/p...
🚀 General Business Inquiries/Sponsorships:
properprojectmanagement.com/b...
I watched like 10 videos about project planning and this is the very first in which someone ACTUALLY DOES something! THANK YOU!
So pleased to hear that, thanks for leaving me a comment and letting me know. Made my day!
Great Scott. This is exactly what I was looking for! Absolutely brilliant. Thank you!
indeed - wanted something simple, but creative and this does the job. Next phase is to how to add formulas., create ghatt chart, budget reports, pivot tables etc. Please keep them coming!
Lol for real!!!!
@@ProperProjectManagement
Man I agree so much. thank you.
This video confirms the fact that,proper planning & organization is most important, way before the kickstart meeting for a project to get approved.
❤Ty for the informative video,luv from India !
Well said!
This 20 minute video was brilliant, and I learned a lot... Thank you.
Great to hear it. Thanks for dropping a comment Barbara!
Wanted something simple, but creative and this does the job. Next phase is to how to add formulas., create ghatt chart, budget reports, pivot tables etc. Please keep them coming!
Good to hear it. Thanks! I actually have a whole playlist on these kinds of things. I suggest you check it out: th-cam.com/video/JwkhNM0IJaY/w-d-xo.html
Pls how do I get the project charter
Thank you so much, this tutorial was concise, clear and very helpful, I didn't have a clue how to start, that 17 minutes and 4 seconds was worth it
You're very welcome! Pleased to hear it helped!
This is so helpful! I wish it would include how to add dependencies on it. Thank you!
Thanks so much Jimara. That's a great idea; perhaps I can get that uploaded in a future video!
@jimara could you please share the sample if u have added dependencies
I’m starting an internship tomorrow and this is so incredibly helpful. Thanks so much!
Thanks so much C T. Best of luck for your first day!
Just created my first ever project plan, thank you, iv lived and subscribed
Welcome aboard! Good to hear it and best of luck with your plan!
thanks for the video, would have been great if you could also show us showing traffic light ways of monitoring tasks in Excel
Great suggestion! I will take note and may do another video on this going forward. Thanks Deborah!
I dont know how this video doesn't get many views. thank you so much for the amazing channel and valuable content. keep it up looking forward to see more vids. thnx a million
I appreciate that! Thank you for your kind words and dropping a comment. All the best!
Thank you, this is so helpful! 💚
I'm so glad! Thank you!
That was very clear, and I am thankful for your explanation.
Thanks Ammu, pleased it hear it
Brilliant! Thank you for this awesome video . Look forward to seeing more!
Thanks so much Sebastian; so pleased it was so useful!
This video was very helpful. I really appreciate that you created this video.
Thank you, pleased to hear it 😃
Hi Bud. You can just type the list values in place. No need to add them outside the plan. That way, it looks clean
Thanks for the tip! Good idea this!
Generally the list that drives the data validation should be in tables on a separate tab. Tables make it easy to expand the list, the separate sheet shops the validation lists being sprinkled all over the place.
That's a good point and a strategy I also use. If anyone reading wants to deploy this, you just need to create a new tab, add the dropdown values in a specified column and then run through the same process - except selecting the cell values from the column in the separate sheet as the data source.
@@ProperProjectManagement
Your way of teaching is so much better than what I see other people doing. Seeing someone go through and actually make something casually because they know what they’re doing, is incredibly helpful. I can always slow it down and analyze what you’re doing. thank yoy
Absolutely brilliant video as very clear and easy to follow
Many thanks Louise! Appreciate ethe kind comment
Educative, informative and valuable
Thank you so much, pleased to hear it was
This was so useful - thank you so much!
Thanks Alison; pleased to hear it helped! I appreciate you taking the time to leave me a comment too! :).
Love it! Nice video. I thought the PM Plan was a written document like in MS Word. Do you have anything like that? Wondering how that's developed from a planning perspective. (Typing it isn't a problem, just planning the flow).
Hello. I do have a video of how to create one in Word: th-cam.com/video/XXSAkNSiUkk/w-d-xo.html. Sometimes you will find a project plan has sections with subheadings and text, such as (heading ) project scope, (heading deliverables), etc
great video for my first time planning project, should 3.1 and 3.2 be indented? then 3.2.1 indented? just a question in regards to the formatting of those cells
Thank you, pleased it was useful. That's right. You want the indentation to show the relationship between the rows. So, 1,2,3,4 should be on one line, 3.2 indented once, 3.2.1 indented twice and so forth.
nice to see some of the excel functions put to good use. thanks for the instruction, it was very helpful.
You're welcome! Thanks for the kind words
Great tutorial. Thanks!
Glad it was helpful, thanks for dropping a comment.
Thank you so much, video was super helpful!
You're very welcome!
Thank you for sharing this. This was helpful.
You are so welcome!
This tutorial was really helpfu;,thanks man
Thanks, Kamogelo. Pleased to hear it was useful.
Super helpful! Thank you!
Great to hear it, thank you!
Very informative, thank you.
Very welcome
Thank you for this video. It was so informative!
You are so welcome!
Thx for the instructions really helpful, if i download the tempate, is the Gannt Chart also in that template?
It will be!
Is the template updated since it is two years ago this video was uploaded. If so I can purchase it :)
@@deansdrone Yes it is. You get 2 templates upon purchase (both have been kept up to date). The one produced during this video, plus the additional gantt chart view: sowl.co/s/bec8nZ
@@ProperProjectManagement Thx just download it
II really like the video but I definitely need more help with creating the gantt chart. Are you able to provide the template for this? Please let me know
Hello Michael. Excellent stuff; of course. Shoot me an email via the email address on my about page and I'll get it sent over to you!
Very useful. Thank you so much.
Glad it was helpful!
Thanks!
Thank you, Sandra! This is hugely appreciated!
When you say that indenting “creates a parent child relationship” is that aesthetic or does it actually and technically connect them as a group with the first as the parent? Ie does that mean if you make a function that that is adding up the cost of each task/item/child, will it automatically restrict the sum to the parent group, AND THEN allow you to separately create a function which allows you to sum the separate groups together?
Hello. It's both. Aesthetic and technical connection. You can use different functions, for instance you could use the =SUM(CHILDREN()) formula in the parental cell to sum everything underneath...
Very informative video, thanks for sharing this.
Glad it was helpful!
Great video! Easy to follow.
Glad you enjoyed it!
Thank you! would you be able to share the template you have (at the end of the video)? I like the formatting you have and I am not very good at excel to recreate quickly. Thanks in advance!
Hello Sridhar - sure. Please send me an email to theproperprojectmanagement[at]gmail.com and I'll respond with the template :)
@@ProperProjectManagement hi can I get this template pls?
Thank you for this!!
You're so welcome!
Great tutorial. It helped me a lot. Can you please help me on how to add the traffic light presentation of status.
Hello Ruchi. Great to hear it. Conditional formatting with icon sets would be the way to go. This explains it well: stevechasedocs.wordpress.com/2014/10/02/how-to-use-excel-traffic-lights-with-conditional-formatting-dates/
@@ProperProjectManagement thank you so much. My PP looks good now . :)
@@Suruhomemade You're welcome Ruchi
Amazing Thank you very much
Most welcome
Looking forward to your next video. :-)
Thanks Marc!
Awesome video for a beginner like myself.
Thank you Joevany; glad its helpful :)
Very very useful, thank you
Hi Marian. Pleased to hear it. Thanks for dropping a comment to let me know!
very good elastration
Thank you! Glad it was useful!
THANK YOU SO MUCH!
You're welcome Jerome!
Its great thank you 💓💓😌
I'm glad you like it. Thanks Sahan
where can i get the video for the gantt chart, that would help alot. thank you in advance.
Here it is: th-cam.com/video/F26ajyj8XNA/w-d-xo.html
Can you do a template of a project brief please
Added to the record list! Watch out for it!
@@ProperProjectManagement where is link?
Very useful, thanks for sharing
Glad it was helpful! Thanks James.
Very useful. Pls post and notify me with how use timeline and chart in excel asap. Thanks
Thanks Solinuu. Can you confirm what you are looking for? Sorry, not quite sure I understand your request. Thanks
Thank you so much sir that’s brilliant that was supportive a lot ❤
It's my pleasure! Thank you Abdullah
Loved!
Thanks!
Hi, thanks for the info. The Excel font made everything almost invisible (without a zoom-in option) and I had to listen to you more than read what you wrote. My eye sight is OK to read everything else on the internet.
Hello. Thanks for the feedback and I am sorry it was ineligible. I will consider this for future videos going forward and will use a different font. Thanks for letting me know and hope you still managed to get what you needed from it
Good video. A proposal for future video on this subject: how to link a Project Plan on Excel with a MS Proect file, so to have the freedom to manage the same database of activities on both softwares but for different scopes. Thank you
Great suggestion! Thank you!
THANKS🙏
You're welcome Ikwan
Love it. Super easy
Thank you! 😊
Thanks you 😊
Welcome 😊
thanks
You're welcome
Thanks you learn a lot on video
Glad to help. Thanks for your comment Mohamed.
Thank you for educating us.
Please share the template with me
Hello Jidda, thanks for your kind words.
Please send me an email via my YT about page email address, thanks!
Have you made the gantt chart video? Please share.
Hello Jay. Not yet, but will do shortly! Thanks for the reminder.
This is really helpful🙂
Glad you think so! Thanks Virasha
Hello thanks for this information! Do you have an email address? I have a question about how to track frequencies/durations in excel. I think you will understand it better once you see what I’m talking about.
Hello Gloria, thanks for the kind words. I do, you can find it over on my TH-cam About page. Feel free to send me a message and I'll do my best to help
This is an office life cheat code! #subscribed
Thanks so much Jasmine. Great to hear it was so useful :)
Can you please add a video on formatting the plan once it is created
Hello Mary. Great suggestion; will add this to my recording list!
How do you get the data validation include the color?
Hello Charles. Here's a good tutorial that shows you how: www.exceltip.com/tips/create-drop-down-list-in-excel-with-color.html
@@ProperProjectManagement thank you! Your videos helped me a lot put together a project plan to archive our SharePoint!
@@hotdogh2o Thanks a lot Charles. Pleased it's helped :)
Hello, the link for your templates isn't working, do you have a website with your templates?
Hello Ashley. The link is to my portfolio of templates. I do not have a website - this is a link to a download portal for a service I use called SendOwl. If you have any issues with downloading them if you have paid, send me an email at: theproperprojectmanagement[at]gmail.com and I will get it sorted for you ASAP! Thanks
The link to download your templates aren’t working? Do you have a website?
Hello. The link is to my portfolio of templates. I do not have a website - this is a link to a download portal for a service I use called SendOwl. If you have any issues with downloading them if you have paid, send me an email at: theproperprojectmanagement[at]gmail.com and I will get it sorted for you ASAP! Thanks
This very useful
Glad to hear it! Thanks for letting me know.
Great Video!
Glad you enjoyed it
So don't the dates apply only to the sub tasks?
Hi Rifath. Correct, the dates will apply only to the sub-tasks
great tutorial....however very hard to see your screen....clarity is extremely poor
Hi Ken. Sorry to hear about this. I wonder whether you are watching in a low resolution? Perhaps you could try changing that from the YT settings in the bottom right hand corner of the video player? Let me know if this solves it for you!
Keep going man!!!!
That's the plan!
Hello sir, can you please do a video about how to write a winning project proposal. Please sir
Hello Bodhi. I shall add it to my to-record list, thanks for the suggestion
@@ProperProjectManagement thank you so much sir. I am waiting for that. Since i am a project management undergraduate I really need to know about creating project proposals. 😥
Suggestion, at the start of the video show what you are building, why and how it works. Then how to make it last. This way, if it is not what someone is looking for they don't waste time watching the entire video. Again, just a suggestion. Thanks for sharing
Thanks for the idea!
wow i learned a lot through out this video
Fantastic, good to hear it Ishimwe!
Where’s the Gantt chart video for this?
Hello Rohit. It's a video I have just recorded and will be published shortly. Thanks for following up here.
One thing: Duration means nothing. Is it days, weeks, months, years, decades? I can clearly see that it is days but make sure that you are clear and consistent when naming things. Make sure that everyone know what everything is. Add a little summary on the top of what this specific sheet is for and what is it purpose as you will start with something simple like this but it will grow and expand. Always approach it with attitude: if I will send it to the most stupid person I know without any explanation, will they be able to understand it as I intended? If the answer is no then you don't have enough explanation in the spreadsheet. I know that it is a basic, not professional sheet but hey, put some effort in it and you can impress a lot of people.
Hello Draverros. Good points; adding a description and making columns clear certainly helps.
Hello, dear sir, I am a internshil officer, my mission is to get work for project beneficiaries in organizations, but I don't know how to write a plan to reach this goal, can you help me?
Hello. I am bit familiar with this so probably not the best person to help, unfortunately.
How to create a product backlog
One i need to record for sure, thanks!
👍👍🥀
Thank you
i am so gonna fail my assessment :(
You'll surprise yourself Kyle. Best of luck!
HELP! I purchased your spreadsheets. I have an issue with the download, the payment processor says I need to contact you, but there is no website no email address and the phone number to contact you
Hello. We will get this sorted do not worry; I'll get them all sent over to you right away. You can contact me here: properprojectmanagement.com/contact/
Waouh waouh...this os so helpful. Haf no idea of where to start from. Thank you. Please would you share your email, have some challenges maybe you can advise.Thanks
Glad it was helpful! Thanks for dropping a comment!