Intermediate Google Sheets
Offered By: DataCamp
Course Description
Overview
Expand your Google Sheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.
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. As you go, you'll explore datasets on 100m sprint world records, asteroid close encounters, benefit claims, and butterflies.
Syllabus
- 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.
- 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.
- 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.
- Positional Matching
- In which you learn about cell addresses, advanced matching, sorting and filtering, and simple imputation.
Taught by
Richie Cotton
Related Courses
ETL and ELT BasicsA Cloud Guru Programming Use Cases with Python
A Cloud Guru Microsoft Power BI: Advanced Data Analysis and Visualisation
Cloudswyft via FutureLearn Amazon Connect Data Streaming Intermediate
Amazon Web Services via AWS Skill Builder Analisar e preparar dados com o Amazon SageMaker Data Wrangler e o Amazon EMR (Português (Brasil)) | Lab - Analyze and Prepare Data with Amazon SageMaker Data Wrangler and Amazon EMR (Portuguese (Brazil))
Amazon Web Services via AWS Skill Builder