Enhance your Google Sheets skills with this course bundle, covering the entire data workflow, from dealing with raw data through to creating beautiful reports.
This bundle includes:
The retail price for these two courses is $238 ($89 and $149 respectively), so this bundle represents outstanding value for your Google Sheets training needs.
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.
This comprehensive course will teach all the key techniques for turning data cleaning, pivot tables and building beautiful, interactive dashboards in Google Sheet 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 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!
Ben Collins is an experienced data analytics instructor and freelance spreadsheet developer, helping businesses better understand their data through analytical insights and visualizations, including dashboards. He works primarily with Google Sheets, Apps Script and Data Studio, and also has extensive experience with Excel, SQL and Tableau. He previously taught data courses and workshops for General Assembly in Washington, D.C.
What you get with this course:
"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’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.
"Before this course I had used a few simple formulas (okay Average and Sum only) but now I know how to use a vlookup as well as create Pivot Tables.
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.
"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.
"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.