Google Sheets - in 30 minutes or less!
4.4 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
26 students enrolled

Google Sheets - in 30 minutes or less!

A hands-on, no-fluff tutorial covering just the most useful features - incl. formulas, charts, and pivot tables. Oh my!
4.4 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
26 students enrolled
Created by Ambrose Leung
Last updated 12/2016
Current price: $11.99 Original price: $19.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 35 mins on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Create surveys (and get notifications in email)
  • Lookup stock prices with formulas

  • Combine the data of 2+ different sheets (using index/match lookups)

  • Use pivot tables to impress your friends and family
  • Automatically color the data based on certain conditions
  • Internet connection
  • Google account to access Google Sheets
  • If you know how to use email, you'll be able to follow along

Don't waste your time on a 2+ hour tutorial, learn the most useful features of Google Sheets the efficient way - in less than 30 minutes!

If you're just looking for the good stuff, you've come to the right place.  In this course, you're going to get access to a spreadsheet that already has data in it so you aren't starting from scratch.

There is no need to be a data analyst, if you can use Gmail, you'll do great!

You will learn to use:

  • Formulas
  • Conditional formatting
  • Combination of data from 2+ different tables
  • Pivot tables
  • Publish Charts to your website

Learn Google Sheets the efficient way!  Let's get started!

All Videos come with Closed Captions (English) and are downloadable

Who this course is for:
  • People who aren't necessarily data analysts and want to manipulate small sets of data
  • People who are tight on time and want to learn the most useful features in Google Sheets
Course content
Expand all 17 lectures 35:31
+ Let's get it started in here! ... with freeze frames and formulas
3 lectures 07:07

Here we'll go over the interface and I'll show you how to freeze frames, and write text on a newline in the same cell.  We'll also cover how to stop turning your data into dates.

Preview 03:43

The formulas covered here are:






The link to the spreadsheet can be found in the resources.

Using Formulas
+ Splitting and Filtering
2 lectures 02:44

If you have a list like this: a,b,c,d,e,f  and you want to have a in column A, b in column B, etc.  here's how you do it.

Splitting comma separated strings into columns

Learn to filter and sort your data and use filter views to save the filter without changing the data.

Using filters and saving them as 'views'
+ Combining two datasets
2 lectures 04:29

The index match lookup is actually better than the vlookup formula because vlookup has restrictions where the data you're looking up has to be on the right.

Introducing the index match formula

Ok now what if you don't have a column value that uniquely identifies the row?

Index Match... revisited
+ Conditional Formatting
2 lectures 07:52

Did you know that the cells can be colored automatically based on their value or a formula?

Color code a todo list implemented as a spreadsheet

This is a feature in Excel, but not built into Google Sheets

Highlight duplicate items
+ Pivot Tables and Charts
3 lectures 03:33

Pivot tables can do much more than this, but this makes for a good intro

Preview 00:41

In the real application of Pivot tables, you would use them when you have data that is 'typed'.  That is, you want to group the information by a value that occurs frequently in a column.  Take a look at the worksheet to see what I mean.

Use a Pivot table for real (i.e. when you have "types" in your data set)

Did you know that you can publish charts to your site?  If you don't have a site, use or you can just share the URL.

Publishing Charts
+ All Done!
1 lecture 00:47

Congrats!  You can now talk about your latest pivot table conquest at the next cocktail party!

+ Bonus Lectures
4 lectures 09:00
Bonus: Publish Google Analytics Charts (external video)

Here, we'll cover how to sum up numbers only if the column next to it says "Bob".  I'll also explain what those $ mean when you see cells referred to like: $c$12

The URL for this sheet is:

Preview 04:55

Create multiple choice surveys and have the results automatically transferred to your form.

Bonus: Creating a survey in Google Sheets

If you liked what you saw here, let's keep in touch - I plan to release more productivity articles on my site at: - you can have random productivity tips delivered to your inbox as well.  Here's a sample email:

Preview 00:09