Best Google Sheets Courses

Find the best online Google Sheets Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Google Sheets Courses.

Google Sheets: Pivot Tables + Data Insights For Beginners!

Learn to explore data & uncover insights with Google Sheets pivot tables! Course taught by fmr Google Analytical Lead.

Created by Brian Moore - data analytics to inform business decisions

"]

Students: 20799, Price: Free

Students: 20799, Price:  Free

  • Do you have data in Google Sheets and not sure how to make it useful? Then this course is for you!

  • Do you want to get on the path to being Data-Savvy? Then this course is for you!

  • Do you want to grow your Google Sheets data skills? Then this course is for you!

This course has been *designed by a former Google Analytical Lead* so that you can get comfortable going from rows and columns of data in a Google Sheet to useful insights via pivot tables.

This course includes numerous hands-on examples and practice exercises that will get you feeling data-savvy.

As a bonus, practice exercises and lecture examples are included in a spreadsheet that you can keep as part of the course.

This course is broken out into 8 key sections:

  • Section 1: Introduction (what are pivot tables and how they are used in the real-world to surface data insights)

  • Section 2: An Overview of the Data Insights Pivot Table Process

  • Section 3: Applying the Data Insights Pivot Table Process

  • Section 4: Practice Exercises: Set 1 (Titanic Dataset)

  • Section 5: Solution Videos for Practice Exercises: Set 1 (Titanic Dataset)

  • Section 6: Practice Exercises: Set 2 (Red Wine Dataset)

  • Section 7: Solution Videos for Practice Exercises: Set 2 (Red Wine Dataset)

  • Section 8: Course Wrap + Bonus Content

The content has intentionally been curated for practitioners who want to apply learnings right away.

This is NOT a long drawn out course that goes deep in the weeds on academic theory.

Make the transition from decisions based on gut feel to data informed decision making!

Use this efficiently designed course to level up your data skills. Get started today! 

#AlwaysBeLearning

Master Google Sheets (and see why it’s better than Excel)

Ditch Excel and Learn Skills to Become a Google Spreadsheet Power User!

Created by Justin Mares - Traction Book author, growth at Airbrake/Exceptional

"]

Students: 18127, Price: $129.99

Students: 18127, Price:  Paid

**Updated to Include Google Sheets November 2015 Updates!!**

Become a master Google Docs user with this course on using Google Spreadsheets. You'll learn:

  • How to use Google Spreadsheets just like you use Microsoft Excel
  • 3 amazing tools only available in Google Spreadsheets
  • How to write your own scripts and use Google addons to get more done
  • How to create charts, tables, graphs and format data

This course will give you you everything you need to know about Google Spreadsheets.

From the fundamentals, to the most advanced features, after taking this class you will be able to use Spreadsheets like a MASTER. Pretty soon, you'll be using Spreadsheets better than most people can use Excel... and be able to take advantage of the super useful features that only Google Spreadsheets has to offer.

In this course, you will learn all of the following about Google Spreadsheets:

  • Learn how to navigate around Spreadsheets
  • Learn how to adjust the way data and information are displayed
  • Learn how to write formulas quickly and easily with the point-and-click method
  • Learn how to create powerful calculations
  • Learn how to visually represent your data with charts and graphs
  • Learn how to use data tools like sorting, subtotaling, and filtering
  • Learn how to automate tasks with time-saving scripts and addons
  • Learn Spreadsheets secrets and shortcuts

As bonus material, you will also learn two very incredible, and super valuable, skills:

  • how to harvest data from the web
  • how to create online forms which allow you to gather data from individuals

As an additional bonus, you can follow along and complete challenges and quizzes as you learn the material. You will also be shown how to find and download free Spreadsheet templates that will allow you to do all kinds of things.

Another great aspect of this course is that, at the end of this class, you will be given a CERTIFICATE OF COMPLETION.

This class is guaranteed to teach you Google Spreadsheets. Once enrolled, you will have access to this course for the rest of your life. You will always be able to come back to this class to review material or to learn new material. Try this course for yourself and see how quickly and easily you too can learn to use Google Spreadsheets.

