Welcome to the complete, free dashboards course for Google Sheets!
Below you will find a variety of dashboard lessons that you can follow along with me to level up your Google Sheets skills in a hands on way that clicks. Sharpen your skills, automate your business, impress your employer.
I hope you enjoy.
About me
My name is Corey, I have been automating and building dashboards with Google Sheets for over 10 years.
If you want, you can read more about me and the advantages of taking this course, but this page is where you will actually start learning these incredibly valuable dashboard building skills.
Want to have a custom spreadsheet built for your business? Click the button below to learn how I can bring your project to life and save your business time.
Beginner tutorial:
If you want to learn basic Google Sheets skills before taking this course, try the beginner tutorial first.
With each dashboard you will get a copy of the raw CSV data that you can use to build the dashboard while you follow along with the video.
You can also view a copy of the completed dashboard to refer to as you follow along and enter formulas etc.
Each dashboard tutorial will teach you unique concepts not found in the other tutorials.
Click here to see an overview of how to build a dashboard in 3 major steps, as well as to see an overview of building the basic sales dashboard.
Or get started with your first dashboard below.
A note on date formats in varying countries
If you are located in Europe or outside of the U.S., your date format will be different than the United States, and this may affect the creation of some of the dashboards. You can change the date format by clicking File > Settings > General > Locale > United States
Basic Sales Dashboard (+ Dashboard creation concepts / methods)
Start building the basic sales dashboard
OR build the Quick version of the sales dashboard
This dashboard is the easiest to complete. It will get you up to speed on a lot of important concepts and allow you to create a dashboard from start to finish in a relatively short amount of time. Starting with this dashboard will make it easier for you to create the following dashboards.
Customer Survey Dashboard (Google Forms Dashboard)
Start building the customer survey dashboard
This dashboard focuses more on staging & analyzing data, and keeps the data visualizations simple. You will learn many ways to use the COUNTIF function, which is extremely important for being able to analyze data / make needed calculations for your dashboards.
Online Sales Dashboard (Interactive dashboard)
Start building the interactive sales dashboard
This dashboard will teach you how to make your dashboards interactive, and contains many more important formulas / concepts than the basic introductory sales dashboard. This dashboard contains an optional lesson that will introduce you to using multiple reports to feed a single dashboard.
Student Attendance Dashboard / Tracker (Simple + Advanced)
Start building the attendance dashboard
This dashboard is the largest dashboard, and contains the most dashboard methods / concepts. This dashboard has a simple version, as well as an advanced version that you can build / add to your existing dashboard, after finishing the simple version. This tutorial will also show you how to make trackers that show individual daily student attendance, and will also show you how to make individual tabs that show data specific to individual employees / teachers.
This dashboard will show you advanced concepts for using multiple reports to feed a single dashboard. In the simple version you will use two reports, and in the advanced version you will add in a third report.
Additional Dashboard Resources:
Creating graphs and charts (Example data included for each chart type)
