Google Sheets Functions for Growth Marketing & Product Teams
Covering the top 20 functions to import, clean & analyse data (Inc. Pivot Tables, IMPORTXML, VLOOPUP, INDEX & QUERY)
Ratings 4.64 / 5.00
What You Will 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
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 Should Attend!
- 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
