Create a Project Management Tracker using Google Sheets

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

Organize a google sheet for project management tracker.

Add static content to a project management tracker.

Add data and conditionals to a project management tracker.

Showcase this hands-on experience in an interview

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

As a small business owner, budgets are tight for the ‘extras’. Oftentimes this means affording some of those high dollar tools for marketing is not possible. Small business owners must turn to free or low cost alternatives, sometimes those tools can be better than the high dollar tools. One easy to use and manageable alternative is a free spreadsheet program called Google Sheets. In this project, you’ll learn how to create a simple project management tracker. By the end of this project, you will have Google Sheets project management tracker template for your next development project presentation. 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.


This is a beginner level project, some knowledge of google sheets, project management, and business is recommended but not required.

Skills you will develop

SpreadsheetGoogle SheetsManagementBusinessProject Management

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. Set up a google account.

  2. Develop a google sheet project.

  3. Add content to the google sheet.

  4. Add more content and worksheet tabs.

  5. Add data and conditionals.

  6. Add links and color to the sheet.

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.