Intermediate Google Sheets
| Course Details | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Languages | ||||||||
|
||||||||
| Outcomes | ||||||||
|
||||||||
| Price & Terms | ||||||||
|
||||||||
| Technical | ||||||||
|
||||||||
| Specification | ||||||||
|
||||||||
Learn to check and convert data types, transform and round numbers, handle errors and missing values, and match values by position in Google Sheets.
Missing data, error types and badly typed values are common challenges when analyzing data in Google Sheets. The lessons expand your Google Sheets vocabulary: you test what data type a cell holds and convert it, transform and round numbers, work with TRUE and FALSE logic, and find values by their position in a sheet before summarizing them.
What You Will Achieve
- Check the data type of a cell’s contents, find badly typed data and convert values between types
- Transform a numeric column with a logarithm or square root and round the results to the precision you need
- Write conditional formulas with IF, IFS and SWITCH, and handle blanks, missing values and errors
- Pull a value by its position, fill missing entries and calculate statistics for only the rows that meet a condition
Program Overview
Data Types in Cells
Checks what kind of value each cell contains and turns values into the type a formula expects.
- IS functions for common and rarer data types
- Finding missing and badly typed data
- Type conversion and the CONVERT() function
- Turning logical values into numbers
Number Transformations and Logic
Reshapes numeric data with standard transformations and rounding, then moves to TRUE and FALSE logic and the handling of blanks and errors.
- Log, exponential and square root transformations
- Rounding and random number generation
- NOT, AND, OR and flow control functions
- Blanks, missing values and error types
Positional Matching, Filtering and Imputation
Uses cell addresses to locate and match values, then sorts, filters and summarizes data and fills gaps.
- Cell addresses and offsets to nearby cells
- VLOOKUP and matching values
- Sorting and advanced filtering
- Conditional summary statistics and simple imputation
Certificate Awarded (Paid)
Job Outlook
These spreadsheet skills apply wherever data lives in Google Sheets, including data preparation, routine reporting and business intelligence work that depends on clean, correctly typed values.
Good for: Google Sheets users who want more functions for checking data types, handling missing data and errors, and matching values by position.
Keep in mind: Despite the intermediate title it is rated Beginner, and the analysis goes as far as conditional summary statistics and simple imputation.
Bottom line: A focused set of formula techniques for checking, converting and looking up sheet data, practiced on four real datasets.
Frequently Asked Questions
Which datasets are used in the exercises?
The exercises draw on four real datasets: 100-meter sprint world records, asteroid close encounters, benefit claims records, and data on butterflies. Each one gives the functions a realistic context to work in.
How does the lookup chapter work with cell positions?
It starts with cell addresses, turning an address into the value it points to and using offsets to reach nearby cells. A VLOOKUP refresher follows, then lessons on matching values, sorting and advanced filtering.
What does simple imputation mean here?
Imputation means replacing missing values with stand-in values. It closes the final chapter, after earlier lessons show how to find blanks and missing data, so the course ends by filling those gaps with simple methods.
What kinds of random numbers can you generate?
The numbers chapter covers generating uniform random numbers and random numbers that follow other distributions. It sits alongside lessons on rounding, including rounding negative numbers, and on log, exponential and square root transformations.
User Reviews
Write your review
You must be logged in to post a review.
Reviews can only be posted by registered learners. Log in or create a free account, then you will return here to post.
There are no reviews yet.