Table of Contents
Google Sheets Bootcamp -The ultimate online training package for Google Sheets!
Enhance your Google Sheets skills with this three course bundle, covering the entire data workflow, from dealing with raw data through to creating beautiful reports.
Become a Google Sheets expert today
Are you drowning in data, but not using it to make better decisions?
Do you run a small business and want to use your data to inform your strategy?
Has your business migrated from Excel to Google Sheets, and you’re looking to further your skills?
Learn how to leverage the full power of Google Sheets to make data-driven decisions.
This bundle includes these three premium courses for $349:
- Data Cleaning in Google Sheets
- Data Analysis with Google Sheets
- Build Dashboards With Google Sheets and Data Studio
The retail price for these three courses is $497 ($99, $199 and $199 respectively), so this bundle represents outstanding value for your Google Sheets training needs.
Included in the Google Sheets Bootcamp course bundle:
✅ Three premium online courses
✅ Actionable, bite-size 5 – 10-minute video lessons teaching key topics
✅ Copies of all the raw datasets for you to follow along
✅ Copies of all the solution templates for your own use
✅ Access to the private course Facebook group for Q&A
✅ Certificate upon completion
Course 1: Data Cleaning in Google Sheets
- What is data cleaning and why is it important?
- Best practices for working with data in Google Sheets
- Formulas covering common scenarios when working with data in Google Sheets
- Tips and tricks, such as shortcut keys, to make your workflow more efficient
- Professional techniques for creating clean, orderly data sets for your analysis
- Two in-depth case studies that show all these techniques together, in the wider context of a real-world problem
Course 2: Data Analysis with Google Sheets
- Understand and describe what your data tells you
- Predict what things might look like in the future
- Understand your customers to better serve them
- Discover what factors affect your business
- Best practices for doing all of this…and much, much more!
- TOPICS INCLUDE: Data Analysis framework, measuring data, hypothesis testing, correlation, linear regression, time series analysis, customer lifetime value, churn, retention and cohort analysis
Course 3: Build Dashboards With Google Sheets
- Understand what dashboards are and why they’re so valuable
- Have the confidence to build your own dashboards with your own datasets, in Google Sheets
- Know what to include in your dashboards to maximize their impact
- Have the technical skills to manage advanced dashboard projects without feeling overwhelmed
- Create interactive dashboards, so colleagues and clients can view the data they want to see
- Understand and use best practices in Google Sheets, to avoid making the same mistakes I made
- Be confident using advanced formulas and pivot tables
- Use Apps Script to automate processes and make your dashboards work for you!
Who’s teaching the course?
Hi, I’m Ben Collins!
I’m an experienced data analytics instructor and freelance spreadsheet developer, helping businesses better understand their data through analytical insights and visualizations, including dashboards.
I work primarily with Google Sheets, Apps Script and Data Studio, and also have extensive experience with Excel, SQL and Tableau. I’ve previously taught data courses and workshops for General Assembly in Washington, D.C.
In early 2019, Google recognized me as a Google Developer Expert for G Suite Technology, one of only a small number worldwide.
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course – you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like – across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.
How much time does it take?
I’ve created a lot of content for you… over 15 hours of video content. Depending on your experience and comfort with formulas and advanced concepts, I’d estimate that it will take you 20 – 30 hours total time to get comfortable with the material. HOWEVER… I know you’re busy so each topic is divided into a series of 5-10 minute videos so you don’t have to plan days and days around studying this topic. I’d advocate doing the lessons in batches spread across a few weeks or months, to give yourself time to absorb the knowledge.
Will I get copies of the datasets and solutions?
Yes! All the raw data templates and the solution templates are provided, so you can download your own copies. The dataset file links and solution file links are available in the first lesson of each chapter. Clicking on the template links will make a copy on your Drive account.
How do I get access to the private course Facebook group?
When you enroll, you’ll receive the link in an email. It’s also available in the last lesson of the first module. Once you’ve joined, feel free to introduce yourself and let us know how you plan to use your newfound knowledge.
How do I get access to the private course Facebook group?
When you enroll, you’ll receive the link in an email. It’s also available in the last lesson of the first module. Once you’ve joined, feel free to introduce yourself and let us know how you plan to use your newfound knowledge.
What if I can’t figure out something on my own?
There’s a private Facebook group for students! As a member of this group, you can ask questions, share your ideas and knowledge, and connect with other students.
What if I don’t have a technical background?
Don’t worry, you’re not alone! This course focuses on practical techniques and teaches concepts through real-world examples, so that you won’t get lost in abstract theories and dense lectures. As long as you have a reasonable familiarity with Google Sheets (you’ve used VLOOKUPs before), and aren’t afraid to roll up your sleeves and put some effort in, then you’ll be able to grasp the content of this course. You’re free to watch the lessons in any order and as many times as you like, so you can watch and re-watch topics if you want!
How is this course different from other online courses?
This course is Google Sheets-focused and entirely practical. We start working in Google Sheets immediately and concepts are taught through practical examples.
How is this course different from other online courses?
This course is Google Sheets-focused and entirely practical. We start working in Google Sheets immediately and concepts are taught through practical examples.
Sales Page:
https://courses.benlcollins.com/p/google-sheets-bootcamp