Justin Mares, Google Sheets wizard

The Complete Google Sheets Course: Beginner to Advanced!

A crash course in basic and advanced functions: Learn VLOOKUP, QUERY & MORE! Use many of these skills in Excel too!

Created by Evan Ramsey - Professional Spreadsheet Nerd

"]

Students: 17797, Price: $129.99

Students: 17797, Price:  Paid

In this course you will learn the fundamentals of Google Sheets (much of which translates to MS Excel!). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like VLOOKUP, INDEX(MATCH()MATCH()), and IMPORTRANGE.

Never heard of those before? Don't worry! I start from the beginning - so those terms will become clear when the time is right.

Along the way, you will develop an amazing spreadsheet toolkit. Wondering what tools will be in that toolkit? Check out the list below for some highlights of the course:

  1. Learn the basics like how to create a Google Account and a Google Spreadsheet

  2. Arithmetic Functions like SUM, COUNT, and AVERAGE

  3. Shortcuts like filling formulas across THOUSANDS of cells

  4. Advanced charts & Beautiful Visualizations

  5. PIVOT TABLES - though I don't particularly like them...

  6. Advanced functions like INDEX MATCH MATCH and IMPORT RANGE

  7. QUERY, the function that DOES IT ALL! NOTE: More lectures incoming on this one :)

Ultimately, the point of this course is to get some awesome skills for professional or personal use. And - above all - have fun doing it!

My course isn't like a lot of other online Excel or Google Sheet courses. Most of these courses force you to watch them build things and hope that you understand what they are doing. Instead of that old model, I've incorporated everything I've learned from my experience in the real professional world to make this the best online Google sheets course. The course includes:

  • Lectures

  • Activities

  • Projects

  • Exercises

  • Slides

  • Comprehensive Workbooks WITH Answer Keys

  • Extra Learning Resources

If you have any questions, please don't hesitate to contact me. Sign up today and see how fun, exciting, and rewarding web development can be!

Complete Introduction to Google Data Studio 2021 Edition

Learn how to create POWERFUL data analysis and dashboards with Google Data Studio for your Google Sheets

Created by Ian Littlejohn - Excel Power Tools, Power BI and Google Data Studio Trainer

"]

Students: 11434, Price: $99.99

Students: 11434, Price:  Paid

If you are new to Google Data Studio or want to fill in some gaps in your knowledge, THIS is the course for you.  We've focused on providing you with the fundamentals you need to work with Data Studio effectively! 

Don't sit through days of boring training to understand how Data Studio works! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming a Google Data Studio expert

This course has been updated for 2021 in full HD video quality, so you will learn on the latest Data Studio interface. Students who have taken this course have this to say:

"Great Introduction to Google Data Studio. Highly informative, succinct. All concepts were explained clearly. Glad to have taken this course."

"Very enjoyable course. I look forward to trying things taught in the future. Recommended!"

"Superb course. Great practical examples and tests. Enjoyed the case studies as well"

"Great examples, tips, tricks, high recommended for data studio learning. Really teaches beginner and adds on some great advanced stuff to help you out."

In this course you will learn the BEST techniques and tools for turning data into MEANINGFUL analysis using Google Data Studio

This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. 

**** Life time access to course materials and practice activities.  100% money back guarantee ****

In this course we are going to show you how to SUPERCHARGE your Google Sheets into Interactive Dashboards and INCREDIBLE reports.  Google Data Studio works seamlessly with your Google Sheets data to create amazing data analysis in minutes.

Google Data Studio is an incredibly easy to use drag and drop tool that allows a multitude of different visualizations to be created in minutes.  The addition of filtering tools produces stunning reports that will take your data analysis to the next level.

Google Data Studio is available free to people with a Google or Gmail account.  

In this course we are going to teach you the following:

  • How to connect Data Studio to Google Sheets

  • Learn how to calculate Averages, Highest values, Lowest Values and number of Unique Values

  • Create Scorecards to display key metrics and KPIs

  • Create powerful trend analysis graphs to help with forecasting

  • Create Year to Date, Month to Date and Previous Month calculations with the click of a mouse button

  • Learn to gain powerful analysis from Stacked Bar and 100% graphs

  • Create powerful Time and Category filters to easily create interactive reports

  • Learn to share your Reports and Dashboards with other users

