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

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

Linking data between workbooks, files and/or tabs using IMPORTRANGE4:24
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
Lookup cell values using INDEX and MATCH7:05
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
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
Capitalising names with PROPER1:05

Using SORT and FILTER to find missing values6:44
Creating a dropdown list2:42
Filtering data using the QUERY function and WHERE, LIKE AND OR LIMIT statements5:08
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
Visualising lifetime value and churn data using pivot tables4:53

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: