Intermediate Spreadsheets
|
Expand your spreadsheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.
Course Description
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.
What You’ll Learn
What’s in a cell?
In which you learn to interrogate cells to determine the data type of their contents, and to convert between data types.
Logic & Errors
In which you learn how to work with logical data consisting of TRUE and FALSE values, and how to handle missing values and errors.
Working with numbers
In which you learn to apply log and square root transformations to numbers, round them up and down, and generate random numbers.
Positional Matching
In which you learn about cell addresses, advanced matching, sorting and filtering, and simple imputation.
User Reviews
Be the first to review “Intermediate Spreadsheets”
You must be logged in to post a review.
There are no reviews yet.