Create a Marketing Analysis dashboard using G-Spreadsheets

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

Enter any data set on google sheets, organize and format your rows and columns and create drop down lists.

Create basic query formulas related to the data set and translate formulas into dashboard and charts to help you better visualize your analysis.

Clock1 hour
BeginnerBeginner
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

In this 1-hour long project-based course, you will learn how to enter any data set on google sheets, organize and format your rows and columns, create drop down lists, create basic query formulas related to the data set and finally translate those formulas into dashboard and charts to help you better visualize your analysis. This will help beginner market analysts to prepare reports and dashboards to present it to their managers. 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.

Skills you will develop

Google SpreadsheetsChartsMarketing StrategyQuery formulasTables

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. Access google sheets and enter your data.

  2. Create drop down lists.

  3. Differentiate dissimilar data by color.

  4. Compose query formulas to create “Count” tables.

  5. Create Pie and Bar charts to present your data.

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.