Master Google Sheets (And See Why It's Better Than Excel)

217 Enrolled
3 Hours
You save 93% -

48 Lessons (3h)

  • 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
  • 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
    What did you think of the course? Plus, bonus inside!

Organize Data & Access it Anywhere After You Discover the Perks of Google Sheets

Justin Mares


Justin Mares formerly ran growth at developer-tools company Exceptional (acquired by Rackspace in March of 2013). At Exceptional, he was responsible for growth and revenue across three separate developer tool products. While there, he built and managed an inside sales team, cut churn by more than 60%, tripled organic traffic, improved conversion rates through a series of A/B tests, and doubled average revenue per customer. In this role selling to developers, he also taught himself how to program (poorly), use tools like SQL and R, and familiarized himself with the entire stack of web technologies. Justin is also the co-author of “Traction Book,” a book about how startups can get traction.


Google Spreadsheets is an amazing alternative to Microsoft Excel, and it’s time you joined legions of satisfied Google converts. You’ll find it a valuable tool for compiling, editing, and sharing spreadsheet data, whether you’re drafting charts and graphs, utilizing sorting and filtering tools, or performing any other task.

  • Use Google Spreadsheets like you do Microsoft Excel w/ 3 hours of content
  • Visually represent your data w/ charts & graphs
  • Quickly write formulas & create powerful calculations
  • Use data tools like sorting, subtotaling & filtering
  • Write your own scripts & use Google addons to get more done
  • Create charts, tables, graphs & format data
  • Automate tasks w/ time-saving scripts & add-ons


Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels


  • Internet required
  • Google account


  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your cart is empty. Continue Shopping!
Processing order...