Data Analysis in Google Sheets
| Course Details | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Languages | ||||||||
|
||||||||
| Outcomes | ||||||||
|
||||||||
| Price & Terms | ||||||||
|
||||||||
| Technical | ||||||||
|
||||||||
| Specification | ||||||||
|
||||||||
Clean text and date fields, summarize and filter tables, and combine data with conditional functions and VLOOKUP in Google Sheets.
Google Sheets has built-in functions for most of the work between a raw table and an answer. You summarize columns with statistics, sort and filter rows, clean text and date-time fields, and then use conditional logic, conditional aggregation and VLOOKUP to combine tables, practiced on records about moons, films, employee expenses and manufacturing costs.
What You Will Achieve
- Get a quick statistical read on a dataset and reorder or narrow its rows to the ones you need
- Pull years, months and weekdays out of dates and measure the time between two events
- Standardize messy text fields by fixing capitalization, joining values and swapping out characters
- Total spending and report counts per employee with conditional formulas, and pull matching records out of a second table
Program Overview
Exploring Data with Built-in Functions
Opens with how spreadsheet functions keep formulas readable and give a first statistical picture of a dataset, practiced on data about Jupiter’s moons.
- Built-in functions and rounding values
- Summary statistics and measures of center
- Counting cells
- Sorting and filtering
Cleaning Text and DateTime Data
Tackles date-time and text fields, two data types that are hard to clean, using a dataset of the highest-grossing films.
- Date and time component extraction
- Date intervals between observations
- Case changes and combining text
- Character counts, extraction and substitution
Analyzing Data with Conditional Logic and VLOOKUP
Applies conditional functions and lookups to product costs, employee performance and expense reports.
- Conditional functions and logical expressions
- Conditional aggregation by person and type
- VLOOKUP with sorted and unsorted lookups
Certificate Awarded (Paid)
Complete the course to earn it.
Job Outlook
Spreadsheet skills like these are used in data analysis roles and in everyday reporting work for marketing, finance, HR and logistics teams.
Good for: People in marketing, finance, HR or logistics who keep records in Google Sheets and want dependable functions to tidy and summarize them.
Keep in mind: Every exercise is built on formulas and built-in functions, and lookups are taught through VLOOKUP in its sorted and unsorted forms.
Bottom line: A formula-centered course that gives date and text cleanup a full chapter before moving on to conditional totals and VLOOKUP.
Frequently Asked Questions
What records are the formulas practiced on?
Practice draws on several sets of records: figures on the moons of the Solar System, including Jupiter's, a table of the highest-grossing films, and business data on employee expenses, manufacturing and product costs, employee performance and educational programs.
What kinds of date calculations are taught?
The lessons show how to pull the year, month and weekday out of a date-time value, how to work out how long it has been since a date, and how to find the intervals between observations in a dataset.
How is VLOOKUP taught in the course?
VLOOKUP closes the final chapter, after conditional functions and conditional aggregations. It is used to combine data held in different tables, with separate lessons on unsorted lookups and sorted lookups.
What text cleanup functions are included?
Text lessons cover changing the case of entries, combining text values, counting the characters in a value, extracting part of a string and substituting characters, all practiced on the dataset of highest-grossing films.
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.