Ben Collins – Google Sheet Bootcamp
Premium
-
Learn online (no require download), easy download (Google Drive) -
Ensure to get all files in the file list. -
Get free update course through your email. -
If you find a website cheaper than us, send it to us and we'll offer a cheaper price.
$999
- 96%
We offer great deals when you buy multiple courses, which is the price when you buy multiple courses
Discount will have an end date, hurry and buy it before it disappears, the cheap prices and offers, you will have a lot of courses and knowledge.
| Number of Courses | Discount |
|---|---|
| 2 | 10% |
| 3 | 25% |
| 5 | 30% |
| 10 | 35% |
| 20 | 40% |
Ben Collins – Google Sheet Bootcamp
Ben Collins – Google Sheet Bootcamp Cheap
Ben Collins – Google Sheet Bootcamp Download
Ben Collins – Google Sheet Bootcamp Course
1. Data Cleaning and Pivot Tables in Google Sheets
- Lesson 1 Introduction To The Course The Collins School Of Data
- Lesson 2 About The Instructor The Collins School Of Data
- Lesson 3 How This Course Is Structured The Collins School Of Data
- Lesson 4 Introduction To Data Cleaning And Best Practices Th
- Lesson 5 Data Types The Collins School Of Data
- Lesson 6 Handy Shortcuts For Data Tables The Collins School
- Lesson 7 Find And Replace The Collins School Of Data
- Lesson 8 Trim, Clean and Dealing with Spaces The Collins
- Lesson 9 Lower, Upper And Proper Functions To Deal With Case
- Lesson 10 Searching within data strings The Collins School
- Lesson 11 Extracting Data With Left, Right And Mid Functions
- Lesson 12 Changing Data With Substitute And Replace Formulas
- Lesson 13 Splitting Data with Text to Columns The Collins
- Lesson 14 Bringing Data Together The Collins School Of Data
- Lesson 15 Sorting And Filtering Data The Collins School Of D
- Lesson 16 Dealing With Null Values The Collins School Of Dat
- Lesson 17 Duplicates The Collins School Of Data
- Lesson 18 Duplicates Formula Method The Collins School of Data
- Lesson 19 Using the IF function and logic to clean data
- Lesson 20 Using VLOOKUP to clean data The Collins School
- Lesson 21 Spelling Tools and Transposing Data The Collins School
- Lesson 22 Introduction to Pivot Tables The Collins School
- Lesson 23 Pivot Table Fundamentals The Collins School of Data
- Lesson 24 Pivot Table Fundamentals II The Collins School
- Lesson 25 Preparing Data For Pivot Tables The Collins School
- Lesson 26 Advanced Pivot Table Features (Filters, Dates And
- Lesson 27 Advanced Pivot Tables Features Part II (Column Hea
- Lesson 27 Show As Percentage The Collins School Of Data
- Lesson 28 Formatting Pivot Tables The Collins School Of Data
- Lesson 28 Pivot Table Options The Collins School Of Data
- Lesson 29 Other Uses For Pivot Tables The Collins School
- Lesson 30 Getting data out of Pivot Tables the right way
- Lesson 31 Case Study 1 Part I The Collins School Of Data
- Lesson 32 Case Study 1 Part II The Collins School Of Data
- Lesson 33 Case Study 2 Part I The Collins School Of Data
- Lesson 35 Case Study 2 Part III The Collins School Of Data
- Files in module
2. Ben Collins - Data Analysis with Google Sheets
- 1. Introduction
- 2. Basic Measures
- 2. Correlation And Scatter Plots
- 2. Introduction
- 2. Introduction To Customer Analysis
- 2. Introduction To Regression
- 2. What Is Data Analysis
- 3. Averages
- 3. Calculating Customer Lifetime Value Part I
- 3. Correlation Examples
- 3. Hypothesis Testing Using Twotail Ztest Salary Example
- 3. Segment Your Data To Find The Trends
- 3. Weighted Moving Average Forecasts
- 4. Calculating Customer Lifetime Value By Cohort Part II
- 4. Correlation Does Not Imply Causation
- 4. Exponential Smoothing Forecasts
- 4. Residual Plots And Assumptions
- 5. Analyzing Forecast Accuracy
- 5. Anscombes Quartet And The Importance Of Looking At The Whole Picture
- 5. Customer Churn And Retention Part I
- 5. Deviation And Variance
- 5. Hypothesis Testing Using Twotail Ttest
- 5. Hypothesis Tests On Regression Models
- 6. Customer Churn And Retention Part II
- 6. Google Sheets Best Practices
- 6. Growth And Trend Functions
- 6. Histograms And Normal Distribution
- 6. Hypothesis Testing Using Onetail Ttest
- 6. Introduction To Multiple Linear Regression
- 6. Summary
- 7. Customer Retention Curves
- 7. Exploring Data With Pivot Tables And The Query Function
- 7. Multiple Regression Hypothesis Testing
- 7. Summary
- 7. Testing Variance Using Chisquare Test
- 8. Hypothesis Testing Using Two Sample Testing
- 8. Identifying Insignificant Model Coefficients
- 8. Ranking Data
- 8. Understanding Customers Summary
- 9. Comparing Datasets
- 9. Summary
- 10. Summary
- Files in module
3. Build Dashboards With Google Sheets and Data Studio
- Lesson 1 Introduction The Collins School Of Data
- Lesson 2 About The Author The Collins School Of Data
- Lesson 3 How Is This Course Structured The Collins School
- Lesson 4 Why Use Google Sheets To Build Your Dashboards The
- Lesson 5 What Is A Dashboard The Collins School Of Data
- Lesson 6 Introduction To The Static Sales Dashboard The Coll
- Lesson 7 The Raw Data The Collins School Of Data
- Lesson 8 Setting Up The Summary Data Table The Collins School
- Lesson 9 Introduction To Pivot Tables The Collins School
- Lesson 10 Creating The Revenue Chart The Collins School
- Lesson 11 Using Pivot Tables To Breakdown Sales By Channel T
- Lesson 12 Creating The Sales Channel Chart The Collins Schoo
- Lesson 13 More Pivot Table Practice! The Collins School Of D
- Lesson 14 Creating A Geographic Chart To Show Sales By US St
- Lesson 15 Advanced Features Of Pivot Tables To Find The Top
- Lesson 16 Building Our Sales Dashboard Part 1 The Collins Sc
- Lesson 17 Building Our Sales Dashboard Part 2 The Collins
- Lesson 18 Building Our Sales Dashboard Part 3 The Collins
- Lesson 19 Building Our Sales Dashboard Part 4 The Collins
- Lesson 20 Sharing Your Dashboard The Collins School Of Data
- Lesson 21 Interactive Dashboard Introduction The Collins School
- Lesson 22 The Raw Data For The Interactive Dashboard
- Lesson 23 Named Ranges In Google Sheets (Alternative Method
- Lesson 24 Interactive Dashboard Data Validation The Collins
- Lesson 25 Interactive Dashboard Staging Tables 1 The Collins
- Lesson 26 Interactive Dashboard Staging Tables 2 The Collins
- Lesson 27 Dynamic Charts The Collins School Of Data
- Lesson 28 Interactive Dashboard Build 1 The Collins School
- Lesson 29 Interactive Dashboard Build 2 The Collins School
- Lesson 30 Dynamic Sales Dashboard Introduction The Collins S
- Lesson 31 Interactive Sales Data Validation The Collins School
- Lesson 32 Dynamic Key Performance Indicators The Collins School
- Lesson 33 Dynamic Revenue Table And Chart The Collins School
- Lesson 34 Dynamic Sales Channel Chart The Collins School
- Lesson 35 Dynamic Sales Geographic Chart The Collins School
- Lesson 36 Dynamic Top 10 Table The Collins School Of Data
- Lesson 37 Interactive Sales Dashboard Final Build The Collin
- Lesson 38 Real Estate Dashboard Introduction The Collins School
- Lesson 39 Real Estate Dashboard Raw Data The Collins School
- Lesson 40 Using Google Forms To Collect Data The Collins School
- Lesson 41 Real Estate Sales Funnel Chart The Collins School
- Lesson 42 Agent Performance Stacked Bar Chart The Collins
- Lesson 43 Real Estate Financial Charts The Collins School
- Lesson 44 Real Estate Detailed Agent Breakdown Charts
- Lesson 45 Real Estate Dashboard Build 1 The Collins School
- Lesson 46 Real Estate Dashboard Build 2 The Collins School
- Lesson 47 Digital Marketing Dashboard Introduction The Colli
- Lesson 48 Creating A Dashboard Settings Tab The Collins School
- Lesson 49 Introducing The Google Analytics Add-On The Collin
- Lesson 50 Advanced Use Of The Google Analytics Add-On
- Lesson 51 Data Staging Part 1 The Collins
- Lesson 53 Dashboard Panels And Sparklines
- Lesson 54 Adding Charts To Our Digital Marketing Dashboard
- Lesson 55 Alternative Sparkline Chart The Collins
- Lesson 56 Advanced Formulas To Add Context
- Lesson 57 Add Comparison Formulas For Analysis
- Lesson 58 Format The Digital Marketing Dashboard To Make It
- Lesson 59 Fire Emoji Bonus! The Collins
- Lesson 60 Introduction To The Social Media
- Lesson 61 Import Formulas To Scrape Social Media
- Lesson 62 Import Formulas To Scrape Alexa
- Lesson 63 Introduction To The Apps Script Language
- Lesson 70 Set Up Triggers To Run Our Dashboard Automatically
- Lesson 71 Introduction To Google Data Studio The Collins
- Lesson 72 The Basics Of Data Studio The Collins
- Lesson 73 Control Data Using Filters In Data Studio The Coll
- Lesson 74 Data Sources And Calculated Fields In Data Studio
- Lesson 75 Mobile Reporting Dashboard Example In Data Studio
- Update Google Sheets Chart Tool Update The Collins School Of Data
- Files in module
Instructor
Free
Newest Courses
Useful Info
Click Download button, fill your information, and pay through Paypal payment, we will send course information in your email.
After payment, the system will automatically send course access information to your email, if you write the wrong email, please contact: [email protected]
Please contact email: tscourses.com
Or you can use Live Chat in website to get fast support
