Create an Assignment Schedule Tracker in Google Sheets

Offered By
Coursera Project Network
In this Free Guided Project, you will:

Learn a step-by-step approach to build a Google Sheets spreadsheet and link different tabs.

Prepare and review multiple Google products that will be used for team building and communication skills during a project.

Showcase this hands-on experience in an interview

Clock2 hours
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

By the end of this project, you will be able to create an assignment tracker worksheet in Google Sheets. You will learn how to create a working schedule tracker and use formulas in your spreadsheet. You will be able to create and organize this tool to prevent any negative effects to your company, and utilize this tool at any management level. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.


Familiarity of Google Sheets or a workbook and a free Google email account is required for this project.

Skills you will develop

goal settingBusinessCommunicationData ValidationProcess Improvement

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Create Assignment Schedule template in Google Sheets.

  2. Create Assignment Details template in Google Sheets.

  3. Create Assignment Details dates and progress in Google Sheets.

  4. Create Assignment Schedule dates and progress in Google Sheets.

  5. Complete Assignment Schedule and Details and link different sheets in Google Sheets.

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.