• Introduction & Why Google Spreadsheets are Awesome
Spreadsheet Basics
  • Creating, Renaming and Sharing
  • Formatting Data in Spreadsheets
  • 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!
  • Learning More about Data Manipulation
Creating Charts and Formulas
  • Building Formulas and Functions
  • Overview of Formula Types
  • Logic Formulas
  • Assignment: Create Your Own Formulas
  • Introduction to Charts and Graphs
  • Create Our First Chart!
  • Create a Scatterplot
  • Bonus Lecture: Discounted Access to Full-Featured Course