Course Highlights
  • Use Google Spreadsheets like Da Vinci
  • Create charts and graphs using Spreadsheet data
  • Format and customize any data
  • Use advanced tools like Macros, ImportHTML and Scripts to do things you can do with Excel
Curriculum

1 Topic
What we'll cover in this course

5 Topics
Creating Renaming and Sharing
Formatting Basics
Freezing Rows and Columns
Conditional Formatting
Formatting Quiz

5 Topics
Sorting Data
Filters and Filter Views
Find and Replace
Revision History
Data Manipulation Quiz!

11 Topics
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?

6 Topics
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

1 Topic
Note from Justin

8 Topics
Kinds of Lookups
Fun with VLOOKUP
Exercise: Using VLOOKUP
Answer to VLOOKUP Exercise
VLOOKUP Additional Resources
Fun with HLOOKUP
HLOOKUP Exercise
Lookups Quiz

8 Topics
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

4 Topics
Introduction to Macros
Writing our First Macro
Example: Write Your Own Macro
Macros Quiz!

3 Topics
Spreadsheet Add-ons
Using Spreadsheet Booster
Advanced Spreadsheet Booster

4 Topics
Google Spreadsheet Templates
Official Google Spreadsheet Resource
Bonuses
What did you think of the course? Plus bonus inside!

  Write a Review

Master Google Sheets (and see why it's better than Excel)

Go to Paid Course