In which you learn to interrogate cells to determine the data type of their contents, and to convert between data types.

Data types for data science

What IS*() the data type?

Checking rarer data types

Finding missing data

Dteectnig bdaly tpyed dtaa

Convert or die!

Making numbers while the sun shines

How the 104% live

Converting logical values to numbers

Preaching to the CONVERT()ed

What's in a cell?

In which you learn to apply log and square root transformations to numbers, round them up and down, and generate random numbers.

Common data transformations

Logarithmic transformations

Exponential transformations

Square root transformations

Rounding and formatting numbers

Round and round

From floor to ceiling

Rounding negative numbers

Generating random numbers

Generating uniform random numbers

Generating random numbers from other distributions

Working with numbers

In which you learn how to work with logical data consisting of TRUE and FALSE values, and how to handle missing values and errors.

Logical operations

Logical operations are hard... NOT!

AND now for something completely different

Yea OR nay

Flow control

IF only

Lots of IFS

SWITCH it on!

Blanks, missing values, & errors

Blankety blank

Going missing

Errors and omissions

What's the problem?

Logic  & Errors

In which you learn about cell addresses, advanced matching, sorting and filtering, and simple imputation.

Cell addresses

Working with cell addresses

From addresses to values

Finding nearby cells with offsets

Local addresses

Lookups & matching

A VLOOKUP refresher

Sorted!


Matching values

Bringing it all together

Advanced filtering

Conditional summary statistics

Simple imputation

Congratulations!

Positional Matching

This course will expand your Google Sheets vocabulary. You'll dive deeper into data types, practice manipulating numeric and logical data, explore missing data and error types, and calculate some summary statistics. As you go, you'll explore datasets on 100m sprint world records, asteroid close encounters, benefit claims, and butterflies.

This course will expand your Google Sheets vocabulary. You'll dive deeper into data types, practice manipulating numeric and logical data, explore missing data and error types, and calculate some summary statistics.

<h2>Advanced Data Types and Manipulation</h2>
In the first part of the course, we focus on understanding and manipulating various data types in Google Sheets. You'll gain proficiency in handling numeric and logical data, crucial for effective data analysis. This section is designed to build your skills in data manipulation, teaching you techniques to manage and transform data efficiently. Whether you're dealing with large datasets or complex data structures, these skills are essential for making the most out of your data in Google Sheets.

<h2>Dealing with Missing Data and Errors</h2>
A common challenge in data analysis is dealing with missing data and error types. This course guides you through the intricacies of identifying and managing missing data, as well as understanding and resolving various error types that can occur in Google Sheets. You'll learn how to clean your data, ensuring its accuracy and reliability. This is a critical skill for anyone looking to conduct thorough and error-free data analysis.

<h2>Practical Application with Real Datasets</h2>
Throughout the course, you'll apply what you've learned using real-world datasets. These include records of 100m sprint world records, asteroid close encounters, benefit claims, and data on butterflies. By exploring these diverse datasets, you'll learn how to calculate summary statistics and gain insights from real data. This hands-on experience not only reinforces your learning but also prepares you to tackle a wide range of data analysis tasks with confidence.

Data Analysis in Google Sheets

Learn about Google Sheets by practicing manipulating numeric and logical data, exploring missing data and error types, and calculating summary statistics.

Intermediate Google Sheets

Expand your Google Sheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.

Google Sheets Fundamentals

Error	Cause
`#DIV/0!`	Dividing by zero.
`#VALUE!`	Nonsense data in a calculation.
`#REF!`	Referencing a cell that has been deleted.
`#NAME?`	Forgetting to quote a string.
`#NUM!`	Numbers being out of range.
`#N/A`	Missing value.
`#ERROR!`	Syntax problem in a formula.

What's the problem?

Intermediate Google Sheets

Hands-on interactive exercise