How to Make a Gantt Chart Using Excel [EASIEST GANTT CHART METHOD]
HTML-код
- Опубликовано: 21 авг 2024
- Are you trying to figure out how to make a Gantt chart but find yourself a little stuck? In this video, I’m teaching you how to create a Gantt chart in Excel (the easy way)!
I’ll show you:
- A complete Excel tutorial of how I make an Excel Gantt chart
- How to use an Excel Gantt chart for your project plan
- Gantt chart tutorial that will help with your project scheduling and project planning
- How to transfer your Excel skills into project management by making a Gantt chart for project management
- What my Gantt chart Excel template looks like
- How to use a Gantt chart Excel template for your project schedule
So, project manager, watch this whole video for the most straightforward Gantt chart tutorial out there!
➡️ FREE DOWNLOAD
Why Are My Projects Struggling? 6 Basics to Keep Your Projects From Failing:
www.slayprojec...
➡️ FREE PROJECT MANAGEMENT WEBINAR!
(Hosted by Adriana Girdler)
www.slayprojec...
➡️ 🌟 SLAY Project Management Online Course 🌟
adrianagirdler...
➡️ 🌟 SLAY Project Management PRO Program 🌟
[Includes SLAY online course + weekly group coaching + AI Project Tool]
adrianagirdler...
➡️ Order your #SLAYprojectmanagment T-shirt here: shop.cornersto...
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.CornerStone...
Instagram: / theadrianagirdler
LinkedIn: / adriana-girdler-cet-pm...
Facebook: / cornerstonedynamics
TikTok: / adrianagirdler
Thanks for watching my video “How to Make a Gantt Chart Using Excel [EASIEST GANTT CHART METHOD]”: • How to Make a Gantt Ch...
#AdrianaGirdler
#ProjectManagement
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
The best part of being subscribed to this channel is having notifications for videos with answers I didn't knew I had!
Thank you for subscribing and I am so pleased to hear that these videos continue to be of value to you!
I just wanted to add that you are an AMAZING teacher. Words cannot describe how much you have helped me...thank you so much!!
You are so welcome - happy to help! Thanks for watching. Cheers!
Wow, so easy to follow. I feel completely confident now to create my own Gantt chart!
Wonderful! Thanks for watching, cheers!
Thank you for providing an informative session on Gantt Chart. This will definitely help me in my project management course and to create the chart in excel by my own. Highly appreciated! 🙂
Hi Kawal, I'm so glad this video on how to make a Gantt chart was helpful to you! Best wishes, cheers!
This is such a simple way to make a Gantt chart! Thanks for the tutorial!
You’re very welcome! Thanks for watching, cheers!
SUperb.. I never was able to make a Gantt chart but I can do it now. Thank you Adriana :)
Nitin, I am thrilled to hear that from this video you will know be rocking Gantt Charts!! Amazing! Stay well, cheers!
Thanks Adriana. I'm doing a homework assignment for my PM class and this helped sooooo much!
Fantastic! I'm am so please that this has helped you! Cheers!
@@AdrianaGirdler One more thing. How do you connect "predecessors" in the timeline for connecting activities?
Never knew how to do a Gantt chart like this. Excellent!
Happy to hear you have learned something new! Thanks for watching, cheers!
Excellent! So easy and no need to use complicated software.
Indeed! Thanks for watching, cheers!
Awesome Adriana... This is GREAT... Thanks a trillion...
You're so welcome! Thanks for watching, cheers!
Thanks so much for sharing your experience Adriana!!!!!
You're very welcome! Thanks for watching, cheers!
You are the best👏. hopefully, one day i wl be confident as you
Thanks so much and thank you for watching, cheers!
Wow! Amazing 👏 🙀 thanks for teaching
My pleasure 😊 Thanks for watching, cheers!
Great tutorial!!! Thanks so much!!
You’re very welcome! Thanks for watching, cheers!
Fabulous!
This is amazing, thank you so much!
You're so welcome! Thanks for watching, cheers!
Super easy to understand. I like this tutorial so much. I really appreciate it and have subscribed to your YT channel. Thx Adriana.
I have some questions below. Hope you could show to us.
1. How to get the progress %, is it any formula to get this value? Could you share the formula?
2. How to set it to auto-change color on the End date based on the Past Date or Due Soon? Is it any formula to set?
Very useful tips
Thank you and thanks for watching, cheers!
Thank you, Adriana, this has been very helpful. Just one question: I can't do all you're showing us here on the 'online Excel' (I'm using SharePoint and need to have this stuff online). The issue starts at 1:55-there's no option in the online Excel. Thank you for advice.
You need to open the excel sheet in a desktop version to create it. Once created you can update it via the online version. SharePoint gives you both options to edit.
@@AdrianaGirdler thank you, I've done that-a nice Gantt Chart is ready! However, it seems that once uploading it into sharepoint, it turns only into a picture format which doesn't help a lot. any idea on this? if not, no worreis, it wa still a big help to make one GC offline. :)
I would search on the internet your question as this is a Microsoft program issue. Cheers.
Amazing 🤩
Thank you, and thanks for watching, cheers!
Thanks.
You're welcome! Thanks for watching, cheers!
Great Course....thanks for the information. BTW is there a way to incorporate the percentage into the video or is that basically just a simple assessment to add manually?
Hi Wyatt. Yes you can add a percentage complete to your Gantt Chart but you will first need to add it in manually as an addition column in your WBS.
Love u!
Thank you! Cheers 😊
Can you add dependencies?
● start to finish
● finish to start
● start to start
● finish to finish
How about other types of restraints?
Resources calendar(s)?
This is a very basic version so you will not be able to add those items.
@@AdrianaGirdler So I guess there is no possiblity of resource loading by person , craft or function.
Everything is possible. What you are asking for needs a more developed spreadsheet/ software.
I was curious, so I looked it up
A Gantt chart is a bar chart that illustrates a project schedule.
It was designed and popularized by Henry Gantt by 1915
GANTT is not an acronym; it doesn't stand for anything, and I totally thought it did.
Hi Adriana. Total newbie here, so…does this work on G-sheets?
Short answer….no. Wish it did. Some of the functionalities are not in Google Sheets.
I am not able to change my dates into numbers. Can you suggest something?
mine does not come out like this at alllllllll