TECH-005 - Create a quick and simple Time Line (Gantt Chart) in Excel

Learn how to create a quick and simple Time Line (Gantt Chart) in Excel.

In this video you will use the MIN formula, the MAX formula, the IF formula, the AND formula, as well as 'Greater Than' and 'Less Than' conditions to create the Time Line (Gantt Chart) in your spreadsheet. You will also use Conditional Formatting to enhance the looks of your Time Line.

I hope this tool is something you can use in your daily routine so you get more with less effort.

If you have a challenge with Excel that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve common Excel challenges from our viewers and subscribers.

Thank you for watching.

Check out some of our previous videos in the links below:

* TECH-004 - Calculate total days between dates in Excel

* TECH-003 - Display images in comments

* TECH-002 - Find intersecting values in a table in Excel

[shahrahman]

Man you've explained it smoothly with literal ease. This is by far one of the easiest video to follow and understand thoroughly. Great job!

[Alfedaih]

Man this is the simples/easies way, great job in explaining
each step but in same time the video is not long. like follow done

[johnnyelias]

Dude, First of all, I would like to thank you for your hard work, but most importantly, I would like to thank you for making all your spreadsheets available for free. My life has been made so much easier and more efficient by this.

[gangberry]

Thank you so much. You’ve saved so many poor students and newbies with this tutorial.

[rajatjaiswal]

Very helpful Tutorial. Explained the concept in a very easy to understand manner. I am an Architect and was looking for a tutorial to help me schedule my projects in execution and this tutorial has exactly what I was looking for. Thanks for this. Keep up the good work...

[sbastian]

Man, 10 years I worked on the construction time schedule, recently I saw Excel doing automatic things, I think it can only be in MS Project, rock you man..

[Bigboibremmer]

I must say one of the best teaching videos on YouTube, i thank you so much.

[csutka]

You have no idea how much this helped me! This is exactly what I needed to create a super effective timeline for my project. Thank you very much! Needless to say, I am a new subscriber.

[henriekiio]

the wonders of internet...5 years later this video has saved me from a very sticky situation. Thanks man God BLESS YOU!!

[sophiaillingworth]

The easiest and best explanation I've seen on how to set up a Gantt Chart. Thank you TECH.

[IAMBELEVEN]

I got mixed up looking for Gantt charts tutorial, this video of yours really got me what i need...thank u a lot for making life so easy.

[koushiksen]

Really wonderful video. I found that the end date should require adjustment.
I guess the end date should be start date + Task Duration - 1.

[braintubeguy]

I must admit I was super excited watching you video as I have been looking for something like this for some time now, Then when I saw the work that went behind creating knowing how bad I am with excel- I thought I just wish he can just share that template. And then, there it is the first thing in your description... Thank you very very much for this, You made this lady very happy...

[tanisha_gg]

Thank you so much for this! It has helped me complete my dissertation for final year of University

[iamseen]

2024 and still you are a life saver! thanks for the free templates as well. New subscriber here :)

[gcredaroli]

This was SO helpful! Thank you so much for taking the time to make this video. Your tips, formulas, layout, etc. were all really easy to follow. I really appreciate it!

[nosiphoshelembe]

I just want to say Thank you. I was doing my assignment and it needed a Gantt chart i didn't even know where to start, i followed your tutorial and i must say it is outstanding. you a life saver.

[andrewzeegers]

you are a true Excel wizard. it's the real thing.

[LekkereDirk]

fantastic, just what I needed. BTW; I needed weeks instead of days, very easy to change; just used day+7 for the colums and added a row with WEEKNUMBER above it. Again, fantastic tutorial.

[laurahulland]

This video has changed my life!!! Thank you so much! ❤️🥰❤️