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 Data Prep Essentials

Test your knowledge of data preparation essentials.

We'll cover the following...

Technical Quiz

1.

If you want to highlight all cells in column A that contain unique values (i.e., values that appear only once), which custom formula would you use in conditional formatting?

A.

=ISBLANK(A1)

B.

=COUNTIF(A:A, A1)>1

C.

=ISERROR(A1)

D.

=COUNTIF(A:A, A1)=1

1 / 8

...