Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Master Google Sheets (and see why it's better than Excel)
Introduction
What we'll cover in this course (1:14)
Spreadsheet Basics
Creating, Renaming and Sharing (6:39)
Formatting Basics (9:01)
Freezing Rows and Columns (1:56)
Conditional Formatting (4:51)
Manipulating Data like a BOSS
Sorting Data (4:19)
Filters and Filter Views (5:50)
Find and Replace (2:28)
Revision History (3:06)
Functions and Formulas
Building Formulas and Functions (9:53)
Overview of Formula Types (4:06)
List of All Formulas
Math Functions (5:28)
Logical Functions (8:27)
Text Functions (6:30)
Left and Right (5:07)
Find, Replace, Search, Split and Substitute (9:42)
Assignment: Creating your own functions
Charts and Graphs
Introduction to Charts and Graphs (0:52)
Different Kinds of Charts (5:05)
Creating our First Chart! (7:51)
Creating a Scatterplot (4:00)
Assignment: Create your own chart!
Advanced Google Spreadsheets
Note from Justin
Lookups
Kinds of Lookups
Fun with VLOOKUP (6:43)
Exercise: Using VLOOKUP
Answer to VLOOKUP Exercise (3:36)
VLOOKUP Additional Resources
Fun with HLOOKUP (2:03)
HLOOKUP Exercise
Pulling Data a Spreadsheet with ImportXML and ImportHTML
Introduction to ImportXML (1:30)
ImportXML Syntax
Importing XML Data into Spreadsheets (5:49)
Importing Alexa Data with ImportXML (8:47)
ImportXML Resources
Using ImportHTML (7:32)
Macros
Introduction to Macros (0:57)
Writing our First Macro (5:37)
Example: Write Your Own Macro
Tools to Use with Google Docs
Spreadsheet Add-ons
Using Spreadsheet Booster (4:56)
Advanced Spreadsheet Booster (4:50)
Resources
Google Spreadsheet Templates
Official Google Spreadsheet Resource
Bonuses
What did you think of the course? Plus, bonus inside!
Assignment: Creating your own functions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock