By now, you have a project tracker in Google Sheets that tracks a number of tasks related
to your project by due dates, ownership, and status.
In this video, you will improve the appearance of your tracker, so it is more readable and
Then, you will share it with others.
To start, make the categories headers stand out more clearly.
To do that, highlight the text, and change the style.
Bold the text.
Make the type larger.
You can even change the text color if you like.
Next, change the column width for columns that need more room for text.
For example, adjust the “notes” column, so project team members who leave notes in
your sheet have more room to write.
To ensure text fits inside the borders of a cell so it is easy to read, wrap the text.
To make the sheet more readable, change the size and style of the text.
Add additional information like meeting notes, proposals, or other files that might be useful
to people who view your tracker.
This example links the project charter from the “Create a Project Charter” activity.
To link another file to your spreadsheet, open a new tab and go to Google Drive.
Find the file, open it, and copy the link.
Then, return to the project tracker, and insert the link in the “Resources” column.
You can also use the “insert link” function to search the internet for resources.
Type in a search term, and select a link from the results list.
Once your sheet is easy to read and contains useful information about your project, it
is ready to share.
Partner with another person in your class to exchange project trackers.
You don’t need to sit with your partner, but you do need to exchange names
and email addresses.
Share your tracker.
Write a note about what you would like your partner to look at and do.
Check your email for the project tracker your partner shared with you.
Try using their project tracker.
Update the status of tasks.
Write a note in the “notes” column.
If you have other feedback to give them, insert a comment.
Now, it’s your turn: Change the type style, size, color, and formatting
in your project tracker to make it more readable and professional looking.
Share your project tracker with a partner.
View your partner’s project tracker, try using it, and give them feedback.