Skip to content
Write a review
UdemyOffice ProductivityPaid courseIntermediate levelCertificate

Google Sheets Functions for Growth Marketing & Product Teams (Udemy.com)

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

4.6
240 reviews

Created by: Ruben Portz

Last updated January 2021

icon
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

How it compares

Against the other 459 rated Udemy courses in Office Productivity on CourseDuck:

  • Rating4.6 out of 5higher than 67% of them
  • Reviews240#310 of 460 by number of reviews
  • Length1.1 hoursshorter than 89% of them
  • Last updatedJanuary 2021earlier than 83% of them

icon
Course 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.
Read More Intermediate Intermediate Level product length iconTime: 1.1h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Ruben Portz

I'm the creator of TractionPad. An online platform where I share growth & marketing templates to help startups build repeatable sales systems.

Before that, I worked as the Head of Growth at Seneca Learning which is an online learning platform that I've helped grow to over 6 million users and expand internationally. I've also spent a year in Venture Capital supporting a portfolio of Seed & Series A startups. I'm also a guest lecturer at Imperial College London for the MEng in Design Engineering programme and work as an Entrepreneur in Residence during the yearly London School of Economics startup accelerator.

Read More

icon
More courses by Ruben Portz

$19.99

$34.99

All courses by Ruben Portz

icon
More Office Productivity courses

$19.99

$10.99

$39.99

$64.99

$12.99

$19.99

All Office Productivity courses

icon
Reviews

4.6

240 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Leow Hui Hui on 10/10/2023

good explanation. it would be great if there are more examples provided.

By Makhsadbek Juraev on 5/27/2023

Overall great course, but could be better if everything is explained with more examples.

By Shahzad Farooq on 5/6/2023

Just what i was looking for, and every tiny little detail is explained so well, i am impressed. Thank you very much and respect for the tutor.

By Sachin Naik on 11/6/2022

Course was a good match for what I was looking for. Learning by going through examples (including the occasional error :-)) is a useful approach. Some examples on data validations & arrays and advanced features such as macros, trends (e.g. cancellations), correlations (e.g. cohort retention rate) etc.

By Piyush Sharma on 8/12/2022

Basic concepts for google sheets. Learnt new things about queries and filters. Thanks for the course.

By Ely on 7/11/2022

I love how Ruben Portz teaches. The videos are bite-sized and it is not as dry as I'd imagined. I love that there are Errors in the equation and that he solves them while teaching. This is a great way for beginners like me to learn. Highly recommend checking this out!

By Nathan Moniz on 5/8/2022

Easy access to everything I need to try the new skills. I like how the course doesn't have much fluff. He gets right to the point with tangible examples that are going to be used in the real world

By Phạm Quân on 12/11/2021

The content is very helpful and interesting. Hope you will produce more courses like this one soon!

By Alejandro Conta on 10/12/2021

I really like that the video is not edited when the facilitator gets errors or makes mistakes, makes everything more real and gives a valuable insight. The names of the each unit sometimes don't match exactly what is shown.

By Carolina Nassif Rodrigues Hira on 4/23/2021

A lot of detailed information well explained with exemples.

Showing all 10 reviews on CourseDuck

Read all 240 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

Google Sheets Functions for Growth Marketing & Product Teams
Visit course on Udemy Write a review
  • Video Duration: icon 1.1h
  • Price: $19.99
  • Provider: icon Udemy
  • Updated: icon January 2021
  • Level: Intermediate Intermediate
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com