Draw Insights with Crosstabs Reports in Google Sheets

4.3
stars
6 ratings
Offered By
Coursera Project Network
In this Guided Project, you will:

Understand the benefits of using pivot tables to create crosstabs reports and access Google Sheets.

Create a pivot table and visually organize the data with communication in mind.

Understand how statistics can support communicating the data story in crosstabs reports.

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

Crosstabs reports present select slices of data in a matrix format making it easier to visualize patterns and explore similarities and differences between categories or variables. In this course, we’ll explore the pivot-table tactics applied in Google Sheets to create crosstabs reports, conduct a preliminary—exploratory—analysis of the data within the report, and learn how visually presenting data in a crosstabs report can aid the user in their discovery of insights that tell the data’s story. By the end of this course, you will be able to apply pivot table tactics to create crosstabs reports and share data in your business’s domain. 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

Data AnalysisVisual AnalyticsCommunicating about DataBusiness IntelligenceExploratory Data Analysis

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

  2. Import data into Google Sheets

  3. Begin Exploratory Data Analysis and design report

  4. Create pivot table and visually organize the data into a crosstabs report

  5. Format the crosstabs report

  6. Add evidence to support the data's story

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

Reviews

TOP REVIEWS FROM DRAW INSIGHTS WITH CROSSTABS REPORTS IN GOOGLE SHEETS

View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.