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.
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.
You'll need a Google account to use Google Sheets.
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.
I keep Fridays open for office hours with students - you can book 30 minutes anytime.
I'll refund your purchase within 30 days, no questions asked.