Google Sheets - in 30 minutes or less!
4.3 (2 ratings)
9 students enrolled
Wishlisted Wishlist

# 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.3 (2 ratings)
9 students enrolled
Created by Ambrose Leung
Last updated 12/2016
English
English
Current price: \$12 Original price: \$30 Discount: 60% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
• 35 mins on-demand video
• 1 Article
• Access on mobile and TV
• Certificate of Completion

### Training 5 or more people?

What Will I 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
View Curriculum
Requirements
• Internet connection
• If you know how to use email, you'll be able to follow along
Description

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!

Who is the target audience?
• 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
Compare to Other Google Sheets Courses
Curriculum For This Course
17 Lectures
35:31
+
Let's get it started in here! ... with freeze frames and formulas
3 Lectures 07:07
Preview 00:48

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:

sum

countif

counta

unique

Using Formulas
02:36
+
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
01:04

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'
01:40
+
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
02:00

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

Index Match... revisited
02:29
+
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
02:57

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

Highlight duplicate items
04:55
+
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)
01:08

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

Publishing Charts
01:44
+
All Done!
1 Lecture 00:47

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

Conclusion
00:47
+
Bonus Lectures
4 Lectures 09:00
Bonus: Publish Google Analytics Charts (external video)
00:37

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
03:19

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

Preview 00:09