Learn how to bend Google Sheets to your will, and take control of your data
This comprehensive, two-course bundle will teach you all the key techniques for working with data in Google Sheets, including a deep dive into Pivot Tables, and how to build beautiful, interactive dashboards in Google Sheets and Google's new dashboard tool, Data Studio.
We'll also learn how to use Apps Script (Google flavored Javascript) to automate our dashboard reporting.
"Everyone talks about data culture in companies, but only a few know how to do it. Good dashboards are a great first step to democratize access to data in a simple way, and this course will definitely change the way you see your data today."
- Gabriel O.
"This course is a fantastic way to discover how to build dashboards. Ben takes you step by step through what you need to do and his approach is well thought out and organised. The information covers the basics and introduces more complex subjects in a simple and easy to follow format."
- Marilyn C.
I’ve been making “Pivot Tables” wrong for years, entering all of the raw data myself. I am now able to make a Pivot Table that will update as needed. I like how Ben shows multiple ways to do data cleaning and why you would choose one method over the other. I enjoyed the case studies at the end because they brought the entire course together.
I will definitely be on the lookout for additional courses from Ben."
- Rachelle L.
What's included?
This comprehensive course bundle will teach all the key techniques for working with data, including pivot tables, and how to build beautiful, interactive dashboards in Google Sheets and Google's new dashboard tool, Data Studio.
You'll be able to take messy, raw datasets and confidently turn them into insightful reports, so you can make key data-based decisions that were previously out of reach.
The core curriculum of both courses is built around practical examples and all the datasets and templates are included.
I'll be with you every step of the way, showing you the sheet setup, the formulas and the charts we use. For each example you'll have all the necessary raw data and formulas, as well as a final, finished template!
This bundle includes the following two courses:
- Data Cleaning and Pivot Tables in Google Sheets
- Build Dashboards with Google Sheets and Data Studio
The normal retail price of this bundle is $249 (or $99 and $199 bought individually!), so this bundle offer represents outstanding value at just $199.
Course 1: Data Cleaning and Pivot Tables in Google Sheets
There's a joke in the data community that goes:
"You'll spend 90% of your time cleaning data, and the other 10% of your time complaining about cleaning your data."
Do you deal with badly formatted data that takes you hours to tidy up, preventing you from making progress on your "real" work?
Do you ever find yourself repeating a process manually, like extracting a zip code from an address?
Ever wondered what the heck a Pivot Table is, and why you should care about them?
This course is designed to help you work with messy, real-world datasets, and it's a fit for beginner-to-intermediate level Google Sheets users.
Through four hours of video tutorials, you'll learn techniques and best practices for cleaning data and preparing it for analysis and reporting -- saving you hours of tedious, repetitive work, and helping you get accurate results for your company.
Course 2: Build Dashboards with Google Sheets and Data Studio
Do you spend hours collecting data, wrestling it into the format you need and then updating the same report that no one ever reads?
Or maybe you're neck deep in data but don't know how to use it to make sound business and marketing decisions?
Dashboards are fantastic tools that give you a high-level view of your business, showing KPIs, trends and data comparisons... so you can use that insight to grow your company in smart ways.
By learning some relatively simple techniques, you can create dashboards that are automated, interactive and visually appealing. They'll get people's attention and wow your colleagues and bosses.
This course covers everything you need to know about building beautiful business dashboards with Google Sheets and Google Data Studio.
What you get with this course:
- Over 100 video tutorials that walk you step-by-step through all the techniques.
- Access to all the raw data files, copies of the formulas and links to online documentation and other great resources.
- Copies of any finished dashboard templates for the five dashboard examples and the one Data Studio report. You'll be able to make your own copies for editing and reverse engineering as many times as you like.
- Membership to our dedicated Facebook group, where you can post questions and get answers, share insights and interact with other students.
- All the videos are online and you'll have 24/7 access for life.
Who is this course for?
- Anyone who works with data in Google Sheets.
- Someone who is curious to learn more about Google Sheets and dashboards.
- Maybe you're a data analyst, a technical marketer, an educator, a scientist or anything in between.
- Anyone who wants to add new skills, that will help you advance your career.
What are the prerequisites?
- A Google account.
- Access to Google Sheets.
- Basic familiarity with Google Sheets and spreadsheets, although the early parts of each course are set up so that everyone should be able to follow along.
- Access to Google Data Studio (for the last section of the dashboard course).
Still have questions?
Find me at https://www.benlcollins.com/contact/
Or drop me a line at ben [at] benlcollins.com
"I’d recommend this course for anyone trying to make great dashboards in Google Sheets. Ben is a great teacher and he explains everything very thoroughly. Five stars from me."
- Jakob R.
"I am an academic librarian who has worked for years with massive raw data sets and pivot tables, and even gives related presentations at our regional conferences, and yet I learned from Ben's course several very useful tips and techniques that I didn't already know about and that will save me a lot of work.
I plan to recommend it to my colleagues as a very thorough course in getting data ready for the kind of data visualization contexts we need to provide to our decision-makers and stakeholders."
- Melissa B.
"The course starts with a data cleaning section which is highly actionable and relevant to real world data sets that we all work with. My pivot table knowledge was pretty basic before this course and I am confident to say that I am now going to be able to implement them into my data analysis workflow.
This course also took my efficiency to the next level which is exactly what I needed as more of my time and analysis is starting to take place in sheets. I can't recommend this enough."
- John R.