The Google Sheets Query Function by Coding is for Losers
Buy for $49

The Google Sheets Query Function

A weapon of mass laziness
Buy for $49

Overview

The Query function is the shortcut to mastering Google Sheets.

Instead of mixing up a bunch of spreadsheet formulas to get something done, you can get away with writing one Query.

If you're working with data in any capacity - even if it's just to produce a monthly report - you'll want to know how to run Queries.

This course teaches Querying interactively, by working through a sample analysis of Twitter data in Google Sheets.

What's included?

Video Icon 9 videos File Icon 4 files Text Icon 3 text files

Contents

Getting Started with Sheets Queries
Browse the Sample Dataset
2 mins
Get access
Writing your first Sheets Query
Preview
Date Comparisons in Queries: Why so Complex?
Preview
Query multiple Google Sheets: IMPORTRANGE + {} = FRIENDS
Get access
Writing Basic Queries
Intro: Doing Math in Queries
1 min
Get access
Question 1: Pulling the Top Questions
3 mins
Preview
Question 2: Who are the Top Tweeters?
5 mins
Get access
Question 3: What's the Most Active Day of the Week?
6 mins
Get access
Quiz 1: Basic Querying
Get access
Writing Advanced Queries
Intro: Diving Deeper
1 min
Preview
Question 4: What's the Top Hour of the Day?
5 mins
Get access
Question 5: What are the Most-Used Hashtags?
8 mins
Get access
Question 6: Whata Domains are Most-Tweeted?
6 mins
Get access
Quiz 2: Advanced Querying
Get access
Bonus Section: Learn SQL too
Transitioning from Query Functions to SQL
Preview
Learn SQL in a Spreadsheet
Get access

Making Spreadsheets Great Again

Helping you wrangle your data + automate your work, without (hardly ever) leaving Google Sheets. 

FAQ

Is there a quiz?

There are two quizzes - one on basic querying, and once more advanced querying. You’ll be asked to write Queries to answer questions like ‘What’s the best day of the week to Tweet?’ by combining Query with other formulas (Arrayformula, Weekday, and Importrange, for example). Both quizzes are modeled off of example questions covered in videos, so even if you’re stuck you’ll be able to reference a previous tutorial.

What tools are needed for this course?

You'll need a Google account to use Google Sheets.

What if I need help as I work through the course?

I keep Fridays open for office hours with students - you can book 30 minutes anytime.

What will I be able to do at the end of this course?

Write advanced Queries in Sheets, to do any type of data analysis. Query replaces the need to build pivot tables, calculate metrics using long strings of formulas, or write long strings of formulas to transform data into the right format.

What if I buy the course and find out it's not for me?

I'll refund your purchase within 30 days, no questions asked.

Who is this course for?

If you use Google Sheets in your work, you’ll want to learn the Query function. The sample analysis in this course (of Twitter data) is aimed at marketers, startups, and agencies - but Sheets lovers outside of those fields can benefit from the course just the same.