In this video, you will set up your group’s schedule by updating the details in the schedule template.
To begin, replace the default title in the template with one that includes your project name.
You can wrap the text if the title is too long.
Set the start date for your project.
The sheet will automatically update with the correct dates and corresponding days of the week.
Delete the text that explains this on the template.
If you only plan to work on your project during certain hours of the day or days of the week,
delete the rows and columns for times and days you will not be working.
If you plan on working at times of the day not listed in the schedule template,
add rows for additional time slots.
Copy and paste the formatting of an existing row for consistency.
And add the time to the row.
As you add to your schedule, it can be helpful to see the rows at the top with information like dates
and days of the week. Freeze these rows so that you can see them as you scroll down.
If your project will last for more than one week,
duplicate the sheet for every week you want to add to your schedule.
Change the dates for each new sheet you create.
And add labels to the tabs at the bottom of each sheet.
Now, it’s your turn:
Give your schedule a title and wrap the text,
Set the start date for your project,
Delete unneeded rows or columns and copy and paste formatting,
Freeze rows at the top,
And duplicate the sheet and change dates.