Google Sheets Functions for Growth Marketing & Product Teams – Free Udemy Courses
Covering the top 20 functions to import, clean & analyze data (Inc. Pivot Tables, IMPORT XML, VLOOPUP, INDEX & QUERY)
What you’ll learn
Google Sheets Functions for Growth Marketing & Product Teams – Free Udemy Courses
- Importing, cleaning, and analyzing datasets
- Visualizing data with pivot tables and time series graphs
- Importing data using IMPORT RANGE, IMPORTHTML & IMPORT XML
- 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
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, analyze and visualize data regularly.
We will skip the basics of adding & subtracting and go right into the juicy stuff such as importing data with IMPORT XML 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 analyze customer data in Google Sheets
- Growth and Product team members interested in upgrading their spreadsheets skills
- Anyone who wants to get better at analyzing data or creating spreadsheets can take away a lot too
Add Comment