How to Create an Excel Action Plan for Your Project [EASY + EFFECTIVE]
ฝัง
- เผยแพร่เมื่อ 27 ก.ย. 2022
- Are you wondering how to create an Excel action plan for your project? In this video, I’m teaching you how to create a project plan in Excel that will help you lead your project to success.
I’ll show you:
- How to create an action plan step-by-step using Excel
- Unique features and benefits of having your project plan in Excel
- How to copy my Excel project plan template
- Tips for creating a project plan in Excel
- What project planning steps you need to follow when you’re doing it in Excel
- An idea of what the project planning process looks like in Excel
So, Project Manager, if you’re trying to make your Excel project management plan but you don’t know where to start, stay tuned for this video where I’ll show you how to make a project management project plan by using one of the best project management tools: Excel!
➡️ F R E E D O W N L O A D :
Download my free “6 Basics to Keep Your Project From Failing” Cheat Sheet:
www.slayprojectmanagement.com...
➡️ F R E E W E B I N A R ! Are you striving for successful projects, but get overwhelmed figuring out what elements of project management to focus on for the best results? You need THE FAB 5 FUNDAMENTALS OF PROJECT MANAGEMENT webinar! You’ll learn the 5 things you need to do on EVERY project to bring it to success. So, if you can only focus your time and attention on 5 things when running your project, THESE are the 5 things you need to focus on. Sign up here: www.slayprojectmanagement.com...
➡️ 🌟SLAY Project Management Online Course 🌟: adrianagirdler.thinkific.com/...
➡️ Order your #SLAYprojectmanagment T-shirt here: shop.cornerstonedynamics.com/...
If you liked this video, please give it a thumbs up, subscribe, share it with your friends.
➡️S A Y H I O N S O C I A L :
Website: www.CornerStoneDynamics.com/
Instagram: / theadrianagirdler
LinkedIn: / adriana-girdler-cet-pm...
Facebook: / cornerstonedynamics
Thanks for watching my video “How to Create an Excel Action Plan for Your Project”: • How to Create an Excel...
#AdrianaGirdler
#ProjectManagement
![8 Key Project Management Responsibilities [YOU NEED TO KNOW THESE]](http://i.ytimg.com/vi/zCFaOAcVR5s/mqdefault.jpg)
![8 Key Project Management Responsibilities [YOU NEED TO KNOW THESE]](/img/tr.png)
![ตัวอย่างภาพยนตร์ Venom: The Last Dance [Official - Sub Thai]](http://i.ytimg.com/vi/DHPjvAwmnRE/mqdefault.jpg)
Thanks for watching. 🌟 Don't forget to sign up for my Free Online Training and learn THE FAB FIVE FUNDAMENTALS OF PROJECT MANAGEMENT. Click here to register: www.slayprojectmanagement.com/webinar
What a great step-by-step walkthrough of how to do this.
Great video. The explanation is so straight forward and makes it look so easy to do. Love the conditional formatting.
Thank you and thanks for watching, cheers!
Heaven sent .Thank You so much Adriana .Sincerely Appreciate this.
You are so welcome! Thanks you for watching, cheers!
Amazing clarity and brevity. Thanks Adriana.
You're so welcome! Thanks for watching, cheers!
I love these videos, Adriana!! Filing excel conditional formatting under ‘Slayed’. Thanks for the new tricks.
You’re most welcome! Thanks for watching, cheers!
lovely. Keep things simple 🎉🎉😊
Very well explained and helpful.Thank you!
You’re very welcome! Thanks for watching, cheers!
Oh. My. Goodness. I'm fairly advanced in Excel, but this video still taught me some new things AND is helping me to organize a project in a way that is far more efficient than methods I have used in the past. I really like how it uses Excel, because everyone DOES have access to it, and so I don't need to set up a subscription service for my team and purchase different software. Thanks so much for the videos!
Hi Nadine! I am so pleased that this video taught you some new things and that it’s helping you organize your current project. Just awesome! Thanks for watching. Cheers!
Hi Adriana! Thank you for sharing these videos. They helped me a land a job from teaching to project manager. I’m really happy and excited to start the journey! ♥️
You are so very welcome and a huge congratulations on your new journey as a PM! I also have a 45 min webinar that I think will benefit you. In this free training I walk you through the five key items needed on all projects, it's what I call the FAB FIVE FUNDAMENTALS OF PROJECT MANAGEMENT. The FAB FIVE are the 5 key items that you must do on every project - if you only do 5 things, these are them! It’s a great way to simplify projects, while still doing the essentials needed to ensure project success. Save your seat here: www.slayprojectmanagement.com/webinar
Wishing you great success, cheers!
^working for this same thing! Teacher to PM. Thank you, thank you!
THANK YOU LOVE YOUR VIDEOS, IT REALLY HELPS ME ALOT
You are so welcome! Thanks for watching, cheers!
Thanks alot for all you do to empower pple with your knowledge, this is so helpful
You are so very welcome! Thanks for watching, cheers!
Thumb up Adriana. Your sharing plus the tutorial really help me a lot.
Hi Natalie! I am so please to here that this tutorial helped you. Thanks for watching and wishing you all the best. Cheers!
Love this Adriana!❤
Thank you so much!
Thank you, Thank you, Thank you!! This is SO helpful! On to the GNATT chart tutorial!
You are so welcome! Hope you find the GANTT chart tutorial helpful too! Thanks for watching, cheers.
Very helpful
Superb 👏 I loved this. Thank you so much Adriana. You know what I always use the blue in the header :) like you and also I follow the Color coding Red Yellow Green :)
Fantastic Nitin 🙌🙌 and you are most welcome! Thanks for watching, cheers!
love it.. u didnt seem like a robot.. u allowed the fun human factor take front seat.. (first timer)
Thank you @Symmetry-Studios. I feel like when you are passionate about something it's easy to be yourself. Thanks for watching and taking the time to comment. Cheers!
Excellent instructions!!!
Glad you think so! Thanks for watching, cheers!
Hi Adriana - I am thankful to you for working on this amazing video. You have re-ignited my interest in Excel and project management. Regards, Chandi
@chanditome6826 I am thrilled that this video has re-ignited your interest! Thanks so much for watching and wish you all the best, cheers!
8:28 ❤Ty !
You're welcome! Thanks for watching, cheers!
Great Job
Thank you and thanks for watching, cheers!
Just discovered a great channel. 👏🏾👏🏾👏🏾👏🏾
Fantastic! Welcome and thanks for watching, cheers!
This is Awesome… I had to subscribe ❤️💪🏽
Thank you for watching and subscribing! Cheers!
Adriana these videos are great - i am transferring from nursing to project management and these videos are great at supporting me in my transition
Hi Stephanie, I am happy to hear these videos are helping you with your career transition! I do have a 45 min webinar that I think will benefit you as well. In this free training I walk you through the five key items needed on all projects, it's what I call the FAB FIVE FUNDAMENTALS OF PROJECT MANAGEMENT. The FAB FIVE are the 5 key items that you must do on every project - if you only do 5 things, these are them! It’s a great way to simplify projects, while still doing the essentials needed to ensure project success. Save your seat here: www.slayprojectmanagement.com/webinar
Wishing you all the best and great success! Cheers.
@@AdrianaGirdler Thanks - i am defo jumping in the deep end. Yet to find a job
very useful, thank you :)
You’re welcome! I hope this makes creating an action plan easier for you. Thanks for watching, cheers!
Awesome
Madam pls zoom u r screen when you share your learnings . Thankyou
Conditional formatting has always confused me. But this is a great tutorial on making a simple excel action plan!
Happy to hear this tutorial has helped! Thanks for watching, cheers!
I am loving all your videos - Sheila Ramirez
Thank you so much, Sheila! I am so glad to hear you are loving my videos. I do have a 45 min webinar that I think will benefit you as well. In this free training I walk you through the five key items needed on all projects, it's what I call the FAB FIVE FUNDAMENTALS OF PROJECT MANAGEMENT. The FAB FIVE are the 5 key items that you must do on every project - if you only do 5 things, these are them! It’s a great way to simplify projects, while still doing the essentials needed to ensure project success. Save your seat here: www.slayprojectmanagement.com/webinar
Wishing you all the best, cheers!
Love it mam
Thank you for watching, cheers!
This is great! I find Excel so much easier for the team than Microsoft Project.
Thanks for watching, cheers!
Great video thank you, Question my wife really likes you book case in the back where can I get one or is it custom?
Thanks for watching! I got the shelving unit at structube but not sure if it's still available. Cheers!
Hi Adriana, Hope your well. Thanks for the clip. For large projects with multiple 3rd parties is it worth having multiple plans or a master plan?
Master plan. Otherwise the amount of work you will be doing reviewing separate plans will be painful. Also, a master plan allows others to see what’s really involved in getting the project done and not just their activities.
Wonderful explanation! Everyone has access to Excel. I'm curious - you didn't discuss whether this was the master copy that somehow all ten teams updated; or whether each team is siloed working on their own tab in their own file? I was not aware that Excel could sync a file across multiple computers. Is that now a feature?
Hey Adam - great question! Definitely only use one master copy, but save it to a shared drive - it's the task owners responsibility to update their tasks, so everyone needs access. Sometimes I organize the tabs by person, sometimes I organize the tabs by department - it depends on the project. Cheers!
Thanks for this tutorial, very helpful. Not quite clear on the "end Date" column on the table. Is that the due date for the task or does the individual write in the date once it is completed?
End date is due date. Cheers.
How would you mark the task as completed? With the conditional formatting described the cell is the marked as past due.
Hi Donald. In the conditional formatting you can add a rule "text that contains"
In that rule I use completed and choose grey for the cell colour.
Hope this helps and thanks for watching, cheers!
Do you have any videos of project plans made in excel that can be transferred in to a Timeline Pro format?
Hi Devin, I don't have a video on that but will look into adding as one of our TH-cam topic suggestions.
Thanks for watching, cheers!
Followed step by step now im all set. Another thing i struggle with is finding the perfect tool for capturing meeting notes and actions so everyone has access and they don't get lost. Any suggestions or what works well for you?
Wonderful to hear Philippa! I use a Sharepoint site with my team where all critical documents can be found and updated along with all meeting notes. Check out my video on creating a Sharepoint for projects th-cam.com/video/t28rU_3bIyA/w-d-xo.html
Thanks for watching, cheers!
You didn't show how to create the percentage. Good video
How to calculate activity duration without including the weekends?
I have question!!!
I tried the conditional formatting but as soon the planned due date task is completed, it still shows in red because the conditional formatting not taking progress % into account.
So past due actually didn't worked for me
Is there any way out?
The conditional format is only linked to the dates and not the progress %. As I say at the 5:00 minute mark I allow for individual to fill that out themselves. This I important because if they only have 50% done and it’s due at the end of the week they I will be speaking to them to find out what is their plan to complete the task by the due date. It acts as a quality check.
Thanks Adriana, it helped.
You’re welcome
I don't understand how the project can be past due in September 1, 2022 and the due soon is September 30, 2022. Isn't the other way around. Past due October 1st, 2022; due soon September 30, 2022. The confusion is because the past due cell has the date September 1, 2022, forgetting that this cell has =Today().
It referencing a task….not the overall project due date.
As well, the past due and due soon are for conditional format rules.
Can you do one without conditional formatting?
Better you to use subtitles
@alemayehuhaile5600 you can turn on the closed caption in YT and that will give you subtitles across the bottom of the video. Hope that helps and thanks for watching, cheers!
Very well done for a beginner like me to learn. Can you please do more and train us how to make more easy formulation for cleaning or projects? Thank you.
Hi @kyleloks80 I do have a course that I think would be of benefit to you. It's called SLAY Project Management. In this course I walk you through the entire project process from start to finish to make sure you know exactly how to manage your project. It also includes all the templates you will need to keep you on track with your projects! You will also have access to the SLAY Project Management Facebook group where you can ask questions and share your wins with other Slayers! Here is the link to check it out adrianagirdler.thinkific.com/courses/slaypm
Thanks for watching, cheers!