Make This Awesome Gantt Chart in Excel (for Project Management)

Make Gantt Chart in Excel for Project Management.

In this video we'll create this awesome Gantt Chart in Excel in 4 simple steps. It's fully dynamic, so you can change the project start date and the whole chart timeline changes, you can track the progress of your tasks on a percentage basis, and even add new activities as you see fit.

As we start from scratch, first we'll add all the values and format the chart. Second, we'll create a dynamic date timeline in weeks. Third, we'll create conditional formatting formulas to make the Gantt Chart dynamic. Finally, we'll freeze panes and add more conditional formatting to track the current week.

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Intro
0:30​ - 1. Chart Formatting
4:17​ - 2. Dynamic Date Values
7:27​ - 3. Dynamic Fill Values
15:18​ - 4. Final Edits (view & date tracker)

[adelinogoncalves]

The most intelligible Gantt Chart tutorial I´ve seen by far, thanks a lot Kenji, great job!

[HotButteredCorn]

Kenji: Outstanding! Very helpful. Thank you. However, for those of us who actually practice project management, there are a few items missing in many Excel Gantts. Tasks often need to include one of the following:
Finish-to-Start (FS): Task A must be complete before Task B begins.
Finish-to-Finish (FF): Task A must be complete before Task B can be complete.
Start-to-Start (SS): Task A must have started before Task B can start.
Start-to-Finish (SF): Task A must have started before Task B can finish

Any ideas about how to include this? 🙄😀

[Consultelainewilliams]

This is the most straightforward Gantt chart I’ve come across. I completed it and felt very accomplished. Thank you.

[PeterSimons-dh]

Just used Kenji's explanation to make my first construction timeline. Easy to understand and translate to my own works

[tahirif]

This the 1/3 excel gantt chart video I seen and tested that actually works. Great work keep it up.

[mebu]

Thank you, Kenji! This video was a life saver. Really well explained. I was able to create a project plan so easily. Much gratitude to u!

[MitchellArgall]

I did not have the "freeze pane" in my Gantt chart. Makes it much more appealing now. This was an awesome video and your speaking tone was spot on and easy to follow along.

[bamnisah]

Great guide and great styling suggestions! This made tackling a new project super easy and relieved a lot of stress! Thank you very much :)

[okasanjaya]

Thank you for the amazing content, very helpful in making the Gantt Chart easier with the simple explanation in this video, god bless you Kenji 😇💚

[KevinOKeefe-qwcl]

Thanks. Very helpful for making a quick gantt chart for simply tracking projects without having to use MS Project.

[kabeerjijel]

Thanks.Great job. I completed the Gantt chart and am very excited to implement it. You are excellent, sir

[RCSMgmt]

This is brilliantly executed; informative, concise, yet thorough—not to mention polished. Thanks very much taking the time, it's been extremely helpful.

[thanh-tunglai]

Thank you, Kenji, I wish I had found your channel sooner.

[themosdiary]

Thank you so very much for the insightful video, this was truly simple and easy to follow. I have just made my first gantt chart with no cheat and I feel proud.

[deansdrone]

Thank you so much really fun learning this. In the formula =EN(H$7>=$C10;H$7<=$D10) I had to change the, (komma) with ; otherwise I doesn't work

[lpaone]

Thank you, Kenji. That was priceless.

A great explanation! Good work and thank you for sharing.

[RoxanneWilliamson-ezzb]

Thank you so much ! I do a lot of data analysis and tracking so this is very helpful 👏🏾

[mr.alsifat]

It was a breakthrough for me,
So easy way to understand and creating a gantt chart. Thank you.

[yoddhasingh]

Thanks Kenji, you're a lifesaver