There are a lot of Excel Gantt chart templates out there.
So how do you know which one is the best one?
Well, I'm glad you asked.
Much like a good template does most
of the heavy lifting for your Gantt chart,
we've done the heavy lifting for you
and created the best Gantt chart templates for you
to download and use for free.
If you find this video helpful, let
us know by giving a thumbs up and make
sure to subscribe to our channel for more videos like this.
In our Excel Gantt chart template,
you'll see a blue header that lets
you know what data is in each of your tasks' columns--
the task name, the start date for the task, what day
of the month the task begins on, the tasks' end
date, the duration of the task, how many task days have been
completed, how many tasks days are remaining,
the team member assigned to the task, and the tasks percent
complete.
Notice a few of the columns have an asterisk in the header
and contain light gray cells.
These columns are automatically calculated.
You won't have to input anything here.
The template also contains white rows of information.
These represent the individual tasks in your project.
It's here where you'll update the Gantt chart with your tasks
information for scheduling and tracking progress.
These white cells are all editable.
The darker gray rows are the headers
for the individual projects you want to track.
For a larger project, you can also
use them to break your tasks into subgroups.
They're also editable from column A in the Excel sheet.
Now let's get into your project.
You can replace the example task name in any task
by clicking in the cell and updating the name.
Let's change it to Task 1.
Hit Tab or click off the cell.
And you'll notice that the new task name is now
reflected in your Gantt chart to the right.
Now, let's edit the start date in column C.
We'll change it from 1/5 to 1/1.
Hit Tab or click off the cell.
Notice that the day of the month cell for the task
is automatically adjusted to the first day of the month
from the fifth day of the month.
Also, the blue taskbar has extended left to the first.
Your task now begins on January 1.
You can also see that the duration of your task
is automatically updated from four days to eight days,
reflecting your new start date of 1/1.
The tasks days complete cell has updated as well.
But notice the days remaining cell has stayed at zero.
That's because the task is at 100% complete.
We'll get to that in a moment.
Click on cell E9.
This is the end date for your task.
You can update this here.
Let's extend it from 1/8 to 1/21.
Notice how the duration and days complete cells
have changed automatically.
Also, the blue taskbar has extended to the right
to January 21.
You have now rescheduled the task.
The next three light gray cells automatically
update for you to show you information about your task.
The duration cell shows you how many days your task spans.
In the case of task 1, it's now 21.
The days complete and days remaining cells
show you how far into your task you are,
and how much time you have left to complete it.
This can be adjusted by using the percent complete cell
to the right.
It is currently set at 100% complete.
But if you adjust it to, say, 25%,
you'll see that it affects the information in the days
complete and days remaining cells.
It is updated to show 5.525 days complete and 15.75
days remaining.
You'll also notice that the blue taskbar in the Gantt chart
has updated to show the task is 25% complete as well.
Lastly, you can assign the task to someone in the team member
cell.
Click on cell E9 and adjust the name.
You can edit, reschedule, and update any task
in your Gantt chart the same way.
There's no denying that Excel can work for some very
basic project management needs.
But it has its limits, many limits.
There are no dependencies, milestones
or resource management.
It's cumbersome to move tasks around.
And if your projects get much larger than a few tasks,
they can get pretty unwieldy.
There is a better way.
Team Gantt is an online project management
tool that makes it easy to create project plans.
Just enter your task names and drag the taskbars
out for as long as each task should take.
You can add dependencies to your tasks, upload documents,
and leave comments.
Assign tasks to coworkers and teammates.
Even see how busy your whole team
is so you know if you can assign more work to them.
And sharing your project plans is simple and flexible too.
You can embed a read-only version of your plan
into a web page, export your plan as a PDF,
or even print your whole plan.
We worked hard to make team Gantt as simple as possible.
We love it, and we think you will too.
Go to teamgantt.com to start planning for free today.
If this video was helpful to you,
we'd love it if you let us know in the comments.
And don't forget to like and subscribe
so you don't miss any more of our videos.
Thanks for watching.