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.

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 tools are needed for this course?

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

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 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 if I buy the course and find out it's not for me?

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