Search⌘ K

Master Data Analysis in Google Sheets

0%

1.Step into Data Analysis

Meet the Analyst’s World Inside the Analyst’s Mind Data with a Conscience

2.Spreadsheet Essentials

Sheet Smarts (Part I)Sheet Smarts (Part II)Organizing the Workspace Sharing and Collaboration Quiz Yourself on Google Sheet Essentials

3.Talk to the Data

Know Your Data Getting Data from Files and Forms Getting Data from the Web Quiz Yourself on Getting Data into Sheets

4.Data Prep Essentials

Navigate Data Wrangling Find and Fix Data Issues Shape, Scale, and Standardize Data Tidy Up Text Data Tidy Up Dates and Times Quiz Yourself on Data Prep Essentials

5.Data Insights with Formulas

Basic Aggregations Conditional Aggregations Logical Branching Scale It Up with ARRAYFORMULA()Lookup Like a Pro Transform with QUERY()Quiz Yourself on Data Analysis with Formulas

6.Data Insights Without Formulas

Organize the Data Pivot Power Slicers in Action Quiz Yourself on Organizing Data

7.Speak Stats

Unveiling the Numbers Connect the Dots Test Your Thinking Quiz Yourself on Statistical Insights

8.Show What You Found

Charting Data in Sheets Beyond Basic Visuals Presenting Your Visuals Exploring Advanced Visuals Quiz Yourself on Data Visualization

9.Conclusion

Master Data Analysis in Google Sheets

Quiz Yourself on Getting Data into Sheets

Test your understanding of how to bring data into Google Sheets.

We'll cover the following...

Technical Quiz

1.

Which question should we ask first when starting a data analysis task?

A.

What chart should we build?

B.

Where did the data come from?

C.

How do we format numbers?

D.

What color theme should we use?

1 / 5

...