Create a Value versus Complexity Matrix in Google Sheets

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

Understand what a value vs complexity matrix is and how to use it to prioritize features.

Create lookup tables, use data validation, and create charts in Google Sheets.

Showcase this hands-on experience in an interview

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

In this 2-hour long project-based course, you will create a Value versus Complexity Matrix in Google Sheets and learn how to interpret the outcomes to prioritize product features. In the process, you will review the basics of this prioritization framework as well as Google Sheets functionality such as lookup tables, data validation, and charts. Because time and resources are limited, prioritization is a critical skill that product managers must master in order to optimize product value and minimize development time and costs. There are several frameworks for prioritization which can be used individually or in combination. The Value versus Complexity/Cost Matrix is one commonly used framework that helps provide objectivity in the decision making process. 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.

Requirements

Familiarity with product management principles. Familiarity with Google Sheets.

Skills you will develop

Business AnalysisGoogle SheetsData AnalysisProduct ManagementPrioritization

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. Review the Value versus Complexity Matrix purpose and determine measures of value and complexity.

  2. Create a lookup table of standard variables for the Value and Complexity measures.

  3. Create a features data table and populate it with sample data.

  4. Generate a Value versus Complexity Matrix using the Bubble chart type in Google Sheets

  5. Interpret the Value versus Complexity chart to determine feature priorities and calculate value to complexity ratios to determine priority order of features.

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.