Google Data Studio is truly an amazing product for creating insight and intelligence from your Google Sheets data.

Automate Your G Suite Administration with Google Sheets

Save time in G Suite Administration by automating it with this free Google Sheet Add on and become a Pro Admin today.

Created by Goldy Arora - G Suite Certified Consultant

"]

Students: 8865, Price: Free

Students: 8865, Price:  Free

Are you a G Suite Administrator investing so much time in G Suite Admin console to manage your users, groups, members and aliases?

Are you wondering what if there is an automated (but easy to use) way to do all that?

I feel you as I have been there.

I am an active G Suite Administrator and was struggling with this too, all I could find are couple of tools to automate my G Suite Administration but they were either costly or were not easy to use.

Because I make my living helping businesses move to G Suite, I thought there should be a better way, and started writing google apps script to help myself saving time.

As its working great for me, I thought to put all those scripts together and convert them in an easy to use Google Sheet Add on, so my fellow G Suite Admins (like you) can easily administer G Suite right from their Google sheet with just couple of clicks.

So what this tool can do for you right from your Google Sheet?

1. Manage G Suite Users

-- Bulk Create G Suite Users

-- Bulk Update G Suite Users

-- Bulk Suspend G Suite Users

-- Bulk Delete G Suite Users

-- Export All your G Suite Users with one click

2. Manage G Suite Aliases

-- Bulk Create G Suite User Aliases

-- Bulk Delete G Suite User Aliases

-- Export G Suite User Aliases

3. Manage G Suite Groups

-- Bulk Create G Suite Groups

-- Bulk Delete G Suite Groups

-- Export All G Suite Groups

4. Manage G Suite Group Memberships

-- Bulk Add Members to G Suite Groups

-- Bulk Remove Members from G Suite Groups

-- Export Members of G Suite Group

I am a full time employed, but try to add more features to this add on as I get sometime, so if you have any suggestion, don't hesitate to suggest.

Google Sheets – The Comprehensive Masterclass

Learn Google Sheets in 2020! Solve Complex Data Analysis Problems. Become an Expert: Learn Pivot Tables, QUERY & more

Created by Leila Gharani - Microsoft MVP, Bestselling Instructor

"]

Students: 7210, Price: $109.99

Students: 7210, Price:  Paid

This is the only Google Sheets course you’ll ever going to need: Because it’s going to teach you everything you need to know. From data collection, automation, to proper data analysis and visualization.

What will happen by the end of the course:

  1. You'll be a confident spreadsheet user

  2. You'll be the one that brings solutions to the table instead of problems

  3. You can tackle complex data analysis with ease

  4. You'll create interactive and compelling dashboards in Google Spreadsheets

  5. You'll know the right way to approach a problem

