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!
ImportXML Syntax
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock