How to Make a Gantt Chart Using Excel [EASIEST GANTT CHART METHOD]
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.slayprojectmanagement.com...
➡️ FREE PROJECT MANAGEMENT WEBINAR!
(Hosted by Adriana Girdler)
www.slayprojectmanagement.com...
➡️ 🌟 SLAY Project Management Online Course 🌟
adrianagirdler.thinkific.com/...
➡️ 🌟 SLAY Project Management PRO Program 🌟
[Includes SLAY online course + weekly group coaching + AI Project Tool]
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
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
Пікірлер: 57
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!
@AdrianaGirdler
Жыл бұрын
Thank you for subscribing and I am so pleased to hear that these videos continue to be of value to you!
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! 🙂
@AdrianaGirdler
Жыл бұрын
Hi Kawal, I'm so glad this video on how to make a Gantt chart was helpful to you! Best wishes, cheers!
I just wanted to add that you are an AMAZING teacher. Words cannot describe how much you have helped me...thank you so much!!
@AdrianaGirdler
Жыл бұрын
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!
@AdrianaGirdler
Жыл бұрын
Wonderful! Thanks for watching, cheers!
This is such a simple way to make a Gantt chart! Thanks for the tutorial!
@AdrianaGirdler
Жыл бұрын
You’re very welcome! Thanks for watching, cheers!
Thanks so much for sharing your experience Adriana!!!!!
@AdrianaGirdler
Жыл бұрын
You're very welcome! Thanks for watching, cheers!
Excellent! So easy and no need to use complicated software.
@AdrianaGirdler
Жыл бұрын
Indeed! Thanks for watching, cheers!
Great tutorial!!! Thanks so much!!
@AdrianaGirdler
Жыл бұрын
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 :)
@AdrianaGirdler
Жыл бұрын
Nitin, I am thrilled to hear that from this video you will know be rocking Gantt Charts!! Amazing! Stay well, cheers!
This is amazing, thank you so much!
@AdrianaGirdler
Жыл бұрын
You're so welcome! Thanks for watching, cheers!
Never knew how to do a Gantt chart like this. Excellent!
@AdrianaGirdler
Жыл бұрын
Happy to hear you have learned something new! Thanks for watching, cheers!
Awesome Adriana... This is GREAT... Thanks a trillion...
@AdrianaGirdler
7 ай бұрын
You're so welcome! Thanks for watching, cheers!
Fabulous!
Thanks Adriana. I'm doing a homework assignment for my PM class and this helped sooooo much!
@AdrianaGirdler
Жыл бұрын
Fantastic! I'm am so please that this has helped you! Cheers!
@jefftidwell3228
Жыл бұрын
@@AdrianaGirdler One more thing. How do you connect "predecessors" in the timeline for connecting activities?
Wow! Amazing 👏 🙀 thanks for teaching
@AdrianaGirdler
9 ай бұрын
My pleasure 😊 Thanks for watching, cheers!
You are the best👏. hopefully, one day i wl be confident as you
@AdrianaGirdler
Жыл бұрын
Thanks so much and thank you for watching, cheers!
Very useful tips
@AdrianaGirdler
Жыл бұрын
Thank you and thanks for watching, cheers!
Amazing 🤩
@AdrianaGirdler
Жыл бұрын
Thank you, and 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?
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?
@AdrianaGirdler
Жыл бұрын
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!
@AdrianaGirdler
Жыл бұрын
Thank you! Cheers 😊
Thanks.
@AdrianaGirdler
Жыл бұрын
You're welcome! 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.
@AdrianaGirdler
4 ай бұрын
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.
@worldofkubo
4 ай бұрын
@@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. :)
@AdrianaGirdler
4 ай бұрын
I would search on the internet your question as this is a Microsoft program issue. Cheers.
Hi Adriana. Total newbie here, so…does this work on G-sheets?
@AdrianaGirdler
Жыл бұрын
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
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.
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)?
@AdrianaGirdler
9 ай бұрын
This is a very basic version so you will not be able to add those items.
@robertduda4234
9 ай бұрын
@@AdrianaGirdler So I guess there is no possiblity of resource loading by person , craft or function.
@AdrianaGirdler
9 ай бұрын
Everything is possible. What you are asking for needs a more developed spreadsheet/ software.