Google Sheets Functions for Growth Marketing & Product Teams

Name: Google Sheets Functions for Growth Marketing & Product Teams
Rating: 4.6 (240 reviews)

Covering the top 20 functions to import, clean & analyse data (Inc. Pivot Tables, IMPORTXML, VLOOPUP, INDEX & QUERY)

Highest Rated

Created byRuben Portz

Last updated 1/2021

English

English [Auto],

What you'll learn

Importing, cleaning and analysing datasets
Visualising data with pivot tables and time series graphs
Importing data using IMPORTRANGE, IMPORTHTML & IMPORTXML
Looking up data with VLOOKUP, INDEX & MATCH
Cleaning data with MONTH, YEAR, CONCATENATE, PROPER, REGEXEXTRACT, IF, THEN & ELSE
Sorting and filtering data with FILTER & SORT
Searching data with QUERY, SELECT, WHERE, LIKE, AND, OR & LIMIT

Course content

3 sections • 16 lectures • 1h 4m total length

Introduction1:47
Drive growth marketing and product team efficiency with practical Google Sheets training that covers data import, editing, concatenate and regular extractions, then querying, sorting, and visualizing datasets.

Linking data between workbooks, files and/or tabs using IMPORTRANGE4:24
Learn to link data across workbooks, sheets, or tabs using the import range function. Configure with the URL, sheet name, and range to enable live updates.
Importing data from the web with IMPORTDATA, IMPORTXML, IMPORTHTML8:12
Discover how to pull data from web pages into Google Sheets with importdata, importxml, and importhtml, including csv/tsv file reading, xpath-based extraction, and updating tables.
VLOOKUP cell values in a dataset5:01
Use vlookup (vertical lookup) with index and exact match to map plan IDs to interval and price, freeze ranges, and apply iferror for clean results.
Lookup cell values using INDEX and MATCH7:05
Master lookup in Google Sheets by combining INDEX and MATCH to pull values left-to-right and right-to-left, using MATCH's exact-match option (0) for precise results.
Converting dates with MONTH and YEAR4:27
Convert dates to month and year in Google Sheets using the month and year functions, enabling analysis by subscription creation month or year while addressing date formatting issues.
Combining dates in MONTH-YEAR using CONCATENATE2:27
Learn to use the concatenate function to merge date parts into a month-year label, group data by month and year, and compare date formatting options.
Conditional statements with IF, THEN, ELSE2:41
Apply Google Sheets conditional statements (if, then, else) to CRM updates for teams. Calculate active months for subscriptions by comparing creation and cancel dates, then round for lifetime value estimates.
Extracting firstnames from full names with REGEXEXTRACT2:25
Learn to extract first names from full names in Google Sheets using the regexextract function, capturing characters before the first space with a dot and asterisk pattern.
Capitalising names with PROPER1:05
Learn how to capitalize names in google sheets using the proper function, applying it to first names and full names for clean email lists and other name data.

Using SORT and FILTER to find missing values6:44
Learn to use sort and filter in Google Sheets to find missing values and filter by date or status, then create a dynamic, linked dataset in a separate tab.
Creating a dropdown list2:42
Create a dropdown list in Google Sheets using data validation to filter a dataset by a plan ID, enabling dynamic viewing of rows matching the selected plan.
Filtering data using the QUERY function and WHERE, LIKE AND OR LIMIT statements5:08
Explore filtering and sorting data in Google Sheets using the query function and Esquibel, a sql-like language, with where, like, limit, and group by to refine results and select columns.
Searching data using the QUERY function and dropdown list3:09
Create a dropdown with data validation and filter data using the query function in Google Sheets, so the dataset updates automatically as you change the selection.
Searching data using the QUERY function and text search input2:19
Combine the query function with a text search input to filter data in Google Sheets, using wildcards and regular expressions to match first names.
Visualising lifetime value and churn data using pivot tables4:53
Learn to visualize lifetime value and churn using pivot tables in Google Sheets, building a pivot tab with date ranges, rows, filters, and graphs for plan-level insights.

Requirements

Google account

Description

In the course you'll receive:

Practice dataset
Cheatsheet with 20+ functions
Short lectures explaining functions with examples

This course is designed to upskill your Google Sheets knowledge and is based on my experience leading growth teams and working day-to-day with Google Sheets. I've narrowed the course down to the top 20 most important functions that I use to import, clean, analyse and visualise data on a regular basis.

We will skip the basics of adding & subtracting and go right into the juicy stuff such as importing data with IMPORTXML and searching that data using QUERY. It will be no problem if these functions are completely new to you, as we'll cover all functions according to a practice dataset so that you can work alongside me and implement each function right away.

If you have any questions or requests, please don't hesitate to contact me.

Who this course is for:

Marketers with 0-5yrs of experience interested in data analysis using Google Sheets
Business owners wanting to clean and analyse customer data in Google Sheets
Growth and Product team members interested in upgrading their spreadsheets skills
Anyone who wants to get better at analysing data or creating spreadsheets can take away a lot too

Google Sheets Functions for Growth Marketing & Product Teams

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Data preparation & manipulation9 lectures • 38min

Data analysis & visualisation6 lectures • 25min

Requirements

Description

Who this course is for: