Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Analysis with Google Sheets
Introduction
Introduction To The Data Analysis With Google Sheets Course (2:55)
Join The Course Community
Templates
November 2021 Update: Google Sheets Menu Updates
Fundamentals
Fundamentals Templates
What Is Data Analysis? (5:11)
Google Sheets Best Practices (12:24)
Formula Syntax For European Users
The Onion Method (4:46)
How To Solve Problems: Resources Available (4:33)
Pivot Tables, The Query Function And Array Formulas
Pivot Tables and Query Function Templates
Using Pivot Tables To Analyze Data (10:16)
Tall Vs. Wide Data (8:34)
Advanced Pivot Table Options (12:46)
Pivot Table Case Study Part I (11:21)
Pivot Table Case Study Part II (4:55)
Slicers (9:10)
Query Function (7:05)
Query Function Pivot (8:50)
Query Function Dates (10:38)
Curly Bracket Arrays (9:57)
Array Formulas (6:37)
Data Cleaning
Data Cleaning Templates
Data Types (7:59)
Extracting Data With Left, Right And Mid Functions (11:24)
Changing Data With Substitute And Replace Functions (8:53)
Splitting Data With Text To Columns (9:17)
Dealing With Null Values (9:07)
Duplicates (12:27)
Describing Your Data
Describing Your Data Templates
Basic Measures (4:42)
Averages (4:17)
Outliers (5:52)
Deviation And Variance (5:50)
Normal Distribution And Histograms (12:01)
Aggregating Data With Pivot Tables And The Query Function (5:05)
Ranking Data (6:15)
Comparing Datasets (7:03)
Describing Your Data Summary (4:45)
Discovering Relationships In Your Data
Discovering Relationships In Your Data Templates
Correlation And Scatter Plots (8:16)
Correlation Examples (7:50)
Correlation Vs. Causation (5:21)
Anscombe's Quartet (5:35)
Discovering Relationships In Your Data Summary (4:47)
Making Predictions With Regression Analysis
Making Predictions With Regression Analysis Templates
Introduction To Regression Analysis (8:22)
Segment Your Data (11:41)
Residual Plots And Assumptions (10:12)
Introduction To Multiple Linear Regression (8:35)
Time Series Analysis
Time Series Analysis Templates
Introduction To Time Series Analysis (9:34)
Weighted Moving Average Forecasts (4:37)
Exponential Smoothing Forecasts (5:13)
Analyzing Forecast Accuracy (13:12)
Growth And Trend Functions (7:48)
Time Series Analysis Summary (2:37)
Customer Analysis
Customer Analysis Templates
Introduction To Customer Analysis (16:33)
Customer Lifetime Value (4:21)
Cohort Analysis (13:13)
Customer Churn And Retention I (9:43)
Customer Churn And Retention II (9:10)
Customer Retention Curves (6:31)
Understanding Customers Summary (5:50)
Charts
Charts Templates
Combo Charts (13:02)
Dynamic Charts (12:53)
Finance Chart Case Study I (12:57)
Finance Chart Case Study II (20:43)
Next Steps
Resources & Refer A Friend...
Aggregating Data With Pivot Tables And The Query Function
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock