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