Why Google Sheets?
Learn how you'll use Google Sheets to cut the time you spend working with data.
Data Analysis the Lazy Way
Using Google Sheets and apps like Zapier to save hours at work
Already enrolled?
Sign in to continue learning.
Sign in to continue learning.
Table of contents
The Course Project
The Course Project
Draft
Why Google Sheets?
Draft
The Cupcake Data Analysis
Draft
Asking Good Questions: the Course Project
The Lazy Toolbelt
The Lazy Toolbelt
Draft
Intro to the Lazy Toolbelt
Draft
Why the Lazy Toolbelt?
Draft
WTF is Blockspring?
Draft
WTF is Supermetrics?
Draft
WTF is Zapier?
10 Sheets Formulas to Know
10 Sheets Formulas to Know
Draft
Intro to Data Wrangling
Draft
The 3 Types of Formulas
Draft
Learn the 10 Formulas
Answering Basic Questions
Answering Basic Questions
Draft
Intro: Baking your First Cupcake
Draft
Copy the Example Sheet
Draft
Question 1: Top Questions
Draft
Question 2: Top Tweeters
Draft
Question 3: Top Day of the Week
Draft
Quiz 1: Basic Querying
Answering Advanced Questions
Answering Advanced Questions
Draft
Intro: Diving Deeper
Draft
Question 4: Top Hour of the Day
Draft
Question 5: Top Hashtags
Draft
Question 6: Top Domains
Draft
Quiz 2: Advanced Querying
Visualizing your Answers in Data Studio
Visualizing your Answers in Data Studio
Draft
Intro to Data Visualization
Draft
Getting Started with Data Studio
Draft
Connecting your Sheet to Data Studio
Draft
Building a Simple Table
Draft
Calculating Metrics in Data Studio
Draft
Building Time Series Charts
Draft
Styling Charts and Reports
Draft
Quiz 3: Building your own Dashboard
The Lazy Way in Action
The Lazy Way in Action
Draft
Cupcake Data Analysis and You
Draft
Start your own Cupcake Data Analysis
Draft
Access the CIFL Template Vault
Draft
Case Study: The Growth Engine with Kev Kaye
Draft
Case Study: SEO Audit with Ryan Stewart