What you'll learn to get there:

  • Properly input and collect data and navigate large Google spreadsheets

  • Best practice and useful (& sometimes hidden) Sheets features

  • Sort, Filter, create Filter views and clean data in Google spreadsheets

  • Lookup functions in Google Sheets such as VLOOKUP, INDEX & MATCH, FILTER & SORTN.

  • Essential Summarization Functions like SUM, COUNT, SUMIFS, COUNTIFS etc.

  • Branching functions like Google Sheets IF and IFS functions.

  • Combining data from other Google Sheets with IMPORTRANGE

  • QUERY Function to create ANY analysis you want (You'll learn the key to getting this right)

  • Pivot tables, Charts & Slicers in Google Sheets to present your data

  • How to automate your work with macros & Google Apps Script

How you will learn:

  • Lots of challenges & exercises

  • Practice activities where you need to find the mistakes

  • Quizzes

  • You get access to ALL the files I use. The START files so you can follow along with me and the SOLUTION files in case you get stuck.

  • If you're a current spreadsheet user take the pre-assessment quiz to discover your weak spots.

I promise, we'll have fun!

Why Learn Google Sheets?

The way we’re using spreadsheets is changing. More of our work and collaboration is done through online channels, our spreadsheets are also moving online. Google Sheets is an online spreadsheet program that offers solutions many companies need right now.

In the past the main requirement companies had was for professionals to have solid knowledge in Microsoft Excel. Now they are looking for more.

As a business professional it's important to master the important applications. You don't need to know them all. Just the important ones.

And something else you may not know ...

You can apply MOST of the knowledge you learn in this Google Sheets course to Microsoft Excel as well!

There are many helpful and time-saving Google Sheets formulas and features. We tend to forget what these are if we don't use them. This course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.

Why Take This Specific Google Sheets Course?

This Comprehensive Google Sheets Masterclass is simply like no other Google spreadsheet course out there. I don’t say that lightly.

This course will get you confident and comfortable designing simple to complex spreadsheets. You'll go beyond Sheets basics. As you go through the course, you'll be able to apply what you learnt immediately to your job.

You'll master new formulas and learn new function so you can find better ways to setup your existing spreadsheets. Management loves efficiency.

In this course you'll solve dozens of practical real-world examples. They'll help you think outside the box so you can work smarter not harder.

Google Spreadsheet Data API Apps Script Code JSON JavaScript

How to use Data in a Google Sheet to output as JSON for your website sharing Google Sheets as JSON get data with AJAX

Created by Laurence Svekis - Instructor, GDE, Application Developer

"]

Students: 6166, Price: Free

Students: 6166, Price:  Free

Explore how you can output and share Google Sheets Content as JSON in a Web app with Apps Script Code

****** IF YOU HAVE NOT CODED BEFORE DO NOT TAKE THIS COURSE ******* PLEASE READ THE PREREQUISITES BEFORE JOINING!!!

JavaScript and Google Apps Script as the backend code to use a Google Spreadsheet as a Data source for your website. 

Create a Google Sheets Spreadsheet in your Google Account - Add some data and then output it as JSON which can be retrieved via fetch request to your WebSite.  Source Code is included so you can build your own version of the application.   

  • Creating a spreadsheet with data - making the JSON object dynamic

  • How to output your sheet data as an array in a web app endpoint doGet() method for webapp

  • Restructure your JSON object with JavaScript object properties values coming dynamically from the sheet headers

  • Iterate through the sheet rows of content and assign row values into the data object to output JSON for API endpoint

  • Use of JavaScript Fetch to get data JavaScript Connection using Fetch

  • JavaScript Fetch JSON sheet data from web app URL and output it in the console

  • Use JavaScript to output JSON data to webpage

  • Adding click event buttons Interactive Page Buttons JavaScript - to send info from webpage to Google Sheet

  • Using Apps Script POST data from WebPage to Sheet using doPost() method

  • Apps Script Add Post Data to Sheet connecting the data JSON

  • Explore how to use Google Apps Script IDE to debug and troubleshoot application

  • Use of JavaScript Fetch and formData methods

  • Common CORS issues with Google Apps Web Apps - how to troubleshoot and debug

  • Use of Logger to log values and text functions to text Google Apps Script

Taught by a Google Developer Expert with many years of Application development Experience ready to help you learn and answer any questions you may have

What are you waiting for join now and see what AMAZING projects YOU can create within Google apps Script and JavaScript

New Course - Use Google Sheets data on your WEBSITE - create JSON from Sheets data and connect using Fetch - POST updates to Sheet from your WEBSITE

Labels Manager for Gmail

Manage Your Gmail labels in bulk right from your Google sheet, easily export, create, update or delete Gmail labels.

Created by Goldy Arora - G Suite Certified Consultant

"]

Students: 3140, Price: Free

Students: 3140, Price:  Free

A few months ago I was helping an enterprise customer to transition to G Suite, and we were using a 3rd party data migration tool, due to some issues, couple of thousand users got hundreds of weird looking labels in their Gmail, and it became a mess.

I invested some time in writing a script which could go to their Gmail labels and delete the unwanted ones in bulk, as I already had these scripts, I thought to publish them as a google sheet extension (just in case if someone else come with the use case).

So, if you want to manage your Gmail labels in bulk, right from your Google sheet, this add on can help, it can do following for you-:

1. Export all your Gmail labels in your google sheet with rich details like label name, background/text color, total email count in each label, unread email count in each label, labels visibility (show/hide).

2. Create Gmail labels in bulk (including nested labels) right from your google sheet with rich information like label name, background/text color, show/hide visibility.

3. Deleted the labels in bulk right from your google sheet (Tip - export your labels to see which labels have no emails, and then delete them).

4. Update your Gmail  labels in bulk right from your Google sheet including label rename, change color, move nested labels from one parent label to another.

Master Microsoft Excel & Google Sheets: 2 courses in 1

Master Google Docs & Microsoft Word: The world's most-used productivity tools. Be a pro with 2 in 1 course. Enroll now!

Created by R Tutor - A expert team of Professors and a Lawyers

"]

Students: 2987, Price: Free

Students: 2987, Price:  Free

Welcome to the comprehensive course on Master Microsoft Excel: Create and edit spreadsheets.

R Tutor is a team of software applications training professionals who explain complex information in the simplest form with relevant examples.

Learn the two most powerful productivity tools available today. Learning both the courses will make you super productive and efficient at the same time. This dual course is greatly helpful for converting from another office suite such as MS Office

The Excel spreadsheet app lets you create, view, edit, and share your files with others quickly and easily. Create spreadsheets, data analyses, charts, budgets, and more while you view and edit workbooks attached to email messages. Edit documents for data analysis, accounting, finance, or any other fields with confidence. When on the go, your data and office move with you. Create charts, run data analysis and annotate your documents from your phone at any time. Create formulas and spreadsheets, review your charts or start a budget on the go. Create formulas, edit documents, manage budgets, and design spreadsheets with Microsoft Excel today. This course covers every aspect of Microsoft Excel.

On completion of the course, you will be able to: 1_2_3_

No prior knowledge of Microsoft applications is required.

Everyone can take this course and is best suited for:

Students of high school, college, and university. Professionals and employees looking to increase their productivity. Everyone who is involved with office tools in their everyday work.

Your wait is now over. Here is the course which helps you get started and pave your success from a beginner to an expert. It's easy! Enroll now!

Apps Script OnOpen Trigger new Web URL Project G Suite

Explore Google Apps Script G Suite integration with Sheets, setup of Triggers and creating client side JavaScript

Created by Laurence Svekis - Instructor, GDE, Application Developer

"]

Students: 2742, Price: Free

Students: 2742, Price:  Free

Explore using Google Apps Script to connect to onOpen script functions, setup UI modal, add UI menu buttons and create Client side JavaScript.  Apps Script OnOpen Trigger new Web URL Project G Suite

This course idea was a result of several students requests on this topic, I enjoy Google apps script and always happy to provide interesting solutions to coding challenges. 

JavaScript and Google Apps Script are prerequisites to this course - DO NOT TAKE this course without prior coding experience.

  • Setup a UI modal

  • Setup Triggers to run functions on Open of Sheets

  • Bound script to sheets

  • Client Side HTML handling and request of value from Google Script

  • Run JavaScript code on sheet open

  • Setup of triggers.

Source Code is included.

Taught by an instructor with many years of web development experience.  Google Developer Expert for G Suite. Ready to help you learn more about Google Apps Script.  With fast and friendly support within the Q&A section.

Are you ready to build you own version of the app, make it even better, do more....   What are you waiting for see what you can do with Google Apps Script! Join NOW.

Google Apps Script Web App and Client Side Data

Create a WebApp Send Data to your Spreadsheet Use Request Parameters to track users Generate new user sheets

Created by Laurence Svekis - Instructor, GDE, Application Developer

"]

Students: 2606, Price: Free

Students: 2606, Price:  Free

One of the most commonly asked questions is HOW to Create a Webapp that connects to Spreadsheets, and that you can send and receive sheet data from .

This course is perfect to learn more about the power of Google Apps Script and how you can use it to create amazing interactive applications.

Flexible content is designed to let you learn and then build upon that knowledge to create your own version of the app.

Use this app to track user info - each user gets their own app url with id that tracks into one spreadsheet on separate sheets.

Send input data to sheet - track and access.  Generate new user URLS within the Sheet UI.

Explore how you can create a custom Google Sheet option within your Google Sheets UI menu.

Explore Google Apps Script and how it can be used to run code using data from your Spreadsheet

Discover the amazing things you can do with Google Apps Script

Course covers some of the commonly asked for functionality using Google Apps Script and Google Spreadsheets

  • Create a Web App

  • Send data from a sheet to Web app client side

  • JavaScript to manipulate elements and create interactive pages

  • Modal popup interface to generate web urls for users.

  • Source code is included

  • Send input field data back to Google Apps Script to add to the spreadsheet sheet

JavaScript and prior coding experience is REQUIRED DO NOT TAKE THIS COURSE WITHOUT JavaScript Experience

Source code is included - Best way to learn is to try the code and create your own version of this project

Taught by an instructor with over 20 years of web development experience ready to help you learn

Google Developer Expert - Laurence Svekis walks you through how to do some amazing functionality to save time and get the most out of Google Apps Script G Suite content

Fast friendly support is always available in the Q&A section

What are you waiting for - this could change everything - at least change the way you use Google Apps and G Suite Google Sheets

Google Data Studio | Beginner to Expert

Create reports & data visualisations from Google Analytics, Google Sheets, BigQuery or any other data source

Created by Ruben Portz - Creator of ZebraFarm and Head of Growth at Seneca Learning

"]

Students: 1856, Price: Free

Students: 1856, Price:  Free

The goal of this course:
Be able to create insightful visualisations and data reports no matter what data source you've been given

To achieve this we'll go over:
- Basics of Google Data Studio
- How to add Data Sources (e.g. Google Analytics, Sheets, BigQuery, MySQL, Google Ads, Search Console, etc.)
- Add, format and style visualisations
- Manipulating data with date ranges, filters and segments
- Creation of custom metrics & blending of data sources
- Exporting, emailing & sharing of reports

For the visualisations, we'll go over: Graphs, Tables, Pivot Tables, Column & Bar Charts, Pie Charts, Geographic Maps, Scatterplots, and Score Cards

Learn Google Apps Script and Become a Google Sheets Master

Use Google Apps Script to automate repetitive tasks, create custom functions, import data & connect to external tools

Created by Ruben Portz - Creator of ZebraFarm and Head of Growth at Seneca Learning

"]

Students: 1535, Price: Free

Students: 1535, Price:  Free

Google Apps Script for Google Sheets

In this course, I'll show you how to create:

  • Custom functions

  • Ways to automate repetitive tasks

  • Fetch data from external sources

  • Send data from sheets to external tools like Slack

  • Trigger scripts automatically while asleep

  • Change the spreadsheet layout with menus, sidebars and popups

To help you navigate the world of Apps Scripts, I've created a cheat sheet with the most important functions. This should take you through to the end of the course even if you've never worked with JavaScript.

Google Sheets Functions for Growth Marketing & Product Teams

Covering the top 20 functions to import, clean & analyse data (Inc. Pivot Tables, IMPORTXML, VLOOPUP, INDEX & QUERY)

Created by Ruben Portz - Creator of ZebraFarm and Head of Growth at Seneca Learning

"]

Students: 1130, Price: Free

Students: 1130, Price:  Free

In the course you'll receive:

  • Practice dataset

  • Cheatsheet with 20+ functions

  • Short lectures explaining functions with examples

This course is designed to upskill your Google Sheets knowledge and is based on my experience leading growth teams and working day-to-day with Google Sheets. I've narrowed the course down to the top 20 most important functions that I use to import, clean, analyse and visualise data on a regular basis.

We will skip the basics of adding & subtracting and go right into the juicy stuff such as importing data with IMPORTXML and searching that data using QUERY. It will be no problem if these functions are completely new to you, as we'll cover all functions according to a practice dataset so that you can work alongside me and implement each function right away.

If you have any questions or requests, please don't hesitate to contact me.