0% completed

All LessonsFree Lessons (3)

Step into Data Analysis

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

Spreadsheet Essentials

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

Talk to the Data

Know Your Data Getting Data from Files and Forms Getting Data from the Web

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

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

Data Insights Without Formulas

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

Speak Stats

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

Show What You Found

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

Conclusion

Master Data Analysis in Google Sheets/

...

/

Quiz Yourself on Data Prep Essentials

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

...