Introduction
  • What we'll cover in this course
Spreadsheet Basics
  • Creating, Renaming and Sharing
  • Formatting Basics
  • Freezing Rows and Columns
  • Conditional Formatting
  • Formatting Quiz
Manipulating Data like a BOSS
  • Sorting Data
  • Filters and Filter Views
  • Find and Replace
  • Revision History
  • Data Manipulation Quiz!
Functions and Formulas
  • Building Formulas and Functions
  • Overview of Formula Types
  • List of All Formulas
  • Math Functions
  • Logical Functions
  • Text Functions
  • Left and Right
  • Find, Replace, Search, Split and Substitute
  • Assignment: Creating your own functions
  • Functions and Formulas Quiz
  • Questions?
Charts and Graphs
  • Introduction to Charts and Graphs
  • Different Kinds of Charts
  • Creating our First Chart!
  • Creating a Scatterplot
  • Assignment: Create your own chart!
  • Charts and Graphs Quiz
Advanced Google Spreadsheets
  • Note from Justin
Lookups
  • Kinds of Lookups
  • Fun with VLOOKUP
  • Exercise: Using VLOOKUP
  • Answer to VLOOKUP Exercise
  • VLOOKUP Additional Resources
  • Fun with HLOOKUP
  • HLOOKUP Exercise
  • Lookups Quiz
Pulling Data a Spreadsheet with ImportXML and ImportHTML
  • Introduction to ImportXML
  • ImportXML Syntax
  • Importing XML Data into Spreadsheets
  • Importing Alexa Data with ImportXML
  • ImportXML Resources
  • ImportXML Quiz
  • Using ImportHTML
  • ImportXML and ImportHTML quiz
Macros
  • Introduction to Macros
  • Writing our First Macro
  • Example: Write Your Own Macro
  • Macros Quiz!
Tools to Use with Google Docs
  • Spreadsheet Add-ons
  • Using Spreadsheet Booster
  • Advanced Spreadsheet Booster
Resources
  • Google Spreadsheet Templates
  • Official Google Spreadsheet Resource
  • Bonuses
  • What did you think of the course? Plus, bonus